AGC_SCIMAGE_LVW

(SQL View)
Index Back

AGC Search Image View Rel Lang

Activity Guide Composer Search Image View Related Language View

SELECT DISTINCT A.CONTNAME , B.LANGUAGE_CD , B.DESCR FROM PSCONTDEFN A , PSCONTDEFNLANG B WHERE A.CONTTYPE = 1 AND A.CONTNAME = B.CONTNAME AND A.ALTCONTNUM = B.ALTCONTNUM AND A.CONTTYPE = B.CONTTYPE

  • Related Language Record for AGC_SCIMAGE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Image Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description