VIEW: APPS.PA_PROJ_EVENTS_VIEW

Source

View Text - Preformatted

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 ,e.bill_trans_currency_code ,e.bill_trans_bill_amount ,e.bill_trans_rev_amount 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 ,e.bill_trans_currency_code ,e.bill_trans_bill_amount ,e.bill_trans_rev_amount

View Text - HTML Formatted

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
, E.BILL_TRANS_CURRENCY_CODE
, E.BILL_TRANS_BILL_AMOUNT
, E.BILL_TRANS_REV_AMOUNT
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
, E.BILL_TRANS_CURRENCY_CODE
, E.BILL_TRANS_BILL_AMOUNT
, E.BILL_TRANS_REV_AMOUNT