TN_SMLDEGVW_LNG

(SQL View)
 Index Back

Initial Total Request View

Initial Total Request View

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

  • Related Language Record for TRN_SML_DEMG_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 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID

    Prompt Table: TRN_DEMAND

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