[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_PRVDR_LINE_EXTNS_GT |
|---|---|
| Object Type: | TABLE |
| Owner: | ZX |
| FND Design Data: |  ZX.ZX_PRVDR_LINE_EXTNS_GT
|
| Subobject Name: | |
| Status: | VALID |
ZX.ZX_PRVDR_LINE_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.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ZX_PRVDR_LINE_EXTNS_GT_U1 | NORMAL | UNIQUE |
|
 APPLICATION_ID
ENTITY_CODE
EVENT_CLASS_CODE
TRX_ID
TRX_LINE_ID
TRX_LEVEL_TYPE
PROVIDER_ID
TAX_REGIME_CODE
|
| 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 | |
| TRX_LINE_ID | NUMBER | Yes | Transaction line 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 |
| LINE_EXT_VARCHAR_ATTRIBUTE1 | VARCHAR2 | (150) | Line Level user extensible attribute1 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE2 | VARCHAR2 | (300) | Line Level user extensible attribute2 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE3 | VARCHAR2 | (150) | Line Level user extensible attribute3 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE4 | VARCHAR2 | (150) | Line Level user extensible attribute4 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE5 | VARCHAR2 | (150) | Line Level user extensible attribute5 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE6 | VARCHAR2 | (150) | Line Level user extensible attribute6 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE7 | VARCHAR2 | (150) | Line Level user extensible attribute7 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE8 | VARCHAR2 | (150) | Line Level user extensible attribute8 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE9 | VARCHAR2 | (150) | Line Level user extensible attribute9 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE10 | VARCHAR2 | (150) | Line Level user extensible attribute10 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE11 | VARCHAR2 | (150) | Line Level user extensible attribute11 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE12 | VARCHAR2 | (150) | Line Level user extensible attribute12 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE13 | VARCHAR2 | (150) | Line Level user extensible attribute13 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE14 | VARCHAR2 | (150) | Line Level user extensible attribute14 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE15 | VARCHAR2 | (150) | Line Level user extensible attribute15 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE16 | VARCHAR2 | (150) | Line Level user extensible attribute16 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE17 | VARCHAR2 | (150) | Line Level user extensible attribute17 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE18 | VARCHAR2 | (150) | Line Level user extensible attribute18 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE19 | VARCHAR2 | (150) | Line Level user extensible attribute19 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE20 | VARCHAR2 | (150) | Line Level user extensible attribute20 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE21 | VARCHAR2 | (150) | Line Level user extensible attribute21 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE22 | VARCHAR2 | (150) | Line Level user extensible attribute22 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE23 | VARCHAR2 | (150) | Line Level user extensible attribute23 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE24 | VARCHAR2 | (150) | Line Level user extensible attribute24 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE25 | VARCHAR2 | (150) | Line Level user extensible attribute25 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE26 | VARCHAR2 | (150) | Line Level user extensible attribute26 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE27 | VARCHAR2 | (150) | Line Level user extensible attribute27 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE28 | VARCHAR2 | (150) | Line Level user extensible attribute28 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE29 | VARCHAR2 | (150) | Line Level user extensible attribute29 of type character used by third party service provider | |
| LINE_EXT_VARCHAR_ATTRIBUTE30 | VARCHAR2 | (150) | Line Level user extensible attribute30 of type character used by third party service provider | |
| LINE_EXT_NUMBER_ATTRIBUTE1 | NUMBER | Line Level user extensible attribute1 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE2 | NUMBER | Line Level user extensible attribute2 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE3 | NUMBER | Line Level user extensible attribute3 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE4 | NUMBER | Line Level user extensible attribute4 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE5 | NUMBER | Line Level user extensible attribute5 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE6 | NUMBER | Line Level user extensible attribute6 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE7 | NUMBER | Line Level user extensible attribute7 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE8 | NUMBER | Line Level user extensible attribute8 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE9 | NUMBER | Line Level user extensible attribute9 of type number used by third party service provider | ||
| LINE_EXT_NUMBER_ATTRIBUTE10 | NUMBER | Line Level user extensible attribute10 of type number used by third party service provider | ||
| LINE_EXT_DATE_ATTRIBUTE1 | DATE | Line Level user extensible attribute1 of type date used by third party service provider | ||
| LINE_EXT_DATE_ATTRIBUTE2 | DATE | Line Level user extensible attribute2 of type date used by third party service provider | ||
| LINE_EXT_DATE_ATTRIBUTE3 | DATE | Line Level user extensible attribute3 of type date used by third party service provider | ||
| LINE_EXT_DATE_ATTRIBUTE4 | DATE | Line Level user extensible attribute4 of type date used by third party service provider | ||
| LINE_EXT_DATE_ATTRIBUTE5 | DATE | Line 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 | ||
| 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. |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_CLASS_CODE
, APPLICATION_ID
, ENTITY_CODE
, TRX_ID
, TRX_LINE_ID
, PROVIDER_ID
, TAX_REGIME_CODE
, LINE_EXT_VARCHAR_ATTRIBUTE1
, LINE_EXT_VARCHAR_ATTRIBUTE2
, LINE_EXT_VARCHAR_ATTRIBUTE3
, LINE_EXT_VARCHAR_ATTRIBUTE4
, LINE_EXT_VARCHAR_ATTRIBUTE5
, LINE_EXT_VARCHAR_ATTRIBUTE6
, LINE_EXT_VARCHAR_ATTRIBUTE7
, LINE_EXT_VARCHAR_ATTRIBUTE8
, LINE_EXT_VARCHAR_ATTRIBUTE9
, LINE_EXT_VARCHAR_ATTRIBUTE10
, LINE_EXT_VARCHAR_ATTRIBUTE11
, LINE_EXT_VARCHAR_ATTRIBUTE12
, LINE_EXT_VARCHAR_ATTRIBUTE13
, LINE_EXT_VARCHAR_ATTRIBUTE14
, LINE_EXT_VARCHAR_ATTRIBUTE15
, LINE_EXT_VARCHAR_ATTRIBUTE16
, LINE_EXT_VARCHAR_ATTRIBUTE17
, LINE_EXT_VARCHAR_ATTRIBUTE18
, LINE_EXT_VARCHAR_ATTRIBUTE19
, LINE_EXT_VARCHAR_ATTRIBUTE20
, LINE_EXT_VARCHAR_ATTRIBUTE21
, LINE_EXT_VARCHAR_ATTRIBUTE22
, LINE_EXT_VARCHAR_ATTRIBUTE23
, LINE_EXT_VARCHAR_ATTRIBUTE24
, LINE_EXT_VARCHAR_ATTRIBUTE25
, LINE_EXT_VARCHAR_ATTRIBUTE26
, LINE_EXT_VARCHAR_ATTRIBUTE27
, LINE_EXT_VARCHAR_ATTRIBUTE28
, LINE_EXT_VARCHAR_ATTRIBUTE29
, LINE_EXT_VARCHAR_ATTRIBUTE30
, LINE_EXT_NUMBER_ATTRIBUTE1
, LINE_EXT_NUMBER_ATTRIBUTE2
, LINE_EXT_NUMBER_ATTRIBUTE3
, LINE_EXT_NUMBER_ATTRIBUTE4
, LINE_EXT_NUMBER_ATTRIBUTE5
, LINE_EXT_NUMBER_ATTRIBUTE6
, LINE_EXT_NUMBER_ATTRIBUTE7
, LINE_EXT_NUMBER_ATTRIBUTE8
, LINE_EXT_NUMBER_ATTRIBUTE9
, LINE_EXT_NUMBER_ATTRIBUTE10
, LINE_EXT_DATE_ATTRIBUTE1
, LINE_EXT_DATE_ATTRIBUTE2
, LINE_EXT_DATE_ATTRIBUTE3
, LINE_EXT_DATE_ATTRIBUTE4
, LINE_EXT_DATE_ATTRIBUTE5
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRX_LEVEL_TYPE
FROM ZX.ZX_PRVDR_LINE_EXTNS_GT;
ZX.ZX_PRVDR_LINE_EXTNS_GT does not reference any database object
ZX.ZX_PRVDR_LINE_EXTNS_GT is referenced by following:
APPS
ZX_PRVDR_LINE_EXTNS_GT
|
|
|
|