[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:
|
|
|