SCENARIOTRN_INACT_SC_VW(SQL View) |
Index Back |
|---|---|
Inactive, Global Scearios VwUsed in Budget Training application to list all inactive global scenarios. |
| SELECT DISTINCT A.SCENARIO,A.BUDGET_PERIOD, A.BUSINESS_UNIT FROM PS_TRN_SCENARIO A, PS_BUDGET_BUS_UNIT B WHERE A.SCENARIO_STATUS='I' AND A.GLOBAL_SCENARIO_SW='Y' AND A.BUDGET_PERIOD=B.BUDGET_PERIOD AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND B.FROZEN_SW='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL | Scenario |
| 2 | BUDGET_PERIOD | Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |