VIEW: APPS.PA_EVENTS_DELIVERABLE_V

Source

View Text - Preformatted

SELECT ev.event_id ,ev.project_id ,ev.task_id ,ev.event_num ,ev.event_type ,ev.completion_date ,ev.description ,ev.organization_id ,ev.bill_amount ,ev.revenue_amount ,ev.bill_hold_flag ,ev.revenue_distributed_flag ,ev.inventory_org_id ,ev.inventory_item_id ,ev.quantity_billed ,ev.uom_code ,ev.unit_price ,ev.bill_trans_currency_code ,ev.bill_trans_bill_amount ,ev.bill_trans_rev_amount ,ev.project_currency_code ,ev.project_rate_type ,ev.project_rate_date ,ev.project_exchange_rate ,ev.project_bill_amount ,ev.project_inv_exchange_rate ,ev.project_inv_rate_date ,ev.project_revenue_amount ,ev.project_rev_exchange_rate ,ev.project_rev_rate_date ,ev.projfunc_currency_code ,ev.projfunc_rate_type ,ev.projfunc_rate_date ,ev.projfunc_exchange_rate ,ev.projfunc_bill_amount ,ev.projfunc_inv_exchange_rate ,ev.projfunc_inv_rate_date ,ev.projfunc_revenue_amount ,ev.projfunc_rev_exchange_rate ,ev.projfunc_rev_rate_date ,ev.funding_rate_type ,ev.funding_rate_date ,ev.funding_exchange_rate ,ev.invproc_currency_code ,ev.invproc_rate_type ,ev.invproc_rate_date ,ev.invproc_exchange_rate ,ev.revproc_currency_code ,ev.revproc_rate_type ,ev.revproc_rate_date ,ev.revproc_exchange_rate ,ev.inv_gen_rejection_code ,ev.ADJUSTING_REVENUE_FLAG ,ev.ZERO_REVENUE_AMOUNT_FLAG ,ev.NON_UPDATEABLE_FLAG ,ev.AUDIT_COST_PLAN_TYPE_ID ,ev.AUDIT_REV_PLAN_TYPE_ID ,ev.REVENUE_HOLD_FLAG ,ev.Billed_Flag ,ev.deliverable_id ,ev.action_id FROM pa_events ev, pa_projects pr WHERE ev.completion_date is not null AND nvl(ev.bill_hold_flag, 'N') = 'N' AND ev.project_id = pr.project_id UNION ALL SELECT ev.event_id ,ev.project_id ,ev.task_id ,ev.event_num ,ev.event_type ,pvs.actual_finish_date ,ev.description ,ev.organization_id ,ev.bill_amount ,ev.revenue_amount ,ev.bill_hold_flag ,ev.revenue_distributed_flag ,ev.inventory_org_id ,ev.inventory_item_id ,ev.quantity_billed ,ev.uom_code ,ev.unit_price ,ev.bill_trans_currency_code ,ev.bill_trans_bill_amount ,ev.bill_trans_rev_amount ,ev.project_currency_code ,ev.project_rate_type ,ev.project_rate_date ,ev.project_exchange_rate ,ev.project_bill_amount ,ev.project_inv_exchange_rate ,ev.project_inv_rate_date ,ev.project_revenue_amount ,ev.project_rev_exchange_rate ,ev.project_rev_rate_date ,ev.projfunc_currency_code ,ev.projfunc_rate_type ,ev.projfunc_rate_date ,ev.projfunc_exchange_rate ,ev.projfunc_bill_amount ,ev.projfunc_inv_exchange_rate ,ev.projfunc_inv_rate_date ,ev.projfunc_revenue_amount ,ev.projfunc_rev_exchange_rate ,ev.projfunc_rev_rate_date ,ev.funding_rate_type ,ev.funding_rate_date ,ev.funding_exchange_rate ,ev.invproc_currency_code ,ev.invproc_rate_type ,ev.invproc_rate_date ,ev.invproc_exchange_rate ,ev.revproc_currency_code ,ev.revproc_rate_type ,ev.revproc_rate_date ,ev.revproc_exchange_rate ,ev.inv_gen_rejection_code ,ev.ADJUSTING_REVENUE_FLAG ,ev.ZERO_REVENUE_AMOUNT_FLAG ,ev.NON_UPDATEABLE_FLAG ,ev.AUDIT_COST_PLAN_TYPE_ID ,ev.AUDIT_REV_PLAN_TYPE_ID ,ev.REVENUE_HOLD_FLAG ,ev.Billed_Flag ,ev.deliverable_id ,ev.action_id From pa_events ev, pa_projects pr, pa_proj_elements ppe, pa_object_relationships obj1, pa_object_relationships obj2, pa_proj_elem_ver_schedule pvs where ev.completion_date is null and ev.project_id = pr.project_id and nvl(ev.bill_hold_flag, 'N') = 'N' and obj1.object_type_from='PA_TASKS' and obj1.object_type_to='PA_DELIVERABLE' and obj1.relationship_type='A' and obj1.relationship_subtype='TASK_TO_DELIVERABLE' and obj1.object_id_to2=obj2.object_id_from2 and obj2.object_type_from='PA_DELIVERABLE' and obj2.object_type_to='PA_ACTIONS' and ppe.proj_element_id =ev.action_id and obj2.object_id_to2=ppe.proj_element_id and ppe.object_type='PA_ACTIONS' and pvs.project_id = ppe.project_id and pvs.proj_element_id = ppe.proj_element_id

View Text - HTML Formatted

SELECT EV.EVENT_ID
, EV.PROJECT_ID
, EV.TASK_ID
, EV.EVENT_NUM
, EV.EVENT_TYPE
, EV.COMPLETION_DATE
, EV.DESCRIPTION
, EV.ORGANIZATION_ID
, EV.BILL_AMOUNT
, EV.REVENUE_AMOUNT
, EV.BILL_HOLD_FLAG
, EV.REVENUE_DISTRIBUTED_FLAG
, EV.INVENTORY_ORG_ID
, EV.INVENTORY_ITEM_ID
, EV.QUANTITY_BILLED
, EV.UOM_CODE
, EV.UNIT_PRICE
, EV.BILL_TRANS_CURRENCY_CODE
, EV.BILL_TRANS_BILL_AMOUNT
, EV.BILL_TRANS_REV_AMOUNT
, EV.PROJECT_CURRENCY_CODE
, EV.PROJECT_RATE_TYPE
, EV.PROJECT_RATE_DATE
, EV.PROJECT_EXCHANGE_RATE
, EV.PROJECT_BILL_AMOUNT
, EV.PROJECT_INV_EXCHANGE_RATE
, EV.PROJECT_INV_RATE_DATE
, EV.PROJECT_REVENUE_AMOUNT
, EV.PROJECT_REV_EXCHANGE_RATE
, EV.PROJECT_REV_RATE_DATE
, EV.PROJFUNC_CURRENCY_CODE
, EV.PROJFUNC_RATE_TYPE
, EV.PROJFUNC_RATE_DATE
, EV.PROJFUNC_EXCHANGE_RATE
, EV.PROJFUNC_BILL_AMOUNT
, EV.PROJFUNC_INV_EXCHANGE_RATE
, EV.PROJFUNC_INV_RATE_DATE
, EV.PROJFUNC_REVENUE_AMOUNT
, EV.PROJFUNC_REV_EXCHANGE_RATE
, EV.PROJFUNC_REV_RATE_DATE
, EV.FUNDING_RATE_TYPE
, EV.FUNDING_RATE_DATE
, EV.FUNDING_EXCHANGE_RATE
, EV.INVPROC_CURRENCY_CODE
, EV.INVPROC_RATE_TYPE
, EV.INVPROC_RATE_DATE
, EV.INVPROC_EXCHANGE_RATE
, EV.REVPROC_CURRENCY_CODE
, EV.REVPROC_RATE_TYPE
, EV.REVPROC_RATE_DATE
, EV.REVPROC_EXCHANGE_RATE
, EV.INV_GEN_REJECTION_CODE
, EV.ADJUSTING_REVENUE_FLAG
, EV.ZERO_REVENUE_AMOUNT_FLAG
, EV.NON_UPDATEABLE_FLAG
, EV.AUDIT_COST_PLAN_TYPE_ID
, EV.AUDIT_REV_PLAN_TYPE_ID
, EV.REVENUE_HOLD_FLAG
, EV.BILLED_FLAG
, EV.DELIVERABLE_ID
, EV.ACTION_ID
FROM PA_EVENTS EV
, PA_PROJECTS PR
WHERE EV.COMPLETION_DATE IS NOT NULL
AND NVL(EV.BILL_HOLD_FLAG
, 'N') = 'N'
AND EV.PROJECT_ID = PR.PROJECT_ID UNION ALL SELECT EV.EVENT_ID
, EV.PROJECT_ID
, EV.TASK_ID
, EV.EVENT_NUM
, EV.EVENT_TYPE
, PVS.ACTUAL_FINISH_DATE
, EV.DESCRIPTION
, EV.ORGANIZATION_ID
, EV.BILL_AMOUNT
, EV.REVENUE_AMOUNT
, EV.BILL_HOLD_FLAG
, EV.REVENUE_DISTRIBUTED_FLAG
, EV.INVENTORY_ORG_ID
, EV.INVENTORY_ITEM_ID
, EV.QUANTITY_BILLED
, EV.UOM_CODE
, EV.UNIT_PRICE
, EV.BILL_TRANS_CURRENCY_CODE
, EV.BILL_TRANS_BILL_AMOUNT
, EV.BILL_TRANS_REV_AMOUNT
, EV.PROJECT_CURRENCY_CODE
, EV.PROJECT_RATE_TYPE
, EV.PROJECT_RATE_DATE
, EV.PROJECT_EXCHANGE_RATE
, EV.PROJECT_BILL_AMOUNT
, EV.PROJECT_INV_EXCHANGE_RATE
, EV.PROJECT_INV_RATE_DATE
, EV.PROJECT_REVENUE_AMOUNT
, EV.PROJECT_REV_EXCHANGE_RATE
, EV.PROJECT_REV_RATE_DATE
, EV.PROJFUNC_CURRENCY_CODE
, EV.PROJFUNC_RATE_TYPE
, EV.PROJFUNC_RATE_DATE
, EV.PROJFUNC_EXCHANGE_RATE
, EV.PROJFUNC_BILL_AMOUNT
, EV.PROJFUNC_INV_EXCHANGE_RATE
, EV.PROJFUNC_INV_RATE_DATE
, EV.PROJFUNC_REVENUE_AMOUNT
, EV.PROJFUNC_REV_EXCHANGE_RATE
, EV.PROJFUNC_REV_RATE_DATE
, EV.FUNDING_RATE_TYPE
, EV.FUNDING_RATE_DATE
, EV.FUNDING_EXCHANGE_RATE
, EV.INVPROC_CURRENCY_CODE
, EV.INVPROC_RATE_TYPE
, EV.INVPROC_RATE_DATE
, EV.INVPROC_EXCHANGE_RATE
, EV.REVPROC_CURRENCY_CODE
, EV.REVPROC_RATE_TYPE
, EV.REVPROC_RATE_DATE
, EV.REVPROC_EXCHANGE_RATE
, EV.INV_GEN_REJECTION_CODE
, EV.ADJUSTING_REVENUE_FLAG
, EV.ZERO_REVENUE_AMOUNT_FLAG
, EV.NON_UPDATEABLE_FLAG
, EV.AUDIT_COST_PLAN_TYPE_ID
, EV.AUDIT_REV_PLAN_TYPE_ID
, EV.REVENUE_HOLD_FLAG
, EV.BILLED_FLAG
, EV.DELIVERABLE_ID
, EV.ACTION_ID
FROM PA_EVENTS EV
, PA_PROJECTS PR
, PA_PROJ_ELEMENTS PPE
, PA_OBJECT_RELATIONSHIPS OBJ1
, PA_OBJECT_RELATIONSHIPS OBJ2
, PA_PROJ_ELEM_VER_SCHEDULE PVS
WHERE EV.COMPLETION_DATE IS NULL
AND EV.PROJECT_ID = PR.PROJECT_ID
AND NVL(EV.BILL_HOLD_FLAG
, 'N') = 'N'
AND OBJ1.OBJECT_TYPE_FROM='PA_TASKS'
AND OBJ1.OBJECT_TYPE_TO='PA_DELIVERABLE'
AND OBJ1.RELATIONSHIP_TYPE='A'
AND OBJ1.RELATIONSHIP_SUBTYPE='TASK_TO_DELIVERABLE'
AND OBJ1.OBJECT_ID_TO2=OBJ2.OBJECT_ID_FROM2
AND OBJ2.OBJECT_TYPE_FROM='PA_DELIVERABLE'
AND OBJ2.OBJECT_TYPE_TO='PA_ACTIONS'
AND PPE.PROJ_ELEMENT_ID =EV.ACTION_ID
AND OBJ2.OBJECT_ID_TO2=PPE.PROJ_ELEMENT_ID
AND PPE.OBJECT_TYPE='PA_ACTIONS'
AND PVS.PROJECT_ID = PPE.PROJECT_ID
AND PVS.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID