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

TABLE: BOM.BOM_COMPARISON_TEMP

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


BOM_COMPARISON_TEMP stores information about a comparison of two bills
of material. This table is used by both Oracle Bills of Material and
Oracle Engineering for the View Bill of Material Comparison window
and the Bill of Material Comparison report.
.
Each row may have ASSEMBLY_ID1, or ASSEMBLY_ID2, or both the columns
populated. If ASSEMBLY_ID1 alone is populated it means that component
is unique to the first bill in the comparison. If ASSEMBLY_ID2 alone
is populated it means that component is unique to the second bill in
the comparison. If ASSEMBLY_ID1 and ASSEMBLY_ID2 are both populated,
it means that component is common to the two bills being compared.
.
SEQUENCE_ID is the unique key to this table for a given execution of
an inquiry or report. It contains the next available sequence number
from the sequence BOM_COMPARISON_TEMP_S.


Temporary Table Details

BOM.BOM_COMPARISON_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
BOM_COMPARISON_TEMP_N1 NORMAL NONUNIQUE Tablespace ColumnSEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
SEQUENCE_ID NUMBER
Yes Unique ID used to identify the results of a comparison of two bills of material
ASSEMBLY_ID1 NUMBER

First assembly identifier
ASSEMBLY_ID2 NUMBER

Second assembly identifier
ITEM_NUM NUMBER

Item sequence within bill of material structure, which overrides operation sequence number as basis for BOM sorts
COMPONENT_QUANTITY NUMBER

Quantity of component in parent assembly
OPERATION_SEQ_NUM NUMBER

Operation sequence number
COMPONENT_YIELD_FACTOR NUMBER

Factor by which a quantity is multiplied to obtain component yield
EFFECTIVITY_DATE DATE

Effective date
DISABLE_DATE DATE

Disable date
IMPLEMENTATION_DATE DATE

Date on which engineering change will be implemented
PLANNING_FACTOR NUMBER

Planning factor
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
OPTIONAL NUMBER

Optional (yes or no)
COMPONENT_SEQUENCE_ID1 NUMBER

Component sequence ID in first bill of material
COMPONENT_SEQUENCE_ID2 NUMBER

Component sequence ID in second bill of material
COMPONENT_NAME VARCHAR2 (255)
Component name
FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Current end item unit number
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
New end item unit number
Query Text

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


SELECT SEQUENCE_ID
,      ASSEMBLY_ID1
,      ASSEMBLY_ID2
,      ITEM_NUM
,      COMPONENT_QUANTITY
,      OPERATION_SEQ_NUM
,      COMPONENT_YIELD_FACTOR
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      IMPLEMENTATION_DATE
,      PLANNING_FACTOR
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OPTIONAL
,      COMPONENT_SEQUENCE_ID1
,      COMPONENT_SEQUENCE_ID2
,      COMPONENT_NAME
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
FROM BOM.BOM_COMPARISON_TEMP;

Dependencies

[top of page]

BOM.BOM_COMPARISON_TEMP does not reference any database object

BOM.BOM_COMPARISON_TEMP is referenced by following:

SchemaAPPS
SynonymBOM_COMPARISON_TEMP