TRN_LST_SCE_VW

(SQL View)
 Index Back

Scenarios list View

Scenarios list View

SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , A.SCENARIO , C.DESCR , SUM(DEMAND_APPROVED) FROM PS_TRN_SCENARIO A , PS_TRN_SIMULATION B , PS_BUDGET_PERIOD C , PS_BUDGET_BUS_UNIT D WHERE A.GLOBAL_SCENARIO_SW = 'Y' AND A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.SCENARIO = B.SCENARIO AND A.DEPTID = B.DEPTID AND A.BUDGET_PERIOD = C.BUDGET_PERIOD AND D.BUDGET_PERIOD = C.BUDGET_PERIOD AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BUSINESS_UNIT = B.BUSINESS_UNIT GROUP BY A.BUDGET_PERIOD, A.BUSINESS_UNIT, C.DESCR, A.SCENARIO

  • Related Language Record: TN_LSTSCEVW_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DEMAND_APPROVED Number(6,0) INTEGER NOT NULL Employees Approved