TRN_LST_GBL_VW

(SQL View)
 Index Back

Scenario Search Record

Scenario Search Record

SELECT DISTINCT A.BUDGET_PERIOD, A.BUSINESS_UNIT, B.DESCR, A.SCENARIO FROM PS_TRN_SCENARIO A, PS_BUDGET_PERIOD B, PS_BUDGET_BUS_UNIT C WHERE A.BUDGET_PERIOD = B.BUDGET_PERIOD AND A.GLOBAL_SCENARIO_SW = 'Y' AND C.BUDGET_PERIOD = B.BUDGET_PERIOD AND C.BUSINESS_UNIT = A.BUSINESS_UNIT

  • Related Language Record: TRN_LSTGVW_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SCENARIO Character(10) VARCHAR2(10) NOT NULL Scenario

    Prompt Table: TRN_SCENARIO