IN_BU_VNDR_VW3

(SQL View)
Index Back

View

11/99 Created.

SELECT DISTINCT B.SETCNTRLVALUE BUSINESS_UNIT ,A.VENDOR_ID , A.VNDR_LOC FROM PS_VENDOR_LOC A , PS_SET_CNTRL_REC B WHERE B.RECNAME = 'MASTER_ITEM_TBL' AND A.SETID = B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location