[Home] [Help] [Dependency Information]
Object Name: | OE_CONFIG_DETAILS_TMP |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.OE_CONFIG_DETAILS_TMP |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
ONT.OE_CONFIG_DETAILS_TMP does not reference any database object
ONT.OE_CONFIG_DETAILS_TMP is referenced by following:
|
|
|