View: PAFV_EVENTS

Product:	PA - Projects
Description:	Business view to show information about the events used to generate revenue and invoice for the projects. Business view to show information about the events used to generate revenue and invoice for the projects.
Implementation/DBA Data:	APPS.PAFV_EVENTS

View Text

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

Columns