View: PABV_EVENTS

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_EVENTS

View Text

SELECT PE.EVENT_ID
, PT.TASK_ID
, PE.EVENT_NUM
, PE.DESCRIPTION
, PE.REVENUE_AMOUNT
, PE.BILL_AMOUNT
, PE.COMPLETION_DATE
, '_LA:BILL_HOLD_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:REVENUE_DISTRIBUTED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, 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
, AUDIT_REV_BUDGET_TYPE_CODE
, PE.ORGANIZATION_ID
, PPA.PROJECT_ID
, PE.EVENT_TYPE
, '_DF:PA:PA_EVENTS_DESC_FLEX:PE'
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
FROM PA_EVENTS PE
, PA_TASKS PT
, PA_PROJECTS_ALL PPA
WHERE PE.PROJECT_ID = PPA.PROJECT_ID
AND PE.TASK_ID = PT.TASK_ID(+) AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns