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_REF_DESGS_INTERFACE

Object Details

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

BOM_REF_DESGS_INTERFACE temporarily stores information about
bill of material component reference designators. 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_REF_DESGS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORGANIZATION_ID ASSEMBLY_ITEM_ID ALTERNATE_BOM_DESIGNATOR
BOM_REF_DESGS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COMPONENT_SEQUENCE_ID COMPONENT_REFERENCE_DESIGNATOR
BOM_REF_DESGS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
BOM_REF_DESGS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_ID BOM_REF_DESGS_IFCE_KEY
BOM_REF_DESGS_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSEMBLY_ITEM_NUMBER ORGANIZATION_CODE ALTERNATE_BOM_DESIGNATOR
BOM_REF_DESGS_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENG_CHANGES_IFCE_KEY
BOM_REF_DESGS_INTERFACE_N7	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_FLAG ORGANIZATION_ID TRANSACTION_ID

Columns

Name	Datatype	Length	Comments
COMPONENT_REFERENCE_DESIGNATOR	VARCHAR2	(15)	Component reference designator
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
REF_DESIGNATOR_COMMENT	VARCHAR2	(240)	Reference designator comment
CHANGE_NOTICE	VARCHAR2	(10)	Engineering change order number
COMPONENT_SEQUENCE_ID	NUMBER		Component unique identifier
ACD_TYPE	NUMBER		Add or delete code from an ECO
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
ORGANIZATION_CODE	VARCHAR2	(3)	Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER	VARCHAR2	(240)	Concatenated item segments of the bill
COMPONENT_ITEM_NUMBER	VARCHAR2	(240)	Concatenated item segments of the component
TRANSACTION_ID	NUMBER		Row identifier
PROCESS_FLAG	NUMBER		Row status
NEW_DESIGNATOR	VARCHAR2	(15)	Updated value for the old reference designator.
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_REF_DESGS_IFCE_KEY	VARCHAR2	(30)	User defined identifier for linking rows of 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
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
CHANGE_ID	NUMBER		Change Identifier
CHANGE_TRANSACTION_TYPE	VARCHAR2	(10)	Change Management Transaction Type for Change Orders
INTERFACE_TABLE_UNIQUE_ID	NUMBER		InterfaceTable 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 COMPONENT_REFERENCE_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REF_DESIGNATOR_COMMENT
,      CHANGE_NOTICE
,      COMPONENT_SEQUENCE_ID
,      ACD_TYPE
,      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
,      ORGANIZATION_CODE
,      ASSEMBLY_ITEM_NUMBER
,      COMPONENT_ITEM_NUMBER
,      TRANSACTION_ID
,      PROCESS_FLAG
,      NEW_DESIGNATOR
,      INTERFACE_ENTITY_TYPE
,      TRANSACTION_TYPE
,      BOM_REF_DESGS_IFCE_KEY
,      BOM_INVENTORY_COMPS_IFCE_KEY
,      ENG_REVISED_ITEMS_IFCE_KEY
,      ENG_CHANGES_IFCE_KEY
,      FROM_END_ITEM_UNIT_NUMBER
,      ORIGINAL_SYSTEM_REFERENCE
,      NEW_REVISED_ITEM_REVISION
,      RETURN_STATUS
,      BATCH_ID
,      COMP_SOURCE_SYSTEM_REFERENCE
,      PARENT_SOURCE_SYSTEM_REFERENCE
,      CHANGE_ID
,      CHANGE_TRANSACTION_TYPE
,      INTERFACE_TABLE_UNIQUE_ID
,      ASSEMBLY_ITEM_REVISION_CODE
,      ASSEMBLY_ITEM_REVISION_ID
FROM BOM.BOM_REF_DESGS_INTERFACE;

Dependencies

[top of page]

BOM.BOM_REF_DESGS_INTERFACE does not reference any database object

BOM.BOM_REF_DESGS_INTERFACE is referenced by following:

APPS: BOM_BRDI_UNIQUE_ID_T; BOM_REF_DESGS_INTERFACE