SSF_CURR_VW

(SQL View)
 Index Back

Country Currency View


SELECT C.COUNTRY ,B.CURRENCY_CD FROM PS_COUNTRY_TBL C , PS_CURRENCY_CD_TBL B WHERE C.COUNTRY = B.COUNTRY AND C.COUNTRY NOT IN ('AND','AUT','BEL','CYP','EST','FIN','FRA','DEU','GRC','IRL','ITA','KOS','LUX','MLT','MCO','MNE','NLD','PRT','SMR','SVK','SVN','ESP','VAT') AND B.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_CURRENCY_CD_TBL E WHERE E.CURRENCY_CD=B.CURRENCY_CD) AND B.EFF_STATUS = 'A' UNION SELECT C.COUNTRY ,B.CURRENCY_CD FROM PS_COUNTRY_TBL C , PS_CURRENCY_CD_TBL B WHERE C.COUNTRY IN ('AND','AUT','BEL','CYP','EST','FIN','FRA','DEU','GRC','IRL','ITA','KOS','LUX','MLT','MCO','MNE','NLD','PRT','SMR','SVK','SVN','ESP','VAT') AND B.CURRENCY_CD = 'EUR' AND B.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_CURRENCY_CD_TBL E WHERE E.CURRENCY_CD=B.CURRENCY_CD) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code