GP_SUMM_PVW_LNG

(SQL View)
 Index Back

Mobile Epay

Mobile Epay

SELECT A.COUNTRY ,A.LANGUAGE_CD ,%Upper(A.DESCR) FROM PS_GP_SUMM_PG_LNG A ,PS_GP_SUMM_PG_DSP B WHERE B.GP_DISP_IN_PRMPT='Y' AND B.COUNTRY=A.COUNTRY AND B.GP_ELN_APP=A.GP_ELN_APP AND B.SEQ_NUM=A.SEQ_NUM AND B.GP_ELN_CODE=A.GP_ELN_CODE ORDER BY A.GP_ELN_CODE

  • Related Language Record for GP_SUMM_PG_VW

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

    Default Value: ALL

    Prompt Table: GP_COUNTRY

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description