[Home] [Help]
View: PA_PROJ_COMMITMENT_STATUS
Product: | PA - Projects |
Description: | View of project commitment costs, including requisitions, purchase orders, and pending vendor invoices |
Implementation/DBA Data: |
APPS.PA_PROJ_COMMITMENT_STATUS
|
View Text
SELECT C.PROJECT_NUMBER
, C.PROJECT_NAME
, C.PROJECT_ID
, SUM(C.REQ_AMOUNT_OPEN)
, SUM(C.PO_AMOUNT_ORDERED)
, SUM(C.PO_AMOUNT_DELIVERED)
, SUM(C.PO_AMOUNT_OPEN)
, SUM(C.AP_AMOUNT_PENDING)
FROM PA_PROJ_COMMITMENT_BASE_VIEW C GROUP BY C.PROJECT_NUMBER
, C.PROJECT_NAME
, C.PROJECT_ID
Columns
Name |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_ID |
REQ_AMOUNT_OPEN |
PO_AMOUNT_ORDERED |
PO_AMOUNT_DELIVERED |
PO_AMOUNT_OPEN |
AP_AMOUNT_PENDING |