WCS_NODDESCR_LV

(SQL View)
 Index Back

Cycle Description

Language view used to get Compensation Cycle description for approvals.

SELECT HDR.BUDGET_ID , HDR.BUDGET_START_DT , HDR.TREE_NODE_NUM , NOD.LANGUAGE_CD , NOD.DESCR , MSG.MESSAGE_TEXT %Concat ' - ' %Concat NOD.DESCR FROM PS_WCS_AWE_NOD_HDR HDR , PS_WCS_NOD_STS_LNG NOD , PSMSGCATLANG MSG WHERE HDR.BUDGET_ID = NOD.BUDGET_ID AND HDR.BUDGET_START_DT = NOD.BUDGET_START_DT AND HDR.TREE_NODE_NUM = NOD.TREE_NODE_NUM AND NOD.LANGUAGE_CD = MSG.LANGUAGE_CD AND MSG.MESSAGE_SET_NBR = 1020 AND MSG.MESSAGE_NBR = 335 UNION SELECT HDR.BUDGET_ID , HDR.BUDGET_START_DT , HDR.TREE_NODE_NUM , MSG.LANGUAGE_CD , NOD.DESCR , MSG.MESSAGE_TEXT %Concat ' - ' %Concat NOD.DESCR FROM PS_WCS_AWE_NOD_HDR HDR , PS_WCS_ECM_NOD_STS NOD , PSMSGCATLANG MSG WHERE HDR.BUDGET_ID = NOD.BUDGET_ID AND HDR.BUDGET_START_DT = NOD.BUDGET_START_DT AND HDR.TREE_NODE_NUM = NOD.TREE_NODE_NUM AND MSG.MESSAGE_SET_NBR = 1020 AND MSG.MESSAGE_NBR = 335 UNION SELECT HDR.BUDGET_ID , HDR.BUDGET_START_DT , HDR.TREE_NODE_NUM , NOD.LANGUAGE_CD , NOD.DESCR , MSG.MESSAGE_TEXT %Concat ' - ' %Concat NOD.DESCR FROM PS_WCS_AWE_NOD_HDR HDR , PS_WCS_NOD_STS_LNG NOD , PSMSGCATDEFN MSG WHERE HDR.BUDGET_ID = NOD.BUDGET_ID AND HDR.BUDGET_START_DT = NOD.BUDGET_START_DT AND HDR.TREE_NODE_NUM = NOD.TREE_NODE_NUM AND MSG.MESSAGE_SET_NBR = 1020 AND MSG.MESSAGE_NBR = 335

  • Related Language Record for WCS_NODDESCR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
    2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
    3 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 WCS_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Group description concatanated with 'Group - ' for use in fluid approvals.