GPFR_DU_CYVWLNG

(SQL View)
 Index Back

DUCS Company contact Lang View

DUCS Company contact Related Language View

SELECT C1.GPFR_DUCS_TYPE , C2.GPFR_CONT_AD_COMP , C0.LANGUAGE_CD , C0.DESCR FROM PS_GPFR_DUCS_CONT1 C1 , PS_GPFR_DUCSC0_LNG C0 , PS_GPFR_DUCS_CONT0 C2 WHERE C1.GPFR_PAR1_TYPE = '2' AND C1.GPFR_DUCS_TYPE IN ('901','902') AND C0.GPFR_CONT_CD = C1.GPFR_CONT_CD AND C2.GPFR_CONT_CD = C0.GPFR_CONT_CD

  • Related Language Record for GPFR_DUCS_CCYVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DUCS_TYPE Character(3) VARCHAR2(3) NOT NULL GPFR: DUCS Type
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description