[Home] [Help]
View: CE_FC_PAIO_DISC_V
View Text
SELECT SRC.RESOURCE_ASSIGNMENT_ID||'X'||TRUNC(SRC.START_DATE)
, SRC.TRX_NUMBER
, SRC.REVENUE
, SRC.RAW_COST
, SRC.START_DATE || ' - ' || SRC.END_DATE
, SRC.START_DATE
, SRC.END_DATE
, SRC.PERIOD_NAME
, SRC.BURDENED_COST
, PAT.TASK_NAME
, HR.NAME FROM PA_CE_INTEGRATION_BUDGETS_V SRC
, PA_TASKS PAT
, PA_PROJECTS_ALL PAP
, HR_OPERATING_UNITS HR
WHERE SRC.TASK_ID = PAT.TASK_ID AND HR.ORGANIZATION_ID(+) = PAP.ORG_ID AND PAP.PROJECT_ID = SRC.PROJECT_ID
AND (PAP.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = PAP.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT'))
Columns
Name |
REFERENCE_ID |
TRX_NUMBER |
REVENUE |
RAW_COST |
PERIOD_DATE_RANGE |
START_DATE |
END_DATE |
PERIOD_NAME |
BURDENED_COST |
TASK_NAME |
ORGANIZATION |