Project Task

This query extracts chargeable financial project tasks from Oracle Fusion Project Financial Management. It returns project number, task number, and task organization for reporting and validation. Oracle documentation describes financial tasks as project tasks used in financial planning and project management flows.
categories  Finance Project
back Back to Vault
xls Download Sample Report for Project Task
SQL Download SQL Query for Project Task

CSV SQL Query for Project Task

Copy 
SELECT
    TO_CHAR(PPAB.SEGMENT1)      AS Project_Number,
    PPEB.ELEMENT_NUMBER         AS Task_Number,
    HOU.NAME                    AS Task_Organization
FROM
    PJF_PROJECTS_ALL_B          PPAB,
    PJF_PROJ_ELEMENTS_B         PPEB,
    HR_ORGANIZATION_UNITS       HOU
WHERE
        PPEB.PROJECT_ID         = PPAB.PROJECT_ID
    AND PPEB.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
    AND PPEB.ELEMENT_TYPE       = 'FINANCIAL'
    AND PPEB.OBJECT_TYPE        = 'PJF_TASKS'
    AND PPEB.CHARGEABLE_FLAG    = 'Y'
ORDER BY
    PPAB.PROJECT_ID DESC,
    PPEB.ELEMENT_NUMBER DESC

Project Task 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