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

TABLE: INV.INV_DIAG_MSN_TEMP

Object Details
Object Name: INV_DIAG_MSN_TEMP
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.INV_DIAG_MSN_TEMP
Subobject Name:
Status: VALID

Temporary Table Details

INV.INV_DIAG_MSN_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
SERIAL_NUMBER VARCHAR2 (30)
ORG_ID NUMBER

INVENTORY_ITEM_ID NUMBER

CURRENT_STATUS NUMBER

CURRENT_SUBINVENTORY_CODE VARCHAR2 (10)
CURRENT_LOCATOR_ID NUMBER

LOT_NUMBER VARCHAR2 (30)
LAST_TXN_SOURCE_TYPE_ID NUMBER

LAST_TRANSACTION_ID NUMBER

LAST_TXN_SOURCE_ID NUMBER

LAST_RECEIPT_ISSUE_TYPE NUMBER

GROUP_MARK_ID NUMBER

LINE_MARK_ID NUMBER

LOT_LINE_MARK_ID NUMBER

ORIGINAL_WIP_ENTITY_ID NUMBER

COST_GROUP_ID NUMBER

LPN_ID NUMBER

PARENT_SERIAL_NUMBER VARCHAR2 (30)
PARENT_ITEM_ID NUMBER

LAST_UPDATE_DATE DATE

Query Text

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


SELECT SERIAL_NUMBER
,      ORG_ID
,      INVENTORY_ITEM_ID
,      CURRENT_STATUS
,      CURRENT_SUBINVENTORY_CODE
,      CURRENT_LOCATOR_ID
,      LOT_NUMBER
,      LAST_TXN_SOURCE_TYPE_ID
,      LAST_TRANSACTION_ID
,      LAST_TXN_SOURCE_ID
,      LAST_RECEIPT_ISSUE_TYPE
,      GROUP_MARK_ID
,      LINE_MARK_ID
,      LOT_LINE_MARK_ID
,      ORIGINAL_WIP_ENTITY_ID
,      COST_GROUP_ID
,      LPN_ID
,      PARENT_SERIAL_NUMBER
,      PARENT_ITEM_ID
,      LAST_UPDATE_DATE
FROM INV.INV_DIAG_MSN_TEMP;

Dependencies

[top of page]

INV.INV_DIAG_MSN_TEMP does not reference any database object

INV.INV_DIAG_MSN_TEMP is referenced by following:

SchemaAPPS
SynonymINV_DIAG_MSN_TEMP