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_COMPONENT_OPS_INTERFACE

Object Details

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

BOM_COMP_OPS_INTERFACE stores interface data about the additional routing operations for a bill of material component.
Component operations allow a component to have multiple operations without having to replicate the component rows. The operation sequence number of the component row in BOM_INVENTORY_COMPONENTS is the consuming operation.
Component operations can be defined only for the optional components.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_COMPONENT_OPS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
BOM_COMPONENT_OPS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_CODE ALTERNATE_BOM_DESIGNATOR
BOM_COMPONENT_OPS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_FLAG ORGANIZATION_ID TRANSACTION_ID

Columns

Name	Datatype	Length	Comments
COMP_OPERATION_SEQ_ID	NUMBER		Component operation unique identifier
OPERATION_SEQ_NUM	NUMBER		Operation Sequence Number, showing the sequences of process and line operations
ADDITIONAL_OPERATION_SEQ_NUM	NUMBER		Operation Sequence Number, showing the sequences of process and line operations
NEW_ADDITIONAL_OP_SEQ_NUM	NUMBER		Operation Sequence Number, showing the sequences of process and line operations
OPERATION_SEQUENCE_ID	NUMBER		Operation sequence 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
REQUEST_ID	NUMBER		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who column
PROGRAM_ID	NUMBER		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who column
COMPONENT_SEQUENCE_ID	NUMBER		Component unique identifier
BILL_SEQUENCE_ID	NUMBER		Bill of material unique identifier
CONSUMING_OPERATION_FLAG	VARCHAR2	(1)	Consuming operation indicator
CONSUMPTION_QUANTITY	NUMBER		Consumption quantity
SUPPLY_SUBINVENTORY	VARCHAR2	(10)	Supply subinventory
SUPPLY_LOCATOR_ID	NUMBER		Supply locator identifier
WIP_SUPPLY_TYPE	NUMBER		WIP supply type code
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
ASSEMBLY_ITEM_ID	NUMBER		Inventory item identifier of the bill
ASSEMBLY_ITEM_NUMBER	VARCHAR2	(240)	Concatenated item segments of the bill
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(240)	Alternate designator code
ORGANIZATION_ID	NUMBER		Organization identifier
ORGANIZATION_CODE	VARCHAR2	(240)	Abbreviation of organization name
COMPONENT_ITEM_ID	NUMBER		Component item identifier
COMPONENT_ITEM_NUMBER	VARCHAR2	(240)	Concatenated item segments of the component
EFFECTIVITY_DATE	DATE		Effective date
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(240)	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(240)	To End Item Unit Number
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(240)	Original system that data for the current record has come from
TRANSACTION_ID	NUMBER		Row identifier
PROCESS_FLAG	NUMBER		Row status
TRANSACTION_TYPE	VARCHAR2	(240)	Type of action: CREATE, UPDATE or DELETE
RETURN_STATUS	VARCHAR2	(1)	Return status
BATCH_ID	NUMBER		Batch Identifier for Data Load
COMP_SOURCE_SYSTEM_REFERENCE	VARCHAR2	(240)	Component Source System Item Name
PARENT_SOURCE_SYSTEM_REFERENCE	VARCHAR2	(240)	Parent Source System Item Name
ASSEMBLY_ITEM_REVISION_CODE	VARCHAR2	(240)	Assembly item revision code
ASSEMBLY_ITEM_REVISION_ID	NUMBER		Assembly item revision id

Query Text

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


SELECT COMP_OPERATION_SEQ_ID
,      OPERATION_SEQ_NUM
,      ADDITIONAL_OPERATION_SEQ_NUM
,      NEW_ADDITIONAL_OP_SEQ_NUM
,      OPERATION_SEQUENCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      CONSUMING_OPERATION_FLAG
,      CONSUMPTION_QUANTITY
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      WIP_SUPPLY_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASSEMBLY_ITEM_ID
,      ASSEMBLY_ITEM_NUMBER
,      ALTERNATE_BOM_DESIGNATOR
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COMPONENT_ITEM_ID
,      COMPONENT_ITEM_NUMBER
,      EFFECTIVITY_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      RETURN_STATUS
,      BATCH_ID
,      COMP_SOURCE_SYSTEM_REFERENCE
,      PARENT_SOURCE_SYSTEM_REFERENCE
,      ASSEMBLY_ITEM_REVISION_CODE
,      ASSEMBLY_ITEM_REVISION_ID
FROM BOM.BOM_COMPONENT_OPS_INTERFACE;

Dependencies

[top of page]

BOM.BOM_COMPONENT_OPS_INTERFACE does not reference any database object

BOM.BOM_COMPONENT_OPS_INTERFACE is referenced by following:

APPS: BOM_COMPONENT_OPS_INTERFACE