EODP_CMPPRD_LVW

(SQL View)
 Index Back

Panelgroup View for EODP comp

Panelgroup view for data privacy components

SELECT PNLGRPNAME , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSPNLGRPDEFN 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_CMPPROD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description