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

TABLE: ZX.ZX_TRX_PRE_PROC_OPTIONS_GT

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

Temporary Table Details

ZX.ZX_TRX_PRE_PROC_OPTIONS_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_TRX_PRE_PROC_OPTIONS_GT_U1 NORMAL UNIQUE Tablespace ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnTRX_ID
Columns
Name Datatype Length Mandatory Comments
INTERNAL_ORGANIZATION_ID NUMBER (15) Yes Internal organization identifier of the transaction
PROD_FAMILY_GRP_CODE VARCHAR2 (30) Yes Lookup code to indicate the product family of this event class. Possible values are P2P and O2C
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
TAX_REGIME_CODE VARCHAR2 (30) Yes Tax regime code
PARTNER_PROCESSING_FLAG VARCHAR2 (1)
Indicates the purpose for which tax service provider is called. Possible values are C (Calculate), F (First Time Calculation), S (Synchronize)
TAX_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.
EVNT_CLS_MAPPING_ID NUMBER (15) Yes Event class mapping identifier
TAX_EVENT_TYPE_CODE VARCHAR2 (30) Yes Tax event type code of the transaction
EVENT_ID NUMBER (15)
Unique identifier of a specific event that triggers call to a tax processing API. This value will be stamped on all transaction lines passed as input during that API call.
QUOTE_FLAG VARCHAR2 (1)
Y or N indicates whether transaction is passed as quote to the tax service provider
RECORD_FLAG VARCHAR2 (1)
Y or N indicates whether tax lines for this event class are recorded in the tax repository
RECORD_FOR_PARTNERS_FLAG VARCHAR2 (1)
Y or N indicates whether this event class is recorded in repositories of external service providers
APPLICATION_SHORT_NAME VARCHAR2 (50)
Application short name
LEGAL_ENTITY_NUMBER VARCHAR2 (30)
Legal Entity number
ESTABLISHMENT_NUMBER VARCHAR2 (30)
Establishment number
ALLOW_TAX_CALCULATION_FLAG VARCHAR2 (1)
Y or N indicates whether tax provider service should calculate tax for the transaction passed to it.
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
Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      PROD_FAMILY_GRP_CODE
,      EVENT_CLASS_CODE
,      APPLICATION_ID
,      ENTITY_CODE
,      TRX_ID
,      TAX_REGIME_CODE
,      PARTNER_PROCESSING_FLAG
,      TAX_PROVIDER_ID
,      EVNT_CLS_MAPPING_ID
,      TAX_EVENT_TYPE_CODE
,      EVENT_ID
,      QUOTE_FLAG
,      RECORD_FLAG
,      RECORD_FOR_PARTNERS_FLAG
,      APPLICATION_SHORT_NAME
,      LEGAL_ENTITY_NUMBER
,      ESTABLISHMENT_NUMBER
,      ALLOW_TAX_CALCULATION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ZX.ZX_TRX_PRE_PROC_OPTIONS_GT;

Dependencies

[top of page]

ZX.ZX_TRX_PRE_PROC_OPTIONS_GT does not reference any database object

ZX.ZX_TRX_PRE_PROC_OPTIONS_GT is referenced by following:

SchemaAPPS
SynonymZX_TRX_PRE_PROC_OPTIONS_GT