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

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

APPS

BOMTBICX

BOMTSTRC

BOM_COMPONENTS_B

ENI_DBI_BOM_COMPONENTS_MV1

ENI_DBI_BOM_COMPONENTS_MV2