AGC_CAT_CTX_LW

(SQL View)
 Index Back

AGC Category Context Rel Lg Vw

Activity Guide Composer Category Context Related Language View

SELECT TMPL1.AGC_TEMPLATE_ID , TMPL1.EFFDT , CTX.RECNAME , CTX.FIELDNAME , CTXL.LANGUAGE_CD , CTXL.DESCR100 FROM PS_AGC_TMPL_TBL TMPL1 , PS_AGC_CAT_CTX CTX , PS_AGC_CAT_CTX_LNG CTXL WHERE TMPL1.AGC_CATEGORY_ID = CTX.AGC_CATEGORY_ID AND CTX.AGC_CATEGORY_ID = CTXL.AGC_CATEGORY_ID AND CTX.EFFDT = CTXL.EFFDT AND CTX.RECNAME = CTXL.RECNAME AND CTX.FIELDNAME = CTXL.FIELDNAME AND CTX.EFFDT = ( SELECT MAX(CTX_ED.EFFDT) FROM PS_AGC_CAT_CTX CTX_ED WHERE CTX_ED.AGC_CATEGORY_ID = CTX.AGC_CATEGORY_ID AND CTX_ED.EFFDT <= TMPL1.EFFDT) UNION SELECT TMPL2.AGC_TEMPLATE_ID , TMPL2.EFFDT , CTXD.RECNAME , CTXD.FIELDNAME , CTXFL.LANGUAGE_CD , CTXFL.DESCR100 FROM PS_AGC_TMPL_TBL TMPL2 , PS_AGC_CAT_CTXDTA CTXD , PS_AGC_CTXDTA_FLDS CTXF , PS_AGC_CTXDTA_FLNG CTXFL WHERE TMPL2.AGC_CATEGORY_ID = CTXD.AGC_CATEGORY_ID AND CTXD.AGC_ENABLE_SBNR = 'Y' AND CTXD.AGC_CTXDTA_ID = CTXF.AGC_CTXDTA_ID AND CTXD.AGC_CTXDTA_FLD_ID = CTXF.AGC_CTXDTA_FLD_ID AND CTXF.AGC_CTXDTA_ID = CTXFL.AGC_CTXDTA_ID AND CTXF.AGC_CTXDTA_FLD_ID = CTXFL.AGC_CTXDTA_FLD_ID AND CTXD.EFFDT = ( SELECT MAX(CTXD_ED.EFFDT) FROM PS_AGC_CAT_CTXDTA CTXD_ED WHERE CTXD_ED.AGC_CATEGORY_ID = CTXD.AGC_CATEGORY_ID AND CTXD_ED.EFFDT <= TMPL2.EFFDT)

  • Related Language Record for AGC_CAT_CTX_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: AGC_CTXREC_VW

    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: AGC_CTXFLD_VW

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description