1. Tables and Views for SCM
  2. CST_BUILD_SCENARIO_PARAMS_GT

CST_BUILD_SCENARIO_PARAMS_GT

This table temporarily stores the parameters which used for the build scenario process.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
SCENARIO_EVENT_ID NUMBER 18 Yes Indicates the scenario event for which the build scenario process is being executed for.
SCENARIO_ID NUMBER 18 Yes Indicates the scenario for which the build scenario process is being executed for.
SCENARIO_EVENT_TYPE VARCHAR2 30 Yes Indicates the event type of the scenario event. Valid values are BUILDROLLUP, PUBLISH, UNPUBLISH.
SCENARIO_EVENT_DATE TIMESTAMP Yes Indicates the date on which the scenario event was invoked for the execution of the build, cost rollup or publish costs processes.
SCENARIO_EVENT_NUMBER VARCHAR2 30 Yes Indicates the user identifiable scenario event number.
SCENARIO_NUMBER VARCHAR2 30 Yes Indicates the user identifiable scenario number.
COST_ORG_ID NUMBER 18 Yes Indicates the cost organization identifier for which the scenario was created.
COST_BOOK_ID NUMBER 18 Yes Indicates the cost book identifier for which the scenario was created.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
SCENARIO_TYPE VARCHAR2 30 Yes Indicates the scenario type of the scenario. Valid values are 'STANDARD' and 'CONFIGURED_ITEMS'.
INV_ORG_ID NUMBER 18 Yes Indicates the plant identifier for which the scenario was created.
CURRENCY_CODE VARCHAR2 15 Indicates the currency code of the scenario for which the build, cost rollup or publish costs are invokved.
SCENARIO_STATUS_CODE VARCHAR2 30 Yes Indicates the status of the scenario at the time of executing the build scenario process.
WD_CRITERION_ID NUMBER 18 Yes Identifies the work definition criteria identifier used to derive the work definition items.
SCENARIO_CRITERION_PRIORITY NUMBER Yes Indicates the priority or the order in which the scenario criterion are applied to derive the work definition items.
WD_CRITERION_CODE VARCHAR2 30 Yes Identifies the work definition criterion code applicable for deriving the work definition items.
EXPLOSION_BASIS VARCHAR2 30 Yes Indicates the explosion basis of the work definition criterion.
EXPLOSION_SEQUENCE VARCHAR2 30 Yes Indicates the sequence in which the rules for deriving the work definitions for the items identified by work definition criteria are applied.
REFRESH_WD_FLAG VARCHAR2 1 Yes Indicates whether during the build and rollup process, the work definition snapshots should be refreshed from the manufacturing tables or should the last used work definition for the item and plant combination from a previous scenario be used. Valid values are 'Y' and 'N'. Default is 'Y' indicating the work definitions would be refreshed.
PLANNING_MODE VARCHAR2 30 Yes Indicates whether the rollup process should execute for all items or for new items only.
WORK_DEFINITION_NAME_ID NUMBER 18 Identifies the work definition name identifier used to derive the work definitions for work definition items.
CRITERION_DETAIL_PRIORITY NUMBER Yes Indicates the priority or the order in which the scenario criterion details are applied to derive the work definition items.
WD_CRITERION_DETAIL_ID NUMBER 18 Yes Identifies the work definition criteria detail based on which the work definitions are derived for the work definition items.
EXPLOSION_SCOPE VARCHAR2 30 Yes Indicates the scope of items for which the work definitions are being derived. Valid options are ALL_ITEMS, SELECTED_ITEMS, SELECTED_ITEM_CATEGORIES, WHERE_USED.
INVENTORY_ITEM_ID NUMBER 18 Identifies the item for which work definition needs to be identified. This is a mandatory parameter if the explosion scope is SELECTED_ITEMS.
INVENTORY_ORG_ID NUMBER 18 Identifies the validation organization for the item for which work definition needs to be identified. This is a mandatory parameter if the explosion scope is SELECTED_ITEMS.
CATEGORY_ID NUMBER 18 Identifies the item category of the items for which work definition needs to be identified. This is a mandatory parameter if the explosion scope is SELECTED_ITEM_CATEGORIES.
CATEGORY_SET_ID NUMBER 18 Identifies the item category set of the items for which work definition needs to be identified. This is a mandatory parameter if the explosion scope is SELECTED_ITEM_CATEGORIES.
RESOURCE_ID NUMBER 18 Identifies the resource for which work definition needs to be identified.
RESOURCE_CLASS_CODE VARCHAR2 30 Identifies the resource class for which work definition needs to be identified.
STATUS_CODE VARCHAR2 30 Yes Indicates the status of the build scenario parameter record. Also stores the error message, if the build scenario process is not able to successfully derive the information.
PLANNING_COST_ORG_ID NUMBER 18 Indicates the planning cost organization identifier. Not used in R12 onwards.
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Indicates the currency conversion type. It is not used R12 onwards.
PHANTOM_OPERATION_INHERIT_FLAG VARCHAR2 30 Determines how phantom operations are inherited. Possible values are: Material Only, and Material and Resources.
ENABLE_PROCESS_FLAG VARCHAR2 1 Contains Y or N. Y: Process manufacturing is enabled and possible within the manufacturing plant, in addition to discrete manufacturing. N: Process manufacturing is not enabled, and only discrete manufacturing will be possible within the manufacturing plant.
DEF_WORK_METHOD VARCHAR2 30 Specifies the default work method to use. Valid values are Discrete Manufacturing and Process Manufacturing.
COST_ORG_TIMEZONE_CODE VARCHAR2 64 Indicates the time zone of the cost organization's legal entity.
INV_ORG_TIMEZONE_CODE VARCHAR2 64 Indicates the time zone of the inventory organization's legal entity.

Indexes

Index Uniqueness Columns
CST_BUILD_SCN_PARAMS_GT_N1 Non Unique SCENARIO_ID, WD_CRITERION_DETAIL_ID
CST_BUILD_SCN_PARAMS_GT_N2 Non Unique STATUS_CODE, INV_ORG_ID, INVENTORY_ITEM_ID