View: CE_FC_PAIO_DISC_V

Product:	CE - Cash Management
Description:
Implementation/DBA Data:	APPS.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