VIEW: APPS.PAFV_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 , 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 , hou.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 , hr_all_organization_units hou , 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 = hou.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

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
, 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
, HOU.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
, HR_ALL_ORGANIZATION_UNITS HOU
, 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 = HOU.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