VNDR_CUR_PO_VW

(SQL View)
 Index Back

Supplier Location Currency Vie


SELECT DISTINCT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.CURRENCY_CD 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 B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL