WCS_CYC_MAN_LVW

(SQL View)
 Index Back

Cyc Plan Manual Fund RLng View

Related Language View used as the search record for the Cycle Plan Manual Funding Page.

SELECT CFG.BUDGET_ID , CFG.BUDGET_START_DT , CFGL.LANGUAGE_CD , CFG.DESCR , VC.DESCR20 FROM PS_WCS_ECM_CYC_CFG CFG , PS_WCS_CYC_CFG_LNG CFGL , PS_WCS_ECM_ACCESS ACSS , PS_WCS_ECM_CYC_VC VC , PS_WCS_CYC_VC_LNG VCL WHERE CFG.BUDGET_ID = CFGL.BUDGET_ID AND CFG.BUDGET_START_DT = CFGL.BUDGET_START_DT AND CFG.BUDGET_ID = VC.BUDGET_ID AND CFG.BUDGET_START_DT = VC.BUDGET_START_DT AND VC.BUDGET_ID = VCL.BUDGET_ID AND VC.BUDGET_START_DT = VCL.BUDGET_START_DT AND CFGL.LANGUAGE_CD = VCL.LANGUAGE_CD AND VC.WCS_VC_CALC_TYPE = 'M' AND (CFG.WCS_CYCLE_STATUS = 'BLT' OR CFG.WCS_CYCLE_STATUS = 'CAN') AND ACSS.BUDGET_ID = CFG.BUDGET_ID AND ACSS.BUDGET_START_DT = CFG.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1

  • Related Language Record for WCS_CYC_MAN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget
    2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    5 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description