VNDR_ORDR_VW

(SQL View)
 Index Back

Order From View


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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ORDER_SETID Character(5) VARCHAR2(5) NOT NULL Order Supplier SetID
2 ORDER_VENDOR Character(10) VARCHAR2(10) NOT NULL Order Supplier ID