PO_BUYNEWSCH_VW

(SQL View)
 Index Back

Sum List for new mode by item

01/19/01 CEL CN#WV802-1.0: Supplier Collaboration

SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.SETID , A.INV_ITEM_ID , A.BUSINESS_UNIT_IN , A.SCHED_FLAG , G.UNIT_MEASURE_STD , C.CATEGORY_CD , A.PO_SCHED_PRIORITY , A.BUYER_ID FROM PS_ITM_VND_BU_ATTR A , PS_ITM_CAT_SET_VW C , PS_MASTER_ITEM_TBL G , PS_INSTALLATION_PO F WHERE A.SCHED_FLAG = 'Y' AND A.SCHED_GROUP_CD = ' ' AND A.SETID = G.SETID AND A.INV_ITEM_ID = G.INV_ITEM_ID AND C.SETID = A.SETID AND C.CATEGORY_TYPE = F.CATEGORY_TYPE AND C.CATEGORY_ID = G.CATEGORY_ID AND A.INV_ITEM_ID NOT IN ( SELECT DISTINCT E.INV_ITEM_ID FROM PS_PO_COLL_SCH_DET E WHERE A.VENDOR_SETID = E.VENDOR_SETID AND A.VENDOR_ID = E.VENDOR_ID AND A.VNDR_LOC = E.VNDR_LOC AND A.INV_ITEM_ID = E.INV_ITEM_ID AND A.SETID = E.ITM_SETID AND A.BUSINESS_UNIT_IN = E.BUSINESS_UNIT_IN AND ( E.COLLAB_SCH_STATUS = '20' OR E.COLLAB_SCH_STATUS = '10'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 SCHED_FLAG Character(1) VARCHAR2(1) NOT NULL Schedule Flag
8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
9 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
10 PO_SCHED_PRIORITY Character(2) VARCHAR2(2) NOT NULL Schedule Priority
10=High
20=Medium
30=Low
11 BUYER_ID_SEL Character(30) VARCHAR2(30) NOT NULL Buyer