View: PA_EVENTS_DELIVERABLE_V

Product:	PA - Projects
Description:	10 Sc only
Implementation/DBA Data:	APPS.PA_EVENTS_DELIVERABLE_V

View Text

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

Columns