TN_SMLDEMVW_LNG

(SQL View)
 Index Back

Initial Total Request View

Initial Total Request View

SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , A.DEMAND_ID , D.LANGUAGE_CD , D.DESCR , B.DESCR FROM PS_TRN_SIMULATION A , PS_TRN_DEMAND_LANG B , PS_TRN_SCENARIO C , PS_BUDGET_PER_LANG D WHERE 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 = C.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.DEPTID = C.DEPTID AND A.SCENARIO = C.SCENARIO AND A.DEMAND_ID = B.DEMAND_ID AND B.LANGUAGE_CD = D.LANGUAGE_CD AND C.SCENARIO_STATUS = 'A'

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

    Prompt Table: TRN_DEMAND

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