[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BOM_CONFIG_EXPLOSIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | BOM |
| FND Design Data: |  BOM.BOM_CONFIG_EXPLOSIONS
|
| Subobject Name: | |
| Status: | VALID |
This table contains temporary copies of rows in BOM_EXPLOSIONS. This
is so the Configurator window can perform updates on exploded bills of
material without effecting pre-explosions.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BOM_CONFIG_EXPLOSIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 GROUP_ID
|
| BOM_CONFIG_EXPLOSIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SESSION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TOP_BILL_SEQUENCE_ID | NUMBER | Yes | Top Bill Sequence Identifier | |
| BILL_SEQUENCE_ID | NUMBER | Yes | Bill of material unique identifier | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| EXPLOSION_TYPE | VARCHAR2 | (20) | Yes | Optional, Included or All components |
| COMPONENT_SEQUENCE_ID | NUMBER | Component unique identifier | ||
| COMPONENT_ITEM_ID | NUMBER | Component item identifier | ||
| PLAN_LEVEL | NUMBER | Yes | Level in bill | |
| EXTENDED_QUANTITY | NUMBER | Extended quantity including quantity per, yield, and shrinkage | ||
| SORT_ORDER | VARCHAR2 | (2000) | Yes | Sorting sequence for the explosion |
| CREATION_DATE | DATE | Who column | ||
| CREATED_BY | NUMBER | Who Column | ||
| LAST_UPDATE_DATE | DATE | Who column | ||
| LAST_UPDATED_BY | NUMBER | Who column | ||
| GROUP_ID | NUMBER | Explosion identifier | ||
| SESSION_ID | NUMBER | Session identifier | ||
| SELECT_FLAG | VARCHAR2 | (1) | Whether this component has been ordered | |
| SELECT_QUANTITY | NUMBER | Order quantity | ||
| TOP_ITEM_ID | NUMBER | Item identifier of level 0 item | ||
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| SYSTEM_ID | NUMBER | System-generated identifier of order header | ||
| HEADER_ID | NUMBER | System-generated identifier of order header | ||
| LINE_ID | NUMBER | System-generated identifier of order, configuration or shipment schedule line | ||
| ITEM_SVRID | NUMBER | System-generated identifier of order header | ||
| LIST_PRICE | NUMBER | The price of the item on the price list | ||
| SELLING_PRICE | NUMBER | Actual price charged to customer | ||
| COMPONENT_QUANTITY | NUMBER | Quantity of component in bill of material | ||
| SO_BASIS | NUMBER | Quantity basis used by Oracle Order Entry to determine how many units of component to put on an order | ||
| OPTIONAL | NUMBER | Flag indicating if component is optional in bill of material | ||
| MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | Flag indicating if one or more children of component can be picked when taking an order | ||
| CHECK_ATP | NUMBER | Flag indicating if ATP check is required | ||
| SHIPPING_ALLOWED | NUMBER | Flag indicating if component is allowed to ship | ||
| REQUIRED_TO_SHIP | NUMBER | Flag indicating if component is required to ship | ||
| REQUIRED_FOR_REVENUE | NUMBER | Flag indicating if component is required for revenue | ||
| INCLUDE_ON_SHIP_DOCS | NUMBER | Flag indicating if component is included on shipping documents | ||
| INCLUDE_ON_BILL_DOCS | NUMBER | Flag indicating if component is included on billing documents | ||
| LOW_QUANTITY | NUMBER | Minimum quantity allowed on an order | ||
| HIGH_QUANTITY | NUMBER | Maximum quantity allowed on an order | ||
| PICK_COMPONENTS | NUMBER | (not currently used) | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Unit of measure code of component | |
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure of component | |
| BASE_ITEM_ID | NUMBER | Base item identifier | ||
| ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | Flag indicating whether item may have components requiring ATP check | |
| ATP_FLAG | VARCHAR2 | (1) | Flag indicating ATP must be checked when item is ordered | |
| BOM_ITEM_TYPE | NUMBER | Type of item | ||
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | Flag indicating all shippable components of should be picked | |
| REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Assemble to order flag | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating shippable item | |
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Flag indicating customer orderable item | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Flag indicating internally orderable item | |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is customer orderable | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is internally orderable | |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Sales order transactions flag | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ASSEMBLY_ITEM_ID | NUMBER | Assembly item identifier | ||
| CONFIGURATOR_FLAG | VARCHAR2 | (1) | Flag indicating if component is used by the configurator form | |
| PRICE_LIST_ID | NUMBER | System-generated identifier of price list | ||
| ROUNDING_FACTOR | NUMBER | Rounding factor used to determine order quantity | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | User defined attribute that adjusts the list price of an item | |
| COMPONENT_CODE | VARCHAR2 | (1000) | Concatenation of component item identifiers | |
| LOOP_FLAG | NUMBER | Indicates whether a loop is detected | ||
| PARENT_BOM_ITEM_TYPE | NUMBER | Parent item's bom item type | ||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
| ITEM_NUM | NUMBER | Item unit cost | ||
| EFFECTIVITY_DATE | DATE | Effective date | ||
| DISABLE_DATE | DATE | Disable date | ||
| IMPLEMENTATION_DATE | DATE | Date on which engineering change order was implemented | ||
| REXPLODE_FLAG | NUMBER | Flag indicating whether to re-explode | ||
| COMMON_BILL_SEQUENCE_ID | NUMBER | Common bill of material unique identifier | ||
| COMP_BILL_SEQ_ID | NUMBER | Bill Sequence identifier of component | ||
| COMP_COMMON_BILL_SEQ_ID | NUMBER | Common bill sequence id of component | ||
| NUM_COL1 | NUMBER | Updatable column for Configurator | ||
| NUM_COL2 | NUMBER | Updatable column for Configurator | ||
| NUM_COL3 | NUMBER | Updatable column for Configurator | ||
| DATE_COL1 | DATE | Updatable column for Configurator | ||
| DATE_COL2 | DATE | Updatable column for Configurator | ||
| DATE_COL3 | DATE | Updatable column for Configurator | ||
| CHAR_COL1 | VARCHAR2 | (80) | Updatable column for Configurator | |
| CHAR_COL2 | VARCHAR2 | (80) | Updatable column for Configurator | |
| CHAR_COL3 | VARCHAR2 | (80) | Updatable column for Configurator | |
| PREVIOUS_SELECTED_QTY | NUMBER | This column is no longer used. | ||
| AUTO_SELECTED_QUANTITY | NUMBER | This column is no longer used. | ||
| SELECTED_LINE_ID | NUMBER | This column is no longer used. | ||
| CONFIG_HEADER_ID | NUMBER | This column is no longer used. | ||
| CONFIG_REV_NBR | NUMBER | This column is no longer used. |
Cut, paste (and edit) the following text to query this object:
SELECT TOP_BILL_SEQUENCE_ID
, BILL_SEQUENCE_ID
, ORGANIZATION_ID
, EXPLOSION_TYPE
, COMPONENT_SEQUENCE_ID
, COMPONENT_ITEM_ID
, PLAN_LEVEL
, EXTENDED_QUANTITY
, SORT_ORDER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, GROUP_ID
, SESSION_ID
, SELECT_FLAG
, SELECT_QUANTITY
, TOP_ITEM_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SYSTEM_ID
, HEADER_ID
, LINE_ID
, ITEM_SVRID
, LIST_PRICE
, SELLING_PRICE
, COMPONENT_QUANTITY
, SO_BASIS
, OPTIONAL
, MUTUALLY_EXCLUSIVE_OPTIONS
, CHECK_ATP
, SHIPPING_ALLOWED
, REQUIRED_TO_SHIP
, REQUIRED_FOR_REVENUE
, INCLUDE_ON_SHIP_DOCS
, INCLUDE_ON_BILL_DOCS
, LOW_QUANTITY
, HIGH_QUANTITY
, PICK_COMPONENTS
, PRIMARY_UOM_CODE
, PRIMARY_UNIT_OF_MEASURE
, BASE_ITEM_ID
, ATP_COMPONENTS_FLAG
, ATP_FLAG
, BOM_ITEM_TYPE
, PICK_COMPONENTS_FLAG
, REPLENISH_TO_ORDER_FLAG
, SHIPPABLE_ITEM_FLAG
, CUSTOMER_ORDER_FLAG
, INTERNAL_ORDER_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG
, INTERNAL_ORDER_ENABLED_FLAG
, SO_TRANSACTIONS_FLAG
, DESCRIPTION
, ASSEMBLY_ITEM_ID
, CONFIGURATOR_FLAG
, PRICE_LIST_ID
, ROUNDING_FACTOR
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, COMPONENT_CODE
, LOOP_FLAG
, PARENT_BOM_ITEM_TYPE
, OPERATION_SEQ_NUM
, ITEM_NUM
, EFFECTIVITY_DATE
, DISABLE_DATE
, IMPLEMENTATION_DATE
, REXPLODE_FLAG
, COMMON_BILL_SEQUENCE_ID
, COMP_BILL_SEQ_ID
, COMP_COMMON_BILL_SEQ_ID
, NUM_COL1
, NUM_COL2
, NUM_COL3
, DATE_COL1
, DATE_COL2
, DATE_COL3
, CHAR_COL1
, CHAR_COL2
, CHAR_COL3
, PREVIOUS_SELECTED_QTY
, AUTO_SELECTED_QUANTITY
, SELECTED_LINE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
FROM BOM.BOM_CONFIG_EXPLOSIONS;
BOM.BOM_CONFIG_EXPLOSIONS does not reference any database object
BOM.BOM_CONFIG_EXPLOSIONS is referenced by following:
APPS
BOM_CONFIG_EXPLOSIONS
|
|
|
|