WCS_CYC_MAN_VW

(SQL View)
 Index Back

Cyc Plan Manual Fund Page View

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

SELECT CFG.BUDGET_ID , CFG.BUDGET_START_DT , CFG.BUDGET_END_DT , CFG.WCS_CYCLE_STATUS , CFG.DESCR , VC.DESCR20 , CFG.CURRENCY_CD FROM PS_WCS_ECM_CYC_CFG CFG , PS_WCS_ECM_ACCESS ACSS , PS_WCS_ECM_CYC_VC VC WHERE CFG.BUDGET_ID = VC.BUDGET_ID AND CFG.BUDGET_START_DT = VC.BUDGET_START_DT 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: WCS_CYC_MAN_LVW

    • # 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 BUDGET_END_DT Date(10) DATE NOT NULL Budget End Date
    4 WCS_CYCLE_STATUS Character(3) VARCHAR2(3) NOT NULL Cycle Status
    BIP=Build In Progress
    BLT=Built
    CAN=Canceled
    DEF=Defined
    FIN=Closed
    OPN=Opened
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL