EOQF_AG_USE_V1

(SQL View)
 Index Back

AGC use View

Activity Guide Step View

SELECT TMPL.AGC_TEMPLATE_ID , TMPL.EFFDT , STP.AGC_STEP_ID , TMPL.DESCR100 , ( SELECT COUNT(*) FROM PS_AGC_TMPL_STEPS X WHERE AGC_TEMPLATE_ID = TMPL.AGC_TEMPLATE_ID AND EFFDT = TMPL.EFFDT AND AGC_STEP_ID = STP.AGC_STEP_ID ) AS COUNT ,CTX.AGC_RC_PARAM_NAME, CTX.AGC_PARAM_VALUE FROM PS_AGC_TMPL_TBL TMPL , PS_AGC_CAT_TBL CAT , PS_AGC_CAT_STEP STP ,ps_agc_cat_stepctx CTX ,PS_AGC_TMPL_STEPS X1 WHERE TMPL.AGC_CATEGORY_ID = CAT.AGC_CATEGORY_ID AND CAT.EFFDT = ( SELECT MAX(CAT_ED.EFFDT) FROM PS_AGC_CAT_TBL CAT_ED WHERE CAT_ED.AGC_CATEGORY_ID = CAT.AGC_CATEGORY_ID AND CAT_ED.EFFDT <= TMPL.EFFDT) AND TMPL.EFFDT=( SELECT MAX(TMPL_ED.EFFDT) FROM PS_AGC_TMPL_TBL TMPL_ED WHERE TMPL.AGC_TEMPLATE_ID =TMPL_ED.AGC_TEMPLATE_ID ) AND STP.AGC_CATEGORY_ID = CAT.AGC_CATEGORY_ID AND STP.EFFDT = CAT.EFFDT AND CAT.AGC_CATEGORY_ID = CTX.AGC_CATEGORY_ID AND STP.AGC_STEP_ID =CTX.AGC_STEP_ID AND STP.AGC_STEP_ID =X1.AGC_STEP_ID AND CAT.EFFDT=CTX.EFFDT AND CTX.AGC_RC_PARAM_NAME IN ('EOQF_QSTNR_CODE' ,'EOQF_CATEGORY') AND STP.AGC_SERVICE_ID='EOQF_QSTNR_FL' AND X1.AGC_TEMPLATE_ID = TMPL.AGC_TEMPLATE_ID AND X1.EFFDT = TMPL.EFFDT AND X1.AGC_STEP_ID = STP.AGC_STEP_ID

  • Related Language Record: EOQF_AG_USE_LNG

    • # 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 AGC_STEP_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Step Id
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 AGC_ADDED_STEP_CT Number(3,0) SMALLINT NOT NULL Activity Guide Composer Added Step Count
    6 AGC_RC_PARAM_NAME Character(128) VARCHAR2(128) NOT NULL Activity Guide Composer Related Content Service Parameter Name
    7 AGC_PARAM_VALUE Character(254) VARCHAR2(254) NOT NULL Activity Guide Composer Parameter Value