VNDR_LOC_SBI_VW

(SQL View)
 Index Back

Supplier Location View


select DISTINCT A.SETID, A.VENDOR_ID, A.VNDR_LOC from PS_VENDOR_LOC A where EFFDT = (select max(EFFDT) from PS_VENDOR_LOC B where A.SETID = B.SETID and A.VENDOR_ID = B.VENDOR_ID and A.VNDR_LOC = B.VNDR_LOC and EFFDT <= %currentdatein) and EFF_STATUS = 'A'

# 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