EOPCADSC_SECTVW

(SQL View)
 Index Back

Section ADS Compare Display VW

ADS display view for ADS Workbench compare. View for Page Composer EOPCMAIN_DISP record.

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

  • Related Language Record: EOPCADSC_SECVLG

    • # 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