EOPCADSC_SECVLG

(SQL View)
 Index Back

EOPCADSC_SECTVW language table

ADS display view language table for ADS Workbench compare. langauge View for Page Composer ADS display view EOPCADSC_SECTVW record.

SELECT MSG.MESSAGE_TEXT || ' ' || L1.SHORTNAME || '(' || X.XLATLONGNAME || '): ' || A.EOPCMAIN_DESCR254 || ', ' || A.DESCR254 , A.EOPCDEFN_ID , A.EOPCMAIN_ID , A.LANGUAGE_CD FROM PSDBFLDLABLLANG L1 , PSMSGCATLANG MSG , PSXLATITEMLANG X , PS_EOPCMAIN_LNG A , PS_EOPCMAIN_DISP T WHERE T.EOPCMAIN_ID = A.EOPCMAIN_ID AND X.FIELDNAME = 'EOPCFORM_FACTOR' AND ((X.FIELDVALUE = 'X' AND T.EOPCFORM_XLG = 'Y') OR (X.FIELDVALUE = 'L' AND T.EOPCFORM_LG = 'Y') OR (X.FIELDVALUE = 'M' AND T.EOPCFORM_MED = 'Y') OR (X.FIELDVALUE = 'S' AND T.EOPCFORM_SM = 'Y')) AND MSG.MESSAGE_SET_NBR = 18111 AND MSG.MESSAGE_NBR = 30000 AND L1.FIELDNAME = 'DESCR254' AND L1.LABEL_ID = 'EOPC_SECTION' AND A.LANGUAGE_CD = X.LANGUAGE_CD AND A.LANGUAGE_CD = L1.LANGUAGE_CD AND A.LANGUAGE_CD = MSG.LANGUAGE_CD

  • Related Language Record for EOPCADSC_SECTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Composer Section
    2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
    3 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code