VIEW: APPS.PA_PROJ_COMMITMENT_BASE_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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