ITM_VNDBU_REGVW(SQL View) |
Index Back |
---|---|
Itm not in itm vnd bu attr08/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 |