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_SUB_COMPS_INTERFACE

Object Details

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

BOM_SUB_COMPS_INTERFACE temporarily stores information about the
substitute components associated with a bill of material component.
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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_SUB_COMPS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COMPONENT_SEQUENCE_ID SUBSTITUTE_COMPONENT_ID
BOM_SUB_COMPS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID ASSEMBLY_ITEM_ID ALTERNATE_BOM_DESIGNATOR
BOM_SUB_COMPS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
BOM_SUB_COMPS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_ID BOM_SUB_COMPS_IFCE_KEY
BOM_SUB_COMPS_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_CODE ALTERNATE_BOM_DESIGNATOR
BOM_SUB_COMPS_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY
BOM_SUB_COMPS_INTERFACE_N7	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_FLAG ORGANIZATION_ID TRANSACTION_ID

Columns

Name	Datatype	Length	Comments
SUBSTITUTE_COMPONENT_ID	NUMBER		Inventory item identifier of substitute component
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
SUBSTITUTE_ITEM_QUANTITY	NUMBER		Substitute component quantity
COMPONENT_SEQUENCE_ID	NUMBER		Component unique identifier
ACD_TYPE	NUMBER		Add or delete code from an engineering change order
CHANGE_NOTICE	VARCHAR2	(10)	Engineering change order number
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
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
BILL_SEQUENCE_ID	NUMBER		Bill of material unique identifier
ASSEMBLY_ITEM_ID	NUMBER		Inventory item identifier of the bill
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)	Alternate designator code
ORGANIZATION_ID	NUMBER		Organization identifier
COMPONENT_ITEM_ID	NUMBER		Component item identifier
OPERATION_SEQ_NUM	NUMBER		Operation sequence number
EFFECTIVITY_DATE	DATE		Effective date
TRANSACTION_ID	NUMBER		Row identifier
PROCESS_FLAG	NUMBER		Row status
ORGANIZATION_CODE	VARCHAR2	(3)	Abbreviation of organization name
SUBSTITUTE_COMP_NUMBER	VARCHAR2	(240)	Concatenated item segments of the substitute component
COMPONENT_ITEM_NUMBER	VARCHAR2	(240)	Concatenated item segments of the component
ASSEMBLY_ITEM_NUMBER	VARCHAR2	(240)	Concatenated item segments of the bill
NEW_SUB_COMP_ID	NUMBER		Updated value for the SUBSTITUTE_COMPONENT_ID
NEW_SUB_COMP_NUMBER	VARCHAR2	(240)	Updated value for the SUBSTITUTE_COMP_NUMBER
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_SUB_COMPS_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows pertaining to the same business object
BOM_INVENTORY_COMPS_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows pertaining to the same business object
ENG_REVISED_ITEMS_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows pertaining to the same business object
ENG_CHANGES_IFCE_KEY	VARCHAR2	(30)	User defined identifier to link rows pertaining to the same business object
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(240)	From End Item Unit Number
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(240)	Original system that data for the current record has come from
ENFORCE_INT_REQUIREMENTS	VARCHAR2	(80)	Enforce Integer Requirements
NEW_REVISED_ITEM_REVISION	VARCHAR2	(3)	New Revised Item Revision is one of the unique keys to identify a revised item of a change
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
SUBCOM_SOURCE_SYSTEM_REFERENCE	VARCHAR2	(240)	Subcomponent Source System Item Name
CHANGE_ID	NUMBER		Change Identifier
SUB_COMP_INVERSE_QUANTITY	NUMBER		Inverse Quantity of substitute component in bill of material
CHANGE_TRANSACTION_TYPE	VARCHAR2	(10)	Change Management Transaction Type for Change Orders
INTERFACE_TABLE_UNIQUE_ID	NUMBER		Interface Table Unique Id for Merge
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 SUBSTITUTE_COMPONENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SUBSTITUTE_ITEM_QUANTITY
,      COMPONENT_SEQUENCE_ID
,      ACD_TYPE
,      CHANGE_NOTICE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BILL_SEQUENCE_ID
,      ASSEMBLY_ITEM_ID
,      ALTERNATE_BOM_DESIGNATOR
,      ORGANIZATION_ID
,      COMPONENT_ITEM_ID
,      OPERATION_SEQ_NUM
,      EFFECTIVITY_DATE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      ORGANIZATION_CODE
,      SUBSTITUTE_COMP_NUMBER
,      COMPONENT_ITEM_NUMBER
,      ASSEMBLY_ITEM_NUMBER
,      NEW_SUB_COMP_ID
,      NEW_SUB_COMP_NUMBER
,      INTERFACE_ENTITY_TYPE
,      TRANSACTION_TYPE
,      BOM_SUB_COMPS_IFCE_KEY
,      BOM_INVENTORY_COMPS_IFCE_KEY
,      ENG_REVISED_ITEMS_IFCE_KEY
,      ENG_CHANGES_IFCE_KEY
,      FROM_END_ITEM_UNIT_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      ENFORCE_INT_REQUIREMENTS
,      NEW_REVISED_ITEM_REVISION
,      RETURN_STATUS
,      BATCH_ID
,      COMP_SOURCE_SYSTEM_REFERENCE
,      PARENT_SOURCE_SYSTEM_REFERENCE
,      SUBCOM_SOURCE_SYSTEM_REFERENCE
,      CHANGE_ID
,      SUB_COMP_INVERSE_QUANTITY
,      CHANGE_TRANSACTION_TYPE
,      INTERFACE_TABLE_UNIQUE_ID
,      ASSEMBLY_ITEM_REVISION_CODE
,      ASSEMBLY_ITEM_REVISION_ID
FROM BOM.BOM_SUB_COMPS_INTERFACE;

Dependencies

[top of page]

BOM.BOM_SUB_COMPS_INTERFACE does not reference any database object

BOM.BOM_SUB_COMPS_INTERFACE is referenced by following:

APPS: BOM_BSCI_UNIQUE_ID_T; BOM_SUB_COMPS_INTERFACE