PV_GHP_CAT_VW5

(SQL View)
 Index Back

PO Ship View Summ by PO ID


SELECT B.BUSINESS_UNIT , A.vendor_id , A.BUYER_id , B.category_id , SUM(C.qty_po) , SUM(C.merchandise_amt) FROM PS_PO_HDR A , PS_PO_LINE B , PS_PO_LINE_SHIP C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.po_ID = B.PO_ID AND A.PO_ID = C.PO_ID AND b.LINE_NBR = C.LINE_NBR GROUP BY B.BUSINESS_UNIT, A.VENDOR_ID, A.BUYER_ID, B.CATEGORY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

3 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: %EDIT_BUYER

4 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_TBL

5 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
6 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label