View: PA_PROJ_COMMITMENT_BASE_VIEW

Product:	PA - Projects
Description:	Base view of project commitment reporting view PA_PROJ_COMMITMENT_STATUS
Implementation/DBA Data:	APPS.PA_PROJ_COMMITMENT_BASE_VIEW

View Text

SELECT R.PROJECT_NUMBER
, R.PROJECT_NAME
, R.PROJECT_ID
, R.TASK_NUMBER
, R.TASK_NAME
, R.AMOUNT
, 0
, 0
, 0
, 0
FROM PA_PROJ_APPR_REQ_DISTRIBUTIONS R UNION ALL SELECT P.PROJECT_NUMBER
, P.PROJECT_NAME
, P.PROJECT_ID
, P.TASK_NUMBER
, P.TASK_NAME
, 0
, P.AMOUNT_ORDERED
, P.AMOUNT_DELIVERED
, P.AMOUNT_OUTSTANDING_INVOICE
, 0
FROM PA_PROJ_APPR_PO_DISTRIBUTIONS P UNION ALL SELECT P.SEGMENT1
, P.NAME
, P.PROJECT_ID
, NULL
, NULL
, 0
, 0
, 0
, 0
, 0
FROM PA_PROJECTS P UNION ALL SELECT I.PROJECT_NUMBER
, I.PROJECT_NAME
, I.PROJECT_ID
, I.TASK_NUMBER
, I.TASK_NAME
, 0
, 0
, 0
, 0
, I.AMOUNT
FROM PA_PROJ_AP_INV_DISTRIBUTIONS I

Columns