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

TABLE: WMS.WMS_WP_EXCEPTIONS_GTMP

Object Details
Object Name: WMS_WP_EXCEPTIONS_GTMP
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_WP_EXCEPTIONS_GTMP
Subobject Name:
Status: VALID

Temporary Table Details

WMS.WMS_WP_EXCEPTIONS_GTMP 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
EXCEPTION_NAME VARCHAR2 (200)
EXCEPTION_ID NUMBER

LOGGING_ENTITY VARCHAR2 (400)
ENTITY_VALUE NUMBER

SEVERITY_LEVEL VARCHAR2 (300)
EXCEPTION_MESSAGE VARCHAR2 (4000)
CREATION_DATE DATE

STATUS VARCHAR2 (20)
READY_TO_RELEASE VARCHAR2 (10)
BACKORDERED VARCHAR2 (10)
CROSSDOCK_PLANNED VARCHAR2 (10)
REPLENISHMENT_PLANNED VARCHAR2 (10)
TASKED VARCHAR2 (10)
PICKED VARCHAR2 (10)
PACKED VARCHAR2 (10)
STAGED VARCHAR2 (10)
LOADED_TO_DOCK VARCHAR2 (10)
SHIPPED VARCHAR2 (10)
Query Text

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


SELECT EXCEPTION_NAME
,      EXCEPTION_ID
,      LOGGING_ENTITY
,      ENTITY_VALUE
,      SEVERITY_LEVEL
,      EXCEPTION_MESSAGE
,      CREATION_DATE
,      STATUS
,      READY_TO_RELEASE
,      BACKORDERED
,      CROSSDOCK_PLANNED
,      REPLENISHMENT_PLANNED
,      TASKED
,      PICKED
,      PACKED
,      STAGED
,      LOADED_TO_DOCK
,      SHIPPED
FROM WMS.WMS_WP_EXCEPTIONS_GTMP;

Dependencies

[top of page]

WMS.WMS_WP_EXCEPTIONS_GTMP does not reference any database object

WMS.WMS_WP_EXCEPTIONS_GTMP is referenced by following:

SchemaAPPS
SynonymWMS_WP_EXCEPTIONS_GTMP