View: PA_PROJ_INVOICE_EVENTS_VIEW

Product:	PA - Projects
Description:	View of events included on project invoices. Full Description: is a view that displays detailed information for events included on a project invoices. You can use this view to easily report event details for a project invoice backup r
Implementation/DBA Data:	APPS.PA_PROJ_INVOICE_EVENTS_VIEW

View Text

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

Columns