COUNTRY_CUR_LVW

(SQL View)
 Index Back

Rel. Lang. for COUNTRY_CUR_VW

The COUNTRY_CUR_TBL matches a country code with its currency codes. This view is used as prompt table to just show those currency codes for a specific country.

SELECT C.COUNTRY ,F.CURRENCY_CD ,F.LANGUAGE_CD ,F.EFFDT ,F.DESCRSHORT FROM PS_COUNTRYTBL_LANG C , PS_CURRENCY_CD_TBL B , PS_CURRCD_TBL_LANG F WHERE ( ( C.COUNTRY = B.COUNTRY AND B.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_CURRENCY_CD_TBL E WHERE E.CURRENCY_CD=B.CURRENCY_CD) ) OR ( C.COUNTRY IN ('AUT','FIN','IRL','LUX','PRT','BEL','ITA','ESP','NLD','DEU','FRA','GRC', 'MLT', 'CYP','SVK', 'SVN', 'EST','LTU', 'LVA') AND (B.CURRENCY_CD = 'EUR' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_CURRENCY_CD_TBL D WHERE D.CURRENCY_CD=B.CURRENCY_CD)) )) AND B.CURRENCY_CD = F.CURRENCY_CD AND B.EFFDT = F.EFFDT AND C.LANGUAGE_CD = F.LANGUAGE_CD

  • Related Language Record for COUNTRY_CUR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description