[Home] [Help]
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
Name |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_ID |
TASK_NUMBER |
TASK_NAME |
REQ_AMOUNT_OPEN |
PO_AMOUNT_ORDERED |
PO_AMOUNT_DELIVERED |
PO_AMOUNT_OPEN |
AP_AMOUNT_PENDING |