Project Expenditure Organization Details

This query extracts Oracle Fusion project expenditure organization setup details. It reports organization name, organization ID, classification code, organization status, and set name for expenditure organization setup and validation. A project expenditure organization is an organization classified to incur project expenditures.
categories  Finance Project
back Back to Vault
xls Download Sample Report for Project Expenditure Organization Details
SQL Download SQL Query for Project Expenditure Organization Details

CSV SQL Query for Project Expenditure Organization Details

Copy 
SELECT
    HOUFT.NAME                  AS Organization_Name,
    HOUCF.ORGANIZATION_ID       AS Organization_Id,
    HOUCF.CLASSIFICATION_CODE   AS Classification_Code,
    HOUCF.STATUS                AS Organization_Status,
    FSS.SET_NAME                AS Set_Name
FROM
    HR_ORG_UNIT_CLASSIFICATIONS_F      HOUCF,
    HR_ORGANIZATION_UNITS_F_TL         HOUFT,
    PER_DEPARTMENTS                    PD,
    FND_SETID_SETS                     FSS
WHERE
        HOUCF.ORGANIZATION_ID          = HOUFT.ORGANIZATION_ID
    AND HOUCF.CLASSIFICATION_CODE      = 'PA_EXPENDITURE_ORG'
    AND HOUFT.LANGUAGE                 = 'US'
    AND HOUFT.OBJECT_VERSION_NUMBER    = (
        SELECT
            MAX(HOUFT1.OBJECT_VERSION_NUMBER)
        FROM
            HR_ORGANIZATION_UNITS_F_TL HOUFT1
        WHERE
            HOUFT.ORGANIZATION_ID      = HOUFT1.ORGANIZATION_ID
    )
    AND HOUFT.ORGANIZATION_ID          = PD.ORGANIZATION_ID
    AND PD.SET_ID                      = FSS.SET_ID
    AND FSS.LANGUAGE                   = 'US'

Project Expenditure Organization Details in BI Connector

Try BI Connector  back
back Back to Vault

Can’t find the report you need?

Want to tweak one to fit your business logic?

Contact Sales
Banner