eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ZX.ZX_REV_TRX_HEADERS_GT

Object Details

Object Name:	ZX_REV_TRX_HEADERS_GT
Object Type:	TABLE
Owner:	ZX
Subobject Name:
Status:	VALID

Temporary Table Details

ZX.ZX_REV_TRX_HEADERS_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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_REV_TRX_HEADERS_GT_U1	NORMAL	UNIQUE		REVERSING_APPLN_ID REVERSING_ENTITY_CODE REVERSING_EVNT_CLS_CODE REVERSING_TRX_ID

Columns

Name	Datatype	Length	Mandatory
INTERNAL_ORGANIZATION_ID	NUMBER		Yes
REVERSING_APPLN_ID	NUMBER		Yes
REVERSING_ENTITY_CODE	VARCHAR2	(30)	Yes
REVERSING_EVNT_CLS_CODE	VARCHAR2	(30)	Yes
REVERSING_TRX_ID	NUMBER		Yes
REVERSING_HDR_USER_KEY1	VARCHAR2	(150)
REVERSING_HDR_USER_KEY2	VARCHAR2	(150)
REVERSING_HDR_USER_KEY3	VARCHAR2	(150)
REVERSING_HDR_USER_KEY4	VARCHAR2	(150)
REVERSING_HDR_USER_KEY5	VARCHAR2	(150)
REVERSING_HDR_USER_KEY6	VARCHAR2	(150)
TRX_NUMBER	VARCHAR2	(150)
TRX_DESCRIPTION	VARCHAR2	(240)
TRX_COMMUNICATED_DATE	DATE
BATCH_SOURCE_ID	NUMBER
BATCH_SOURCE_NAME	VARCHAR2	(150)
DOC_SEQ_ID	NUMBER
DOC_SEQ_NAME	VARCHAR2	(150)
DOC_SEQ_VALUE	VARCHAR2	(240)
TRX_DUE_DATE	DATE
TRX_TYPE_DESCRIPTION	VARCHAR2	(240)
DOCUMENT_SUB_TYPE	VARCHAR2	(240)
SUPPLIER_TAX_INVOICE_NUMBER	VARCHAR2	(150)
SUPPLIER_TAX_INVOICE_DATE	DATE
SUPPLIER_EXCHANGE_RATE	NUMBER
TAX_INVOICE_DATE	DATE
TAX_INVOICE_NUMBER	VARCHAR2	(150)
LEGAL_ENTITY_ID	NUMBER		Yes

Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      REVERSING_APPLN_ID
,      REVERSING_ENTITY_CODE
,      REVERSING_EVNT_CLS_CODE
,      REVERSING_TRX_ID
,      REVERSING_HDR_USER_KEY1
,      REVERSING_HDR_USER_KEY2
,      REVERSING_HDR_USER_KEY3
,      REVERSING_HDR_USER_KEY4
,      REVERSING_HDR_USER_KEY5
,      REVERSING_HDR_USER_KEY6
,      TRX_NUMBER
,      TRX_DESCRIPTION
,      TRX_COMMUNICATED_DATE
,      BATCH_SOURCE_ID
,      BATCH_SOURCE_NAME
,      DOC_SEQ_ID
,      DOC_SEQ_NAME
,      DOC_SEQ_VALUE
,      TRX_DUE_DATE
,      TRX_TYPE_DESCRIPTION
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_EXCHANGE_RATE
,      TAX_INVOICE_DATE
,      TAX_INVOICE_NUMBER
,      LEGAL_ENTITY_ID
FROM ZX.ZX_REV_TRX_HEADERS_GT;

Dependencies

[top of page]

ZX.ZX_REV_TRX_HEADERS_GT does not reference any database object

ZX.ZX_REV_TRX_HEADERS_GT is referenced by following:

APPS: ZX_REV_TRX_HEADERS_GT