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

TABLE: ZX.ZX_ERRORS_GT

Object Details
Object Name: ZX_ERRORS_GT
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_ERRORS_GT
Subobject Name:
Status: VALID

Temporary Table Details

ZX.ZX_ERRORS_GT 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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
ZX_ERRORS_GT_N1 NORMAL NONUNIQUE Tablespace ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTRX_LEVEL_TYPE
ColumnSUMMARY_TAX_LINE_NUMBER
ColumnTAX_LINE_ID
ColumnTRX_LINE_DIST_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier of the transaction
ENTITY_CODE VARCHAR2 (30) Yes Entity code of the transaction
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event class code of the transaction
TRX_ID NUMBER
Yes Primary transaction identifier
TRX_LINE_ID NUMBER

Transaction line identifier
SUMMARY_TAX_LINE_NUMBER NUMBER

Summary tax line identifier
TRX_LINE_DIST_ID NUMBER

Item distribution identifier
MESSAGE_TEXT VARCHAR2 (2000) Yes Translated message text
TAX_LINE_ID NUMBER (15)
Tax line identifier
TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
Query Text

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


SELECT APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_ID
,      TRX_LINE_ID
,      SUMMARY_TAX_LINE_NUMBER
,      TRX_LINE_DIST_ID
,      MESSAGE_TEXT
,      TAX_LINE_ID
,      TRX_LEVEL_TYPE
FROM ZX.ZX_ERRORS_GT;

Dependencies

[top of page]

ZX.ZX_ERRORS_GT does not reference any database object

ZX.ZX_ERRORS_GT is referenced by following:

SchemaAPPS
SynonymZX_ERRORS_GT