eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BOM.BOM_EXPLOSIONS

Object Details

Object Name:	BOM_EXPLOSIONS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_EXPLOSIONS
Subobject Name:
Status:	VALID

This table contains permanent explosions of all model bills for use by
Oracle Order Management. It contains components with all
effective dates (within limits). There are three types of explosions:
Optional, Included, or Both. The types refer to whether the component
is mandatory or optional.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_EXPLOSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TOP_BILL_SEQUENCE_ID EXPLOSION_TYPE SORT_ORDER
BOM_EXPLOSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_BILL_SEQUENCE_ID EXPLOSION_TYPE PLAN_LEVEL EFFECTIVITY_DATE DISABLE_DATE
BOM_EXPLOSIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPONENT_ITEM_ID ORGANIZATION_ID PLAN_LEVEL
BOM_EXPLOSIONS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSEMBLY_ITEM_ID ORGANIZATION_ID TOP_BILL_SEQUENCE_ID IMPLEMENTATION_DATE EFFECTIVITY_DATE DISABLE_DATE SORT_ORDER
BOM_EXPLOSIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMP_COMMON_BILL_SEQ_ID TOP_BILL_SEQUENCE_ID EXPLOSION_TYPE
BOM_EXPLOSIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_BILL_SEQUENCE_ID EXPLOSION_TYPE REXPLODE_FLAG
BOM_EXPLOSIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPONENT_ITEM_ID ORGANIZATION_ID TOP_BILL_SEQUENCE_ID
BOM_EXPLOSIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPLOSION_TYPE ORGANIZATION_ID
BOM_EXPLOSIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPONENT_SEQUENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TOP_BILL_SEQUENCE_ID	NUMBER		Yes	Bill identifier of level 0 items
BILL_SEQUENCE_ID	NUMBER		Yes	Bill of material unique identifier of parent
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		Yes	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
TOP_ITEM_ID	NUMBER		Yes	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
COMPONENT_QUANTITY	NUMBER			Quantity of component in bill of material
SO_BASIS	NUMBER			Quantity basis used by Oracle Order Management 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 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
COMPONENT_CODE	VARCHAR2	(2000)		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 sequence within bill of material structure
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 of parent
COMP_BILL_SEQ_ID	NUMBER			Component's bill sequence identifier
COMP_COMMON_BILL_SEQ_ID	NUMBER			Component's common bill sequence identifier
EXPLODE_GROUP_ID	NUMBER			(not used)
NUM_COL1	NUMBER			(not used)
NUM_COL2	NUMBER			(not used)
NUM_COL3	NUMBER			(not used)
DATE_COL1	DATE			(not used)
DATE_COL2	DATE			(not used)
DATE_COL3	DATE			(not used)
CHAR_COL1	VARCHAR2	(80)		(not used)
CHAR_COL2	VARCHAR2	(80)		(not used)
CHAR_COL3	VARCHAR2	(80)		(not used)
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)		Auomatically create move order for the material at work order release
INCLUDE_IN_COST_ROLLUP	NUMBER			Flag indicating if this component is to be used when rolling up costs
COMPONENT_YIELD_FACTOR	NUMBER			Factor used to multiply component quantity with to obtain required component quantity
PLANNING_FACTOR	NUMBER			Factor used to multiply component quantity with to obtain planning quantity
CHANGE_NOTICE	VARCHAR2	(240)		Engineering change order number
PARENT_SORT_ORDER	VARCHAR2	(2000)		Parent Sorting sequence for the explosion
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)		Suggested vendor name
VENDOR_ID	NUMBER			Suggested Vendor ID column
UNIT_PRICE	NUMBER			Unit Price for direct items used by EAM BOMs
REQUEST_ID	NUMBER	(22)		Request id
BASIS_TYPE	NUMBER			Basis type identifier
SOURCE_BILL_SEQUENCE_ID	NUMBER			Source bill sequence id
COMMON_COMPONENT_SEQUENCE_ID	NUMBER			Common component sequence id
COMP_SOURCE_BILL_SEQ_ID	NUMBER			Component source bill sequence id

Query Text

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
,      TOP_ITEM_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      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
,      EXPLODE_GROUP_ID
,      NUM_COL1
,      NUM_COL2
,      NUM_COL3
,      DATE_COL1
,      DATE_COL2
,      DATE_COL3
,      CHAR_COL1
,      CHAR_COL2
,      CHAR_COL3
,      AUTO_REQUEST_MATERIAL
,      INCLUDE_IN_COST_ROLLUP
,      COMPONENT_YIELD_FACTOR
,      PLANNING_FACTOR
,      CHANGE_NOTICE
,      PARENT_SORT_ORDER
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      REQUEST_ID
,      BASIS_TYPE
,      SOURCE_BILL_SEQUENCE_ID
,      COMMON_COMPONENT_SEQUENCE_ID
,      COMP_SOURCE_BILL_SEQ_ID
FROM BOM.BOM_EXPLOSIONS;

Dependencies

[top of page]

BOM.BOM_EXPLOSIONS does not reference any database object

BOM.BOM_EXPLOSIONS is referenced by following:

APPS: BOM_EXPLOSIONS