TN_LSTSCEVW_LNG

(SQL View)
 Index Back

Scenarios list View

Scenarios list View

SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , A.SCENARIO , C.LANGUAGE_CD , C.DESCR FROM PS_TRN_SCENARIO A , PS_TRN_SIMULATION B , PS_BUDGET_PER_LANG C , PS_BUDGET_BUS_UNIT D WHERE A.GLOBAL_SCENARIO_SW = 'Y' AND A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.BUDGET_PERIOD = C.BUDGET_PERIOD AND A.BUDGET_PERIOD = D.BUDGET_PERIOD AND B.BUDGET_PERIOD = C.BUDGET_PERIOD AND B.BUDGET_PERIOD = D.BUDGET_PERIOD AND C.BUDGET_PERIOD = D.BUDGET_PERIOD AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SCENARIO = B.SCENARIO AND A.DEPTID = B.DEPTID

  • Related Language Record for TRN_LST_SCE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

    Prompt Table: BUDGET_PERIOD

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUDGET_BUS_UNIT

    3 SCENARIO Character(10) VARCHAR2(10) NOT NULL Scenario

    Prompt Table: TRN_SCENARIO

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description