Project Expenditure Type Details

This query extracts Oracle Fusion Project Costing expenditure type setup details. It reports expenditure type name, active dates, expenditure type class, expenditure type ID, reference data set name, and DFF attribute for setup validation and reporting. Oracle describes expenditure types as classifications of cost used on project expenditure items, and the Manage Expenditure Types task is the setup page used to define and review them.
categories  Finance Project
back Back to Vault
xls Download Sample Report for Project Expenditure Type Details
SQL Download SQL Query for Project Expenditure Type Details

CSV SQL Query for Project Expenditure Type Details

Copy 
SELECT
    PETTL.EXPENDITURE_TYPE_NAME      AS Expenditure_Type_Name,
    PETB.START_DATE_ACTIVE           AS Expenditure_Type_Start_Date,
    PETB.END_DATE_ACTIVE             AS Expenditure_Type_End_Date,
    PSLV.FUNCTION                    AS Expenditure_Type_Class,
    PETTL.EXPENDITURE_TYPE_ID        AS Expenditure_Type_Id,
    FSS.SET_NAME                     AS Set_Name,
    PETB.ATTRIBUTE1                  AS Project_Expenditure_Type_DFF
FROM
    PJF_EXP_TYPES_TL                 PETTL,
    PJF_EXP_TYPES_B                  PETB,
    PJF_EXP_TYPES_B_ST               PETBST,
    FND_SETID_SETS                   FSS,
    PJF_EXPEND_TYP_SYS_LINKS         PETSL,
    PJF_SYSTEM_LINKAGES_VL           PSLV
WHERE
        PETTL.EXPENDITURE_TYPE_ID    = PETB.EXPENDITURE_TYPE_ID
    AND PETTL.LANGUAGE               = 'US'
    AND PETB.EXPENDITURE_TYPE_ID     = PETSL.EXPENDITURE_TYPE_ID
    AND PETSL.SYSTEM_LINKAGE_FUNCTION = PSLV.FUNCTION
    AND PETTL.EXPENDITURE_TYPE_ID    = PETBST.EXPENDITURE_TYPE_ID
    AND PETBST.SET_ID                = FSS.SET_ID
    AND FSS.LANGUAGE                 = 'US'

Project Expenditure Type 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