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_BILLS_HEADER_TEMP

Object Details

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

BOM_BILLS_HEADER_TEMP temporarily stores bills of material
before loading information into Oracle Bills of Material. This
table contains user friendly columns which allow you to easily enter
your data as well as their corresponding foreign keys. Oracle Bills
of Material will derive column values you do not enter, after
performing the proper validation.
This table is for future use.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_BILLS_HEADER_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_GROUP_ID
BOM_BILLS_HEADER_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID

Columns

Name	Datatype	Length	Comments
TRANSACTION_GROUP_ID	NUMBER		Transaction group identifier
TRANSACTION_ID	NUMBER		Transaction identifier
ASSEMBLY_ITEM_NAME	VARCHAR2	(81)	Concatenated bill item segments
ORGANIZATION_CODE	VARCHAR2	(3)	Organization code
ALTERNATE_BOM_CODE	VARCHAR2	(10)	Alternate designator code
COMMON_ASSEMBLY_ITEM_NAME	VARCHAR2	(81)	Assembly item name of common bill
COMMON_ORGANIZATION_CODE	VARCHAR2	(3)	Organization code of common bill
ASSEMBLY_TYPE	NUMBER		Assembly type: 1=Manufacturing bill 2=Engineering bill
ASSEMBLY_COMMENT	VARCHAR2	(240)	Specific bill of material comment
TRANSACTION_TYPE	VARCHAR2	(30)	Transaction Type which specifies what oeration is to be performed on a record.
RETURN_STATUS	VARCHAR2	(1)	Return Status
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
DELETE_GROUP_NAME	VARCHAR2	(10)	Delete group name
DG_DESCRIPTION	VARCHAR2	(240)	Delete group description
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	Original system that data for the current record has come from.

Query Text

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


SELECT TRANSACTION_GROUP_ID
,      TRANSACTION_ID
,      ASSEMBLY_ITEM_NAME
,      ORGANIZATION_CODE
,      ALTERNATE_BOM_CODE
,      COMMON_ASSEMBLY_ITEM_NAME
,      COMMON_ORGANIZATION_CODE
,      ASSEMBLY_TYPE
,      ASSEMBLY_COMMENT
,      TRANSACTION_TYPE
,      RETURN_STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      ORIGINAL_SYSTEM_REFERENCE
FROM BOM.BOM_BILLS_HEADER_TEMP;

Dependencies

[top of page]

BOM.BOM_BILLS_HEADER_TEMP does not reference any database object

BOM.BOM_BILLS_HEADER_TEMP is referenced by following:

APPS: BOM_BILLS_HEADER_TEMP