PO_ITMSUBS_VW

(SQL View)
 Index Back

Procurement Line Grp PO

Procurement Line Group PO Header view for use on spend inquiry.

SELECT DISTINCT D.OPRID ,D.RUN_CNTL_ID ,B.ITM_SETID ,B.ORIG_INV_ITEM_ID ,B.INV_ITEM_ID ,B.DESCR254_MIXED2 ,B.DESCR254_MIXED ,A.BUSINESS_UNIT ,A.VENDOR_SETID ,A.VENDOR_ID ,A.BUYER_ID ,MIN(A.PO_DT) ,MAX(A.PO_DT) ,COUNT(*) ,SUM(C.MERCHANDISE_AMT) FROM PS_PO_HDR A , PS_PO_LINE B , PS_PO_LINE_SHIP C , PS_RUN_POITMSUBS D WHERE %Join(COMMON_KEYS, PO_HDR A, PO_LINE B) AND %Join(COMMON_KEYS, PO_LINE B, PO_LINE_SHIP C) AND B.ORIG_INV_ITEM_ID <> ' ' GROUP BY B.ITM_SETID ,B.ORIG_INV_ITEM_ID,B.DESCR254_MIXED2 ,B.INV_ITEM_ID,B.DESCR254_MIXED,A.BUSINESS_UNIT ,A.VENDOR_SETID ,A.VENDOR_ID ,A.BUYER_ID ,D.OPRID ,D.RUN_CNTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
4 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

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

Prompt Table: %EDIT_BUYER

12 FROM_DATE Date(10) DATE From Date
13 THRU_DATE Date(10) DATE Through Date
14 NBR_ROWS_RETURNED Number(5,0) INTEGER NOT NULL Number of Rows Returned
15 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label