EODP_PVTPRD_LVW

(SQL View)
 Index Back

Search ref View for EODP comp

Pivot reference language view for data privacy components

SELECT A.PTPG_PGRIDNAME , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSPGCORE A , PSXLATITEM B , PSXLATITEMLANG C WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND B.FIELDNAME = C.FIELDNAME AND B.FIELDVALUE = C.FIELDVALUE AND B.EFFDT = C.EFFDT

  • Related Language Record for EODP_PVT_PRD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description