WM_WO_VNDLOC_VW

(SQL View)
 Index Back

WO Vendor Location View

Note: used in Sched PO Supplier Item Search

SELECT A.BUSINESS_UNIT , B.VENDOR_ID , C.VNDR_LOC , A.VENDOR_SETID , B.VENDOR_NAME_SHORT , B.NAME1 AS VENDOR_NAME1 , CASE WHEN D.DESCR = ' ' THEN C.VNDR_LOC ELSE D.DESCR END AS LOCATION_DESCR , CASE WHEN C.VNDR_LOC = B.DEFAULT_LOC THEN 'Y' ELSE 'N' END AS DEFAULT_LOC_FLG , A.ITM_SETID , A.CNTRCT_SETID FROM PS_WM_POITM_SET_VW A , PS_VENDOR B , PS_VENDOR_LOC C , PS_VNDR_LOC_SCROL D WHERE B.SETID = A.VENDOR_SETID AND C.SETID = B.SETID AND C.VENDOR_ID = B.VENDOR_ID AND C.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_VENDOR_LOC J WHERE J.SETID = C.SETID AND J.VENDOR_ID = C.VENDOR_ID AND J.VNDR_LOC = C.VNDR_LOC AND J.EFFDT <= %CurrentDateIn AND J.EFF_STATUS = 'A') AND D.SETID = C.SETID AND D.VENDOR_ID = C.VENDOR_ID AND D.VNDR_LOC = C.VNDR_LOC

# 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
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
6 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
7 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
8 DEFAULT_LOC_FLG Character(1) VARCHAR2(1) NOT NULL Use Default Location

Y/N Table Edit

9 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
10 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID