VIEW: APPS.PA_PROJ_INVOICE_EVENTS_VIEW

Source

View Text - Preformatted

SELECT e.project_id , p.segment1 , p.name , item.draft_invoice_num , item.line_num , e.task_id , t.task_number , t.task_name , e.event_num , e.event_type , e.description , e.completion_date , item.amount , e.organization_id , o.name , e.billing_assignment_id FROM pa_events e, pa_draft_invoice_items item, pa_tasks t, pa_projects p, hr_all_organization_units o WHERE item.project_id = e.project_id AND nvl(item.event_task_id, 0) = nvl(e.task_id, 0) AND item.event_num = e.event_num AND p.project_id = e.project_id AND t.task_id (+) = e.task_id AND o.organization_id = e.organization_id

View Text - HTML Formatted

SELECT E.PROJECT_ID
, P.SEGMENT1
, P.NAME
, ITEM.DRAFT_INVOICE_NUM
, ITEM.LINE_NUM
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, E.EVENT_NUM
, E.EVENT_TYPE
, E.DESCRIPTION
, E.COMPLETION_DATE
, ITEM.AMOUNT
, E.ORGANIZATION_ID
, O.NAME
, E.BILLING_ASSIGNMENT_ID
FROM PA_EVENTS E
, PA_DRAFT_INVOICE_ITEMS ITEM
, PA_TASKS T
, PA_PROJECTS P
, HR_ALL_ORGANIZATION_UNITS O
WHERE ITEM.PROJECT_ID = E.PROJECT_ID
AND NVL(ITEM.EVENT_TASK_ID
, 0) = NVL(E.TASK_ID
, 0)
AND ITEM.EVENT_NUM = E.EVENT_NUM
AND P.PROJECT_ID = E.PROJECT_ID
AND T.TASK_ID (+) = E.TASK_ID
AND O.ORGANIZATION_ID = E.ORGANIZATION_ID