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.MLOG$_BOM_COMPONENTS_B

Object Details

Object Name:	MLOG$_BOM_COMPONENTS_B
Object Type:	TABLE
Owner:	BOM
Subobject Name:
Status:	VALID

snapshot log for master table BOM.BOM_COMPONENTS_B

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MLOG$_BOM_COMPONENTS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SNAPTIME$$ BILL_SEQUENCE_ID

Columns

Name	Datatype	Length
BILL_SEQUENCE_ID	NUMBER
BOM_ITEM_TYPE	NUMBER
CHECK_ATP	NUMBER
COMPONENT_ITEM_ID	NUMBER
COMPONENT_QUANTITY	NUMBER
COMPONENT_SEQUENCE_ID	NUMBER
COMPONENT_YIELD_FACTOR	NUMBER
DISABLE_DATE	DATE
EFFECTIVITY_DATE	DATE
ENFORCE_INT_REQUIREMENTS	NUMBER
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
OBJ_NAME	VARCHAR2	(30)
OPERATION_LEAD_TIME_PERCENT	NUMBER
OPERATION_SEQ_NUM	NUMBER
OPTIONAL	NUMBER
PLANNING_FACTOR	NUMBER
REVISED_ITEM_SEQUENCE_ID	NUMBER
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
WIP_SUPPLY_TYPE	NUMBER
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)

Query Text

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


SELECT BILL_SEQUENCE_ID
,      BOM_ITEM_TYPE
,      CHECK_ATP
,      COMPONENT_ITEM_ID
,      COMPONENT_QUANTITY
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_YIELD_FACTOR
,      DISABLE_DATE
,      EFFECTIVITY_DATE
,      ENFORCE_INT_REQUIREMENTS
,      FROM_END_ITEM_UNIT_NUMBER
,      OBJ_NAME
,      OPERATION_LEAD_TIME_PERCENT
,      OPERATION_SEQ_NUM
,      OPTIONAL
,      PLANNING_FACTOR
,      REVISED_ITEM_SEQUENCE_ID
,      TO_END_ITEM_UNIT_NUMBER
,      WIP_SUPPLY_TYPE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM BOM.MLOG$_BOM_COMPONENTS_B;

Dependencies

[top of page]

BOM.MLOG$_BOM_COMPONENTS_B does not reference any database object

BOM.MLOG$_BOM_COMPONENTS_B is referenced by following:

APPS: MLOG$_BOM_COMPONENTS_B