Project Expenditure Organization Details

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'