SCC_CNT_AFLN_VW

(SQL View)
 Index Back

View used in Add Address

View used in add address modal, hold countries that have address format defined.

SELECT country ,language_cd , descr FROM PS_COUNTRYTBL_LANG WHERE EXISTS( SELECT country FROM ps_eo_addr_fmt_tbl WHERE country = PS_COUNTRYTBL_LANG.country) AND NOT EXISTS( SELECT country FROM ps_scc_cntry_excl WHERE country = PS_COUNTRYTBL_LANG.country AND exclude_address='Y')

  • Related Language Record for SCC_CNT_ADFMTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description