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_INVENTORY_COMPS_INTERFACE

Object Details

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

BOM_INVENTORY_COMPS_INTERFACE temporarily stores information about
bill of material components. This table is shared by the Bills of
Material and Engineering Change Order open interfaces.
.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. The open
interfaces will derive column values you do not enter, after
performing the proper validation. For example, you enter the
ORGANIZATION_CODE and the open interfaces will fill in the
corresponding ORGANIZATION_ID for you.
.
Also, you can enter ASSEMBLY_ITEM_ID, ORGANIZATION_ID and
ALTERNATE_BOM_DESIGNATOR instead of BILL_SEQUENCE_ID. The open
interfaces will fill in the corresponding BILL_SEQUENCE_ID.
.
In addition, you can enter BILL_SEQUENCE_ID, COMPONENT_ITEM_ID,
OPERATION_SEQ_NUM, and EFFECTIVITY_DATE instead of
COMPONENT_SEQUENCE_ID. The open interfaces will fill in the
corresponding COMPONENT_SEQUENCE_ID.
.
You can enter one reference designator and one substitute
component for each component you enter. Oracle Bills of Material will
insert these records into the tables, BOM_REFERENCE_DESIGNATORS and
BOM_SUBSTITUTE_COMPONENTS, respectively.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_INV_COMPS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
BOM_INV_COMPS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BILL_SEQUENCE_ID EFFECTIVITY_DATE COMPONENT_ITEM_ID OPERATION_SEQ_NUM
BOM_INV_COMPS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COMPONENT_SEQUENCE_ID
BOM_INV_COMPS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID ASSEMBLY_ITEM_ID ALTERNATE_BOM_DESIGNATOR
BOM_INV_COMPS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_ID BOM_INVENTORY_COMPS_IFCE_KEY
BOM_INV_COMPS_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COMPONENT_ITEM_ID REVISED_ITEM_SEQUENCE_ID
BOM_INV_COMPS_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_CODE ALTERNATE_BOM_DESIGNATOR
BOM_INV_COMPS_INTERFACE_N7	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY
BOM_INV_COMPS_INTERFACE_N8	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_FLAG ORGANIZATION_ID TRANSACTION_ID
BOM_INV_COMPS_INTERFACE_N9	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID COMP_SOURCE_SYSTEM_REFERENCE PARENT_SOURCE_SYSTEM_REFERENCE PROCESS_FLAG

Columns

Name	Datatype	Length	Comments
OPERATION_SEQ_NUM	NUMBER		Operation sequence number
COMPONENT_ITEM_ID	NUMBER		Component item identifier
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
ITEM_NUM	NUMBER		Item sequence within bill of material structure
COMPONENT_QUANTITY	NUMBER		Quantity of component in bill of material
COMPONENT_YIELD_FACTOR	NUMBER		Factor used to multiply component quantity to obtain required component quantity
COMPONENT_REMARKS	VARCHAR2	(240)	Component remarks
EFFECTIVITY_DATE	DATE		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		Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	NUMBER		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		Flag indicating if this component is to be used when rolling up costs
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 displayed on shipping documents
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 that an ECO affects
COMPONENT_SEQUENCE_ID	NUMBER		Component unique identifier
BILL_SEQUENCE_ID	NUMBER		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
SUPPLY_SUBINVENTORY	VARCHAR2	(10)	Supply subinventory
SUPPLY_LOCATOR_ID	NUMBER		Supply locator identifier
REVISED_ITEM_SEQUENCE_ID	NUMBER		Engineering change order revised item identifier
MODEL_COMP_SEQ_ID	NUMBER		Component sequence identifier from model bill (for ATO)
ASSEMBLY_ITEM_ID	NUMBER		Inventory item identifier of manufactured assembly
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)	Alternate designator code
ORGANIZATION_ID	NUMBER		Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Abbreviation for organization name
COMPONENT_ITEM_NUMBER	VARCHAR2	(240)	Concatenated component item segments
ASSEMBLY_ITEM_NUMBER	VARCHAR2	(240)	Concatenated bill item segments
REVISED_ITEM_NUMBER	VARCHAR2	(240)	Concatenated revised item segments
LOCATION_NAME	VARCHAR2	(81)	Supply location name
REFERENCE_DESIGNATOR	VARCHAR2	(15)	Component reference designator
SUBSTITUTE_COMP_ID	NUMBER		Inventory item identifier of the substitute component
SUBSTITUTE_COMP_NUMBER	VARCHAR2	(240)	Concatenated item segments of the substitute component
TRANSACTION_ID	NUMBER		Row identifier
PROCESS_FLAG	NUMBER		Row status
BOM_ITEM_TYPE	NUMBER		Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
OPERATION_LEAD_TIME_PERCENT	NUMBER		Operation offset from first operation in routing (Denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
COST_FACTOR	NUMBER		(not currently used)
INCLUDE_ON_BILL_DOCS	NUMBER		(not currently used)
PICK_COMPONENTS	NUMBER		(not currently used)
DDF_CONTEXT1	VARCHAR2	(30)	Used by Mass Change
DDF_CONTEXT2	VARCHAR2	(30)	Used by Mass Change
NEW_OPERATION_SEQ_NUM	NUMBER		Updated value for the operation_seq_num
OLD_OPERATION_SEQ_NUM	NUMBER		Operation sequence number in the original component record that an ECO affects
NEW_EFFECTIVITY_DATE	DATE		Updated value for the effectivity_date
OLD_EFFECTIVITY_DATE	DATE		Value of effective date in the original component record that an ECO affects
ASSEMBLY_TYPE	NUMBER		Assembly type of the parent bill
INTERFACE_ENTITY_TYPE	VARCHAR2	(4)	Record used for Bill or ECO Open Interface: BILL, ECO
TRANSACTION_TYPE	VARCHAR2	(10)	Type of action: CREATE, UPDATE or DELETE
BOM_INVENTORY_COMPS_IFCE_KEY	VARCHAR2	(30)	User defined identifier that links rows pertaining to the same business object
ENG_REVISED_ITEMS_IFCE_KEY	VARCHAR2	(30)	User defined identifier for linking rows pertaining to the same business object
ENG_CHANGES_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows corresponding to the same business object
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	To End Item Unit Number
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	From End Item Unit Number
NEW_FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	From End Item Unit Number
DELETE_GROUP_NAME	VARCHAR2	(10)	Delete group name for the entity type you are deleting
DG_DESCRIPTION	VARCHAR2	(240)	Description of the delete group
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	Original system that data for the current record has come from
ENFORCE_INT_REQUIREMENTS	VARCHAR2	(80)	Enforce Integer Requirements
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)
PLAN_LEVEL	NUMBER		Plan level based on model bill (for ATO)
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)	Auomatically create move order for the material at work order release
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)	Suggested vendor name will be used for direct items for EAM BOMs
UNIT_PRICE	NUMBER		Unit Price for direct items used by EAM BOMs
NEW_REVISED_ITEM_REVISION	VARCHAR2	(3)	New Revised Item Revision is one of the unique keys to identify a revised item of a change
BASIS_TYPE	NUMBER		Basis type identifier
INVERSE_QUANTITY	NUMBER		Inverse Quantity of component in bill of material
OBJ_NAME	VARCHAR2	(30)	Object Name
PK1_VALUE	VARCHAR2	(240)	Primary Key of Object
PK2_VALUE	VARCHAR2	(240)	Primary Key of Object
PK3_VALUE	VARCHAR2	(240)	Primary Key of Object
PK4_VALUE	VARCHAR2	(240)	Primary Key of Object
PK5_VALUE	VARCHAR2	(240)	Primary Key of Object
FROM_OBJECT_REVISION_CODE	VARCHAR2	(80)	From Object Revision Code
FROM_OBJECT_REVISION_ID	NUMBER		From Object Revision Identifier
TO_OBJECT_REVISION_CODE	VARCHAR2	(240)	To Object Revision Code
TO_OBJECT_REVISION_ID	NUMBER		To Object Revision Identifier
FROM_MINOR_REVISION_CODE	VARCHAR2	(240)	From Minor Revision Code
FROM_MINOR_REVISION_ID	NUMBER		From Minor Revision Identifier
TO_MINOR_REVISION_CODE	VARCHAR2	(240)	To Minor Revision Code
TO_MINOR_REVISION_ID	NUMBER		To Minor Revision Identifier
FROM_END_ITEM_MINOR_REV_CODE	VARCHAR2	(240)	From End Item Minor Revision Code
FROM_END_ITEM_MINOR_REV_ID	NUMBER		From End Item Minor Revision Identifier
TO_END_ITEM_MINOR_REV_CODE	VARCHAR2	(240)	To End Item Minor Revision Code
TO_END_ITEM_MINOR_REV_ID	NUMBER		To End Item Minor Revision Identifier
RETURN_STATUS	VARCHAR2	(1)	Return Status
FROM_END_ITEM	VARCHAR2	(240)	From End Item Name
FROM_END_ITEM_ID	NUMBER		From End Item Identifier
FROM_END_ITEM_REV_CODE	VARCHAR2	(240)	From end item revision code
FROM_END_ITEM_REV_ID	NUMBER		From end item revision id
TO_END_ITEM_REV_CODE	VARCHAR2	(240)	To end item revision code
TO_END_ITEM_REV_ID	NUMBER		To end item revision id
COMPONENT_REVISION_CODE	VARCHAR2	(240)	Holds the value of componnet revision code. This value will be used for adding fixed revision components.
COMPONENT_REVISION_ID	NUMBER		Holds the value of componnet revision id. This value will be used for adding fixed revision components.
BATCH_ID	NUMBER		Batch Identifier for Data Load
COMP_SOURCE_SYSTEM_REFERENCE	VARCHAR2	(240)	Component Source System Item Name
COMP_SOURCE_SYSTEM_REFER_DESC	VARCHAR2	(240)	Component Source System Item Description
PARENT_SOURCE_SYSTEM_REFERENCE	VARCHAR2	(240)	Parent Source System Item Name
CATALOG_CATEGORY_NAME	VARCHAR2	(240)	Item Catalog Category Name
ITEM_CATALOG_GROUP_ID	NUMBER		Item Catalog Category Identifier
CHANGE_ID	NUMBER		Change Identifier
TEMPLATE_NAME	VARCHAR2	(240)	Item Template Name
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)	Primary Unit of Measure
ITEM_DESCRIPTION	VARCHAR2	(240)	Item Description
COMMON_COMPONENT_SEQUENCE_ID	NUMBER		Common Component Sequence Id
CHANGE_TRANSACTION_TYPE	VARCHAR2	(10)	Change Management Transaction Type for Change Orders
INTERFACE_TABLE_UNIQUE_ID	NUMBER		Interface Table Unique Id for Merge
PARENT_REVISION_CODE	VARCHAR2	(240)	Parent Revision Code
PARENT_REVISION_ID	NUMBER		Parent Revision Id
BUNDLE_ID	NUMBER		Bundle Identifier

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
,      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
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      REVISED_ITEM_SEQUENCE_ID
,      MODEL_COMP_SEQ_ID
,      ASSEMBLY_ITEM_ID
,      ALTERNATE_BOM_DESIGNATOR
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COMPONENT_ITEM_NUMBER
,      ASSEMBLY_ITEM_NUMBER
,      REVISED_ITEM_NUMBER
,      LOCATION_NAME
,      REFERENCE_DESIGNATOR
,      SUBSTITUTE_COMP_ID
,      SUBSTITUTE_COMP_NUMBER
,      TRANSACTION_ID
,      PROCESS_FLAG
,      BOM_ITEM_TYPE
,      OPERATION_LEAD_TIME_PERCENT
,      COST_FACTOR
,      INCLUDE_ON_BILL_DOCS
,      PICK_COMPONENTS
,      DDF_CONTEXT1
,      DDF_CONTEXT2
,      NEW_OPERATION_SEQ_NUM
,      OLD_OPERATION_SEQ_NUM
,      NEW_EFFECTIVITY_DATE
,      OLD_EFFECTIVITY_DATE
,      ASSEMBLY_TYPE
,      INTERFACE_ENTITY_TYPE
,      TRANSACTION_TYPE
,      BOM_INVENTORY_COMPS_IFCE_KEY
,      ENG_REVISED_ITEMS_IFCE_KEY
,      ENG_CHANGES_IFCE_KEY
,      TO_END_ITEM_UNIT_NUMBER
,      FROM_END_ITEM_UNIT_NUMBER
,      NEW_FROM_END_ITEM_UNIT_NUMBER
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      ORIGINAL_SYSTEM_REFERENCE
,      ENFORCE_INT_REQUIREMENTS
,      OPTIONAL_ON_MODEL
,      PARENT_BILL_SEQ_ID
,      PLAN_LEVEL
,      AUTO_REQUEST_MATERIAL
,      SUGGESTED_VENDOR_NAME
,      UNIT_PRICE
,      NEW_REVISED_ITEM_REVISION
,      BASIS_TYPE
,      INVERSE_QUANTITY
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      FROM_OBJECT_REVISION_CODE
,      FROM_OBJECT_REVISION_ID
,      TO_OBJECT_REVISION_CODE
,      TO_OBJECT_REVISION_ID
,      FROM_MINOR_REVISION_CODE
,      FROM_MINOR_REVISION_ID
,      TO_MINOR_REVISION_CODE
,      TO_MINOR_REVISION_ID
,      FROM_END_ITEM_MINOR_REV_CODE
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_MINOR_REV_CODE
,      TO_END_ITEM_MINOR_REV_ID
,      RETURN_STATUS
,      FROM_END_ITEM
,      FROM_END_ITEM_ID
,      FROM_END_ITEM_REV_CODE
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_CODE
,      TO_END_ITEM_REV_ID
,      COMPONENT_REVISION_CODE
,      COMPONENT_REVISION_ID
,      BATCH_ID
,      COMP_SOURCE_SYSTEM_REFERENCE
,      COMP_SOURCE_SYSTEM_REFER_DESC
,      PARENT_SOURCE_SYSTEM_REFERENCE
,      CATALOG_CATEGORY_NAME
,      ITEM_CATALOG_GROUP_ID
,      CHANGE_ID
,      TEMPLATE_NAME
,      PRIMARY_UNIT_OF_MEASURE
,      ITEM_DESCRIPTION
,      COMMON_COMPONENT_SEQUENCE_ID
,      CHANGE_TRANSACTION_TYPE
,      INTERFACE_TABLE_UNIQUE_ID
,      PARENT_REVISION_CODE
,      PARENT_REVISION_ID
,      BUNDLE_ID
FROM BOM.BOM_INVENTORY_COMPS_INTERFACE;

Dependencies

[top of page]

BOM.BOM_INVENTORY_COMPS_INTERFACE does not reference any database object

BOM.BOM_INVENTORY_COMPS_INTERFACE is referenced by following:

BOM: BOM_INVENTORY_COMPS_INTERFACE#