ITM_VNDBU_REGVW

(SQL View)
Index Back

Itm not in itm vnd bu attr

08/01/02 CEL CN#WV880-1.0: Supplier Collaboration

SELECT B.VENDOR_SETID , B.VENDOR_ID , A.SETID , A.INV_ITEM_ID , C.VNDR_LOC , %Substring(E.SETCNTRLVALUE,1,5) , A.UNIT_MEASURE_STD , F.QTY_PRECISION , F.ROUND_RULE FROM PS_MASTER_ITEM_TBL A , PS_ITM_VENDOR B , PS_ITM_VENDOR_LOC C , PS_SET_CNTRL_REC E , PS_BU_ITEMS_INV D , PS_INV_ITEM_UOM F WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND B.SETID = C.SETID AND B.INV_ITEM_ID = C.INV_ITEM_ID AND B.VENDOR_SETID = C.VENDOR_SETID AND B.VENDOR_ID = C.VENDOR_ID AND B.ITM_STATUS = 'A' AND E.SETID = A.SETID AND E.RECNAME = 'MASTER_ITEM_TBL' AND D.BUSINESS_UNIT = E.SETCNTRLVALUE AND D.INV_ITEM_ID = A.INV_ITEM_ID AND F.SETID = A.SETID AND F.INV_ITEM_ID = A.INV_ITEM_ID AND F.UNIT_OF_MEASURE = A.UNIT_MEASURE_STD AND NOT EXISTS ( SELECT 'X' FROM PS_ITM_VND_BU_ATTR Z WHERE Z.VENDOR_SETID = B.SETID AND Z.VENDOR_ID = B.VENDOR_ID AND Z.SETID = A.SETID AND Z.INV_ITEM_ID = A.INV_ITEM_ID AND Z.VNDR_LOC = C.VNDR_LOC AND Z.BUSINESS_UNIT_IN = D.BUSINESS_UNIT)

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
8 QTY_PRECISION Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal
W=Whole Nbr
9 ROUND_RULE Character(1) VARCHAR2(1) NOT NULL Rounding Rule
D=Round Down
N=Natural Round
U=Round Up