PV_GHP_LOC_VW4

(SQL View)
 Index Back

View by Location


SELECT A.BUSINESS_UNIT , A.buyer_id , D.LOCATION , SUM(D.qty_po) , SUM(D.merchandise_amt) FROM PS_PO_HDR A , PS_PO_LINE_DISTRIB D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PO_ID = D.PO_ID GROUP BY A.BUSINESS_UNIT, A.BUYER_ID, D.LOCATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: %EDIT_BUYER

3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

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