VIEW: APPS.PABV_EVENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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