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

TABLE: ZX.ZX_PRVDR_HDR_EXTNS_GT

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

Temporary Table Details

ZX.ZX_PRVDR_HDR_EXTNS_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_PRVDR_HDR_EXTNS_GT_U1 NORMAL UNIQUE Tablespace ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnTRX_ID
ColumnPROVIDER_ID
ColumnTAX_REGIME_CODE
Columns
Name Datatype Length Mandatory Comments
EVENT_CLASS_CODE VARCHAR2 (30) Yes Application event class of the transaction
APPLICATION_ID NUMBER
Yes Application Identifier of the transaction
ENTITY_CODE VARCHAR2 (30) Yes Entity code of the application event class for the transaction
TRX_ID NUMBER
Yes Primary transaction identifier
PROVIDER_ID NUMBER (15) Yes Identifier of the third party service provider that has determined the tax on this summary line. Null if there is no third party service provider integration for the tax.
TAX_REGIME_CODE VARCHAR2 (30) Yes Tax regime code
HEADER_EXT_VARCHAR_ATTRIBUTE1 VARCHAR2 (150)
Header level user extensible attribute1 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE2 VARCHAR2 (150)
Header Level user extensible attribute2 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE3 VARCHAR2 (150)
Header Level user extensible attribute3 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE4 VARCHAR2 (150)
Header Level user extensible attribute4 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE5 VARCHAR2 (150)
Header Level user extensible attribute5 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE6 VARCHAR2 (150)
Header Level user extensible attribute6 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE7 VARCHAR2 (150)
Header Level user extensible attribute7 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE8 VARCHAR2 (150)
Header Level user extensible attribute8 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE9 VARCHAR2 (150)
Header Level user extensible attribute9 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE10 VARCHAR2 (150)
Header Level user extensible attribute10 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE11 VARCHAR2 (150)
Header Level user extensible attribute11 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE12 VARCHAR2 (150)
Header Level user extensible attribute12 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE13 VARCHAR2 (150)
Header Level user extensible attribute13 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE14 VARCHAR2 (150)
Header Level user extensible attribute14 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE15 VARCHAR2 (150)
Header Level user extensible attribute15 of type character used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE1 NUMBER

Header Level user extensible attribute1 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE2 NUMBER

Header Level user extensible attribute2 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE3 NUMBER

Header Level user extensible attribute3 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE4 NUMBER

Header Level user extensible attribute4 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE5 NUMBER

Header Level user extensible attribute5 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE6 NUMBER

Header Level user extensible attribute6 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE7 NUMBER

Header Level user extensible attribute7 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE8 NUMBER

Header Level user extensible attribute8 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE9 NUMBER

Header Level user extensible attribute9 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE10 NUMBER

Header Level user extensible attribute10 of type number used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE1 DATE

Header Level user extensible attribute1 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE2 DATE

Header Level user extensible attribute2 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE3 DATE

Header Level user extensible attribute3 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE4 DATE

Header Level user extensible attribute4 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE5 DATE

Header Level user extensible attribute5 of type date used by third party service provider
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
HEADER_EXT_VARCHAR_ATTRIBUTE16 VARCHAR2 (150)
Header Level user extensible attribute16 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE17 VARCHAR2 (150)
Header Level user extensible attribute17 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE18 VARCHAR2 (150)
Header Level user extensible attribute18 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE19 VARCHAR2 (150)
Header Level user extensible attribute19 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE20 VARCHAR2 (150)
Header Level user extensible attribute20 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE21 VARCHAR2 (150)
Header level user extensible attribute21 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE22 VARCHAR2 (150)
Header Level user extensible attribute22 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE23 VARCHAR2 (150)
Header Level user extensible attribute23 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE24 VARCHAR2 (150)
Header Level user extensible attribute24 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE25 VARCHAR2 (150)
Header Level user extensible attribute25 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE26 VARCHAR2 (150)
Header Level user extensible attribute26 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE27 VARCHAR2 (150)
Header Level user extensible attribute27 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE28 VARCHAR2 (150)
Header Level user extensible attribute28 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE29 VARCHAR2 (150)
Header Level user extensible attribute29 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE30 VARCHAR2 (150)
Header Level user extensible attribute30 of type character used by third party service provider
Query Text

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


SELECT EVENT_CLASS_CODE
,      APPLICATION_ID
,      ENTITY_CODE
,      TRX_ID
,      PROVIDER_ID
,      TAX_REGIME_CODE
,      HEADER_EXT_VARCHAR_ATTRIBUTE1
,      HEADER_EXT_VARCHAR_ATTRIBUTE2
,      HEADER_EXT_VARCHAR_ATTRIBUTE3
,      HEADER_EXT_VARCHAR_ATTRIBUTE4
,      HEADER_EXT_VARCHAR_ATTRIBUTE5
,      HEADER_EXT_VARCHAR_ATTRIBUTE6
,      HEADER_EXT_VARCHAR_ATTRIBUTE7
,      HEADER_EXT_VARCHAR_ATTRIBUTE8
,      HEADER_EXT_VARCHAR_ATTRIBUTE9
,      HEADER_EXT_VARCHAR_ATTRIBUTE10
,      HEADER_EXT_VARCHAR_ATTRIBUTE11
,      HEADER_EXT_VARCHAR_ATTRIBUTE12
,      HEADER_EXT_VARCHAR_ATTRIBUTE13
,      HEADER_EXT_VARCHAR_ATTRIBUTE14
,      HEADER_EXT_VARCHAR_ATTRIBUTE15
,      HEADER_EXT_NUMBER_ATTRIBUTE1
,      HEADER_EXT_NUMBER_ATTRIBUTE2
,      HEADER_EXT_NUMBER_ATTRIBUTE3
,      HEADER_EXT_NUMBER_ATTRIBUTE4
,      HEADER_EXT_NUMBER_ATTRIBUTE5
,      HEADER_EXT_NUMBER_ATTRIBUTE6
,      HEADER_EXT_NUMBER_ATTRIBUTE7
,      HEADER_EXT_NUMBER_ATTRIBUTE8
,      HEADER_EXT_NUMBER_ATTRIBUTE9
,      HEADER_EXT_NUMBER_ATTRIBUTE10
,      HEADER_EXT_DATE_ATTRIBUTE1
,      HEADER_EXT_DATE_ATTRIBUTE2
,      HEADER_EXT_DATE_ATTRIBUTE3
,      HEADER_EXT_DATE_ATTRIBUTE4
,      HEADER_EXT_DATE_ATTRIBUTE5
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      HEADER_EXT_VARCHAR_ATTRIBUTE16
,      HEADER_EXT_VARCHAR_ATTRIBUTE17
,      HEADER_EXT_VARCHAR_ATTRIBUTE18
,      HEADER_EXT_VARCHAR_ATTRIBUTE19
,      HEADER_EXT_VARCHAR_ATTRIBUTE20
,      HEADER_EXT_VARCHAR_ATTRIBUTE21
,      HEADER_EXT_VARCHAR_ATTRIBUTE22
,      HEADER_EXT_VARCHAR_ATTRIBUTE23
,      HEADER_EXT_VARCHAR_ATTRIBUTE24
,      HEADER_EXT_VARCHAR_ATTRIBUTE25
,      HEADER_EXT_VARCHAR_ATTRIBUTE26
,      HEADER_EXT_VARCHAR_ATTRIBUTE27
,      HEADER_EXT_VARCHAR_ATTRIBUTE28
,      HEADER_EXT_VARCHAR_ATTRIBUTE29
,      HEADER_EXT_VARCHAR_ATTRIBUTE30
FROM ZX.ZX_PRVDR_HDR_EXTNS_GT;

Dependencies

[top of page]

ZX.ZX_PRVDR_HDR_EXTNS_GT does not reference any database object

ZX.ZX_PRVDR_HDR_EXTNS_GT is referenced by following:

SchemaAPPS
SynonymZX_PRVDR_HDR_EXTNS_GT