CST_BUILD_SCENARIO_PARAMS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

SCENARIO_EVENT_ID SCENARIO_ID SCENARIO_EVENT_TYPE SCENARIO_EVENT_DATE SCENARIO_EVENT_NUMBER SCENARIO_NUMBER COST_ORG_ID COST_BOOK_ID EFFECTIVE_START_DATE INV_ORG_ID SCENARIO_TYPE CURRENCY_CODE STATUS_CODE SCENARIO_STATUS_CODE WD_CRITERION_ID WD_CRITERION_CODE EXPLOSION_BASIS EXPLOSION_SEQUENCE REFRESH_WD_FLAG PLANNING_MODE WORK_DEFINITION_NAME_ID CURRENCY_CONVERSION_TYPE PHANTOM_OPERATION_INHERIT_FLAG ENABLE_PROCESS_FLAG DEF_WORK_METHOD COST_ORG_TIMEZONE_CODE INV_ORG_TIMEZONE_CODE

Query

SQL_Statement

SELECT DISTINCT scenario_event_id, scenario_id, scenario_event_type, scenario_event_date, scenario_event_number, scenario_number, cost_org_id, cost_book_id, effective_start_date, inv_org_id, scenario_type, currency_code, status_code, scenario_status_code, wd_criterion_id, wd_criterion_code, explosion_basis, explosion_sequence, refresh_wd_flag, planning_mode, work_definition_name_id, currency_conversion_type, phantom_operation_inherit_flag, enable_process_flag, def_work_method, cost_org_timezone_code, inv_org_timezone_code FROM cst_build_scenario_params_gt