Product: | PA - Projects |
---|---|
Description: | Business view to show information about the events used to generate revenue and invoice for the projects. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PE.EVENT_ID
, PT.TASK_ID
, PE.EVENT_NUM
, PE.DESCRIPTION
, PE.REVENUE_AMOUNT
, PE.BILL_AMOUNT
, PE.COMPLETION_DATE
, AUDIT_AMOUNT1
, AUDIT_AMOUNT2
, AUDIT_AMOUNT3
, AUDIT_AMOUNT4
, AUDIT_AMOUNT5
, AUDIT_AMOUNT6
, AUDIT_AMOUNT7
, AUDIT_AMOUNT8
, AUDIT_AMOUNT9
, AUDIT_AMOUNT10
, AUDIT_COST_BUDGET_TYPE_CODE
, BUT1.BUDGET_TYPE
, AUDIT_REV_BUDGET_TYPE_CODE
, BUT2.BUDGET_TYPE
, PPA.ORG_ID
, PE.ORGANIZATION_ID
, POU.NAME
, PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PE.EVENT_TYPE
, PET.DESCRIPTION
, EVENT_NUM_REVERSED
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
, '_DF:PA:PA_EVENTS_DESC_FLEX:PE'
, '_LA:BILL_HOLD_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:REVENUE_DISTRIBUTED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
FROM PA_EVENTS PE
, PA_TASKS PT
, PA_PROJECTS_ALL PPA
, PA_EVENT_TYPES PET
, PER_ALL_ORGANIZATION_UNITS POU
, PA_BUDGET_TYPES BUT1
, PA_BUDGET_TYPES BUT2
WHERE PE.PROJECT_ID = PPA.PROJECT_ID
AND PE.TASK_ID = PT.TASK_ID(+)
AND PE.EVENT_TYPE = PET.EVENT_TYPE
AND PE.ORGANIZATION_ID = POU.ORGANIZATION_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL
AND PE.AUDIT_COST_BUDGET_TYPE_CODE=BUT1.BUDGET_TYPE_CODE (+)
AND PE.AUDIT_REV_BUDGET_TYPE_CODE=BUT2.BUDGET_TYPE_CODE (+) WITH READ ONLY