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_COMPONENTS_B

Object Details

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

BOM_COMPONENTS_B stores information about bills of material
components. This table only stores single-level components.
COMPONENT_SEQUENCE_ID uniquely identifies each row. There is one row
per component on an operation within a given date range.
.
This table is the main child table of BOM_STRUCTURES_B and
references the parent using BILL_SEQUENCE_ID. It uses
EFFECTIVITY_DATE and DISABLE_DATE to time phase components into a bill
of material. The Bill of Material window enforces that only
one row for a component in an operation is effective at a given time.
.
REVISED_ITEM_SEQUENCE_ID points to the revised item on an ECO that
affects a particular component row. If IMPLEMENTATION_DATE is null,
the component is pending on an engineering change that has not yet
been implemented. IMPLEMENTATION_DATE is either NULL (pending on ECO)
or equals EFFECTIVITY_DATE (implemented). OLD_COMPONENT_SEQUENCE_ID
points to the original component row affected by this component row
through an engineering change.
.
This table also contains certain columns relating to shipping, billing
and accounting for revenue on a customer order through Oracle Order
Management. CHECK_ATP determines if an ATP check is required for
this item when placing an order and overrides the Item level ATP flag.
LOW_QUANTITY and HIGH_QUANTITY define minimum and maximum quantities
of this component item that can be placed on an order if the customer
chooses to override COMPONENT_QUANTITY. OPTIONAL decides if a
component is a required option class you have to choose from (for
Option Class items) or a required item (for Standard items) when
taking an order. For Option Class items, MUTUALLY_EXCLUSIVE_OPTIONS
decides if one or more of its components can be placed on an order
when you pick this option class.
.
OPERATION_LEAD_TIME_PERCENT is denormalized for performance from
BOM_OPERATION_SEQUENCES when rolling up cumulative leadtimes.
.
The ORGANIZATION_ID for the component can be derived from the
BOM_BILL_OF_MATERIALS table using BILL_SEQUENCE_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	35
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_COMPONENTS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPONENT_SEQUENCE_ID
BOM_COMPONENTS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPONENT_ITEM_ID BILL_SEQUENCE_ID EFFECTIVITY_DATE
BOM_COMPONENTS_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMMON_COMPONENT_SEQUENCE_ID
BOM_COMPONENTS_B_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_SEQUENCE_ID EFFECTIVITY_DATE DISABLE_DATE ITEM_NUM COMPONENT_ITEM_ID
BOM_COMPONENTS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_SEQUENCE_ID
BOM_COMPONENTS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVISED_ITEM_SEQUENCE_ID
BOM_COMPONENTS_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_COMPONENT_SEQUENCE_ID
BOM_COMPONENTS_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_NOTICE
BOM_COMPONENTS_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_SEQUENCE_ID FROM_END_ITEM_UNIT_NUMBER COMPONENT_ITEM_ID
BOM_COMPONENTS_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_SEQUENCE_ID EFFECTIVITY_DATE COMPONENT_ITEM_ID OPERATION_SEQ_NUM FROM_END_ITEM_UNIT_NUMBER
BOM_COMPONENTS_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PK1_VALUE PK2_VALUE EFFECTIVITY_DATE DISABLE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number
COMPONENT_ITEM_ID	NUMBER			Component item identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ITEM_NUM	NUMBER			Item sequence within bill of material structure
COMPONENT_QUANTITY	NUMBER		Yes	Quantity of component in bill of material
COMPONENT_YIELD_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain required component quantity
COMPONENT_REMARKS	VARCHAR2	(240)		Component remarks
EFFECTIVITY_DATE	DATE		Yes	Effective date
CHANGE_NOTICE	VARCHAR2	(10)		Engineering change order number
IMPLEMENTATION_DATE	DATE			Date on which engineering change order was implemented
DISABLE_DATE	DATE			Disable date
ATTRIBUTE_CATEGORY	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
PLANNING_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	NUMBER		Yes	Identifier to indicate if this component has quantity related reference designators
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
MUTUALLY_EXCLUSIVE_OPTIONS	NUMBER			Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	NUMBER		Yes	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	NUMBER		Yes	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 displayed on shipping documents
INCLUDE_ON_BILL_DOCS	NUMBER			(not currently used)
LOW_QUANTITY	NUMBER			Minimum quantity allowed on an order
HIGH_QUANTITY	NUMBER			Maximum quantity allowed on an order
ACD_TYPE	NUMBER			Add, change, or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	NUMBER			Identifier of original component row an ECO effects
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Component unique identifier
BILL_SEQUENCE_ID	NUMBER		Yes	Bill of material unique identifier
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
WIP_SUPPLY_TYPE	NUMBER			WIP supply type code
PICK_COMPONENTS	NUMBER			(not currently used)
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Supply subinventory
SUPPLY_LOCATOR_ID	NUMBER			Supply locator identifier
OPERATION_LEAD_TIME_PERCENT	NUMBER			Operation offset from first operation in routing (denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
REVISED_ITEM_SEQUENCE_ID	NUMBER			Engineering change order revised item identifier
COST_FACTOR	NUMBER			(not currently used)
BOM_ITEM_TYPE	NUMBER			Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		To End Item Unit Number
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)		Original system that data for the current record has come from
ECO_FOR_PRODUCTION	NUMBER			Indicates if this component on an Engineering Change Order is only for WIP jobs
ENFORCE_INT_REQUIREMENTS	NUMBER			Enforce Integer Requirements
COMPONENT_ITEM_REVISION_ID	NUMBER			Item revision Identifier
DELETE_GROUP_NAME	VARCHAR2	(10)		Delete group name for the entity type you are deleting
DG_DESCRIPTION	VARCHAR2	(240)		Description of the delete group
OPTIONAL_ON_MODEL	NUMBER			Flag indicating if component is optional on model bill (for ATO)
PARENT_BILL_SEQ_ID	NUMBER			Common bill sequence id of the model bill (for ATO)
MODEL_COMP_SEQ_ID	NUMBER			Component sequence identifier from model bill (for ATO)
PLAN_LEVEL	NUMBER			Plan level based on model bill (for ATO)
FROM_BILL_REVISION_ID	NUMBER			From Bill Revision Id
TO_BILL_REVISION_ID	NUMBER			To Bill Revision Id
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)		Flag to indicate if the item is automatically requested or not
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)		Suggested vendor name will be used for direct items for EAM BOMs
VENDOR_ID	NUMBER			Suggested Vendor ID column
UNIT_PRICE	NUMBER			Unit Price for direct items used by EAM BOMs
OBJ_NAME	VARCHAR2	(30)		Object Name
PK1_VALUE	VARCHAR2	(240)		Primary Key id of the object
PK2_VALUE	VARCHAR2	(240)		Primary Key id of the object
PK3_VALUE	VARCHAR2	(240)		Primary Key of the object
PK4_VALUE	VARCHAR2	(240)		Primary key of the object
PK5_VALUE	VARCHAR2	(240)		Primary key of the object
FROM_END_ITEM_REV_ID	NUMBER			From End Item Revision Id
TO_END_ITEM_REV_ID	NUMBER			To End Item Revision Id
OVERLAPPING_CHANGES	NUMBER			Overlapping Changes
FROM_OBJECT_REVISION_ID	NUMBER			From Object Revision Id
FROM_MINOR_REVISION_ID	NUMBER			From Minor Revision Id
TO_OBJECT_REVISION_ID	NUMBER			To Object Revision Id
TO_MINOR_REVISION_ID	NUMBER			To Minor Revision Id
FROM_END_ITEM_MINOR_REV_ID	NUMBER			From End Item Minor Rev Id
TO_END_ITEM_MINOR_REV_ID	NUMBER			To End Item Minor Rev Id
COMPONENT_MINOR_REVISION_ID	NUMBER			Component Minor Revision Id
FROM_STRUCTURE_REVISION_CODE	VARCHAR2	(30)		From structure revision code
TO_STRUCTURE_REVISION_CODE	VARCHAR2	(30)		To structure revision code
FROM_END_ITEM_STRC_REV_ID	NUMBER			(not currently used)
TO_END_ITEM_STRC_REV_ID	NUMBER			(not currently used)
BASIS_TYPE	NUMBER			Basis type identifier
COMMON_COMPONENT_SEQUENCE_ID	NUMBER			Common Component Sequence Id
INHERIT_FLAG	NUMBER			Inherit Flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_NUM
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      COMPONENT_REMARKS
,      EFFECTIVITY_DATE
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      DISABLE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PLANNING_FACTOR
,      QUANTITY_RELATED
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      INCLUDE_IN_COST_ROLLUP
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      ACD_TYPE
,      OLD_COMPONENT_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_SUPPLY_TYPE
,      PICK_COMPONENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      OPERATION_LEAD_TIME_PERCENT
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      BOM_ITEM_TYPE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      COMPONENT_ITEM_REVISION_ID
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      OPTIONAL_ON_MODEL
,      PARENT_BILL_SEQ_ID
,      MODEL_COMP_SEQ_ID
,      PLAN_LEVEL
,      FROM_BILL_REVISION_ID
,      TO_BILL_REVISION_ID
,      AUTO_REQUEST_MATERIAL
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_ID
,      OVERLAPPING_CHANGES
,      FROM_OBJECT_REVISION_ID
,      FROM_MINOR_REVISION_ID
,      TO_OBJECT_REVISION_ID
,      TO_MINOR_REVISION_ID
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      COMPONENT_MINOR_REVISION_ID
,      FROM_STRUCTURE_REVISION_CODE
,      TO_STRUCTURE_REVISION_CODE
,      FROM_END_ITEM_STRC_REV_ID
,      TO_END_ITEM_STRC_REV_ID
,      BASIS_TYPE
,      COMMON_COMPONENT_SEQUENCE_ID
,      INHERIT_FLAG
FROM BOM.BOM_COMPONENTS_B;

Dependencies

[top of page]

BOM.BOM_COMPONENTS_B does not reference any database object

BOM.BOM_COMPONENTS_B is referenced by following:

BOM: BOM_COMPONENTS_B#