DBA Data[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_DEPENDENT_DESC_ELEMENTS

Object Details
Object Name: BOM_DEPENDENT_DESC_ELEMENTS
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_DEPENDENT_DESC_ELEMENTS
Subobject Name:
Status: VALID


BOM_DEPENDENT_DESC_ELEMENTS stores information about the descriptive
elements assigned to a bill of material. You can only assign
descriptive elements to model and option class bills of material. You
can choose from those defined in MTL_DESCRIPTIVE_ELEMENTS. For model
bills of material, you can only choose descriptive elements that are
in the model item's catalog group.
.
The descriptive elements assigned to a bill of material are used to
assign descriptive element values to configuration items that are
created for model/option sales orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_DEPENDENT_DESC_ELEMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_SEQUENCE_ID
ColumnELEMENT_NAME
Columns
Name Datatype Length Mandatory Comments
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
ELEMENT_NAME VARCHAR2 (30) Yes Descriptive element name
LAST_UPDATE_DATE DATE
Yes Last update date
LAST_UPDATED_BY NUMBER
Yes Last updated by
CREATION_DATE DATE
Yes Creation date
CREATED_BY NUMBER
Yes Created by
LAST_UPDATE_LOGIN NUMBER

Last update login
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
REQUEST_ID NUMBER

Concurrent Who column
Query Text

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


SELECT BILL_SEQUENCE_ID
,      ELEMENT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM BOM.BOM_DEPENDENT_DESC_ELEMENTS;

Dependencies

[top of page]

BOM.BOM_DEPENDENT_DESC_ELEMENTS does not reference any database object

BOM.BOM_DEPENDENT_DESC_ELEMENTS is referenced by following:

SchemaBOM
ViewBOM_DEPENDENT_DESC_ELEMENTS#