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

TABLE: INV.MTL_CONSIGNED_QTY_TEMP

Object Details
Object Name: MTL_CONSIGNED_QTY_TEMP
Object Type: TABLE
Owner: INV
Subobject Name:
Status: VALID

Temporary Table Details

INV.MTL_CONSIGNED_QTY_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
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
REVISION VARCHAR2 (3)
LOT_NUMBER VARCHAR2 (80)
LOT_EXPIRATION_DATE DATE

GRADE_CODE VARCHAR2 (150)
SUBINVENTORY_CODE VARCHAR2 (10)
RESERVABLE_TYPE NUMBER

LOCATOR_ID NUMBER

PRIMARY_QUANTITY NUMBER

SECONDARY_QUANTITY NUMBER

TRANSACTABLE_VMI NUMBER

TRANSACTABLE_SECONDARY_VMI NUMBER

DATE_RECEIVED DATE

QUANTITY_TYPE NUMBER

COST_GROUP_ID NUMBER

CONTAINERIZED NUMBER

PLANNING_ORGANIZATION_ID NUMBER

OWNING_ORGANIZATION_ID NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      GRADE_CODE
,      SUBINVENTORY_CODE
,      RESERVABLE_TYPE
,      LOCATOR_ID
,      PRIMARY_QUANTITY
,      SECONDARY_QUANTITY
,      TRANSACTABLE_VMI
,      TRANSACTABLE_SECONDARY_VMI
,      DATE_RECEIVED
,      QUANTITY_TYPE
,      COST_GROUP_ID
,      CONTAINERIZED
,      PLANNING_ORGANIZATION_ID
,      OWNING_ORGANIZATION_ID
FROM INV.MTL_CONSIGNED_QTY_TEMP;

Dependencies

[top of page]

INV.MTL_CONSIGNED_QTY_TEMP does not reference any database object

INV.MTL_CONSIGNED_QTY_TEMP is referenced by following:

SchemaAPPS
SynonymMTL_CONSIGNED_QTY_TEMP