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: ONT.OE_CONFIG_DETAILS_TMP

Object Details

Object Name:	OE_CONFIG_DETAILS_TMP
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_CONFIG_DETAILS_TMP
Subobject Name:
Status:	VALID

Temporary Table Details

ONT.OE_CONFIG_DETAILS_TMP 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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
BATCH_ID	NUMBER
LINE_ID	NUMBER
TOP_MODEL_LINE_ID	NUMBER
ATO_LINE_ID	NUMBER
LINK_TO_LINE_ID	NUMBER
ORDER_SOURCE_ID	NUMBER
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)
ORIG_SYS_LINE_REF	VARCHAR2	(50)
ORIG_SYS_SHIPMENT_REF	VARCHAR2	(50)
TOP_MODEL_LINE_REF	VARCHAR2	(50)
ORDERED_ITEM	VARCHAR2	(2000)
INVENTORY_ITEM_ID	NUMBER
UOM_CODE	VARCHAR2	(3)
ORDERED_QUANTITY	NUMBER
COMPONENT_CODE	VARCHAR2	(1000)
COMPONENT_SEQUENCE_ID	NUMBER
SORT_ORDER	VARCHAR2	(2000)
CONFIG_HEADER_ID	NUMBER
CONFIG_REV_NBR	NUMBER
CONFIGURATION_ID	NUMBER
TOP_BILL_SEQUENCE_ID	NUMBER
ITEM_TYPE_CODE	VARCHAR2	(30)
LINE_TYPE	NUMBER
CZ_QTY_MATCH_FLAG	VARCHAR2	(1)
HIGH_QUANTITY	NUMBER
LOW_QUANTITY	NUMBER
MUTUALLY_EXCLUSIVE_OPTIONS	NUMBER
BOM_ITEM_TYPE	NUMBER
LOCK_CONTROL	NUMBER
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)

Query Text

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


SELECT BATCH_ID
,      LINE_ID
,      TOP_MODEL_LINE_ID
,      ATO_LINE_ID
,      LINK_TO_LINE_ID
,      ORDER_SOURCE_ID
,      ORIG_SYS_DOCUMENT_REF
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_SHIPMENT_REF
,      TOP_MODEL_LINE_REF
,      ORDERED_ITEM
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      ORDERED_QUANTITY
,      COMPONENT_CODE
,      COMPONENT_SEQUENCE_ID
,      SORT_ORDER
,      CONFIG_HEADER_ID
,      CONFIG_REV_NBR
,      CONFIGURATION_ID
,      TOP_BILL_SEQUENCE_ID
,      ITEM_TYPE_CODE
,      LINE_TYPE
,      CZ_QTY_MATCH_FLAG
,      HIGH_QUANTITY
,      LOW_QUANTITY
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      BOM_ITEM_TYPE
,      LOCK_CONTROL
,      REPLENISH_TO_ORDER_FLAG
FROM ONT.OE_CONFIG_DETAILS_TMP;

Dependencies

[top of page]

ONT.OE_CONFIG_DETAILS_TMP does not reference any database object

ONT.OE_CONFIG_DETAILS_TMP is referenced by following:

APPS: OE_CONFIG_DETAILS_TMP