TN_SMLGBLVW_LNG

(SQL View)
 Index Back

Training Simulation Table

Training Simulation Table

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

  • Related Language Record for TRN_SML_GBL_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_LST_GBL_VW

    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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