VIEW: APPS.PA_PROJ_COMMITMENT_STATUS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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