View: PA_PROJ_EVENTS_VIEW

Product:	PA - Projects
Description:	The view displays all relevant information for project events
Implementation/DBA Data:	APPS.PA_PROJ_EVENTS_VIEW

View Text

SELECT E.PROJECT_ID
, P.SEGMENT1
, P.NAME
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, E.EVENT_NUM
, E.EVENT_TYPE
, ET.EVENT_TYPE_CLASSIFICATION
, ET.DESCRIPTION
, E.COMPLETION_DATE
, E.DESCRIPTION
, E.ORGANIZATION_ID
, O.NAME
, ET.REVENUE_CATEGORY_CODE
, E.BILL_AMOUNT
, E.REVENUE_AMOUNT
, E.BILL_HOLD_FLAG
, E.REVENUE_DISTRIBUTED_FLAG
, DECODE(SUM(NVL(I.AMOUNT
, 0))
, 0
, 'N'
, 'Y')
, E.BILLING_ASSIGNMENT_ID
FROM PA_DRAFT_INVOICE_ITEMS I
, PA_TASKS T
, PA_PROJECTS P
, PA_EVENT_TYPES ET
, HR_ORGANIZATION_UNITS O
, PA_EVENTS E
WHERE P.PROJECT_ID = E.PROJECT_ID
AND T.TASK_ID (+) = E.TASK_ID
AND I.PROJECT_ID (+) = E.PROJECT_ID
AND NVL(I.EVENT_TASK_ID(+)
, 0) = NVL(E.TASK_ID
, 0)
AND I.EVENT_NUM(+) = E.EVENT_NUM
AND E.EVENT_TYPE = ET.EVENT_TYPE
AND O.ORGANIZATION_ID = E.ORGANIZATION_ID GROUP BY E.PROJECT_ID
, P.SEGMENT1
, P.NAME
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, E.EVENT_NUM
, E.EVENT_TYPE
, ET.EVENT_TYPE_CLASSIFICATION
, ET.DESCRIPTION
, E.COMPLETION_DATE
, E.DESCRIPTION
, E.ORGANIZATION_ID
, O.NAME
, ET.REVENUE_CATEGORY_CODE
, E.BILL_AMOUNT
, E.REVENUE_AMOUNT
, E.BILL_HOLD_FLAG
, E.REVENUE_DISTRIBUTED_FLAG
, E.BILLING_ASSIGNMENT_ID

Columns