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

TABLE: ZX.ZX_PTNR_NEG_TAX_LINE_GT

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

Temporary Table Details

ZX.ZX_PTNR_NEG_TAX_LINE_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
Columns
Name Datatype Length Mandatory Comments
TAX_LINE_ID NUMBER (15)
Tax line identifier
DOCUMENT_TYPE_ID NUMBER (15)
Event class mapping identifier
APPLICATION_ID NUMBER (15)
Application Identifier of the transaction
ENTITY_CODE VARCHAR2 (30)
Entity code of the application event class for the transaction
EVENT_CLASS_CODE VARCHAR2 (30)
Application event class of the transaction
TRX_ID NUMBER (15)
Primary transaction identifier
TRX_LINE_ID NUMBER (15)
Transaction 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.
COUNTRY_CODE VARCHAR2 (30)
Tax regime code
TAX VARCHAR2 (30)
Tax
SITUS VARCHAR2 (30)
Lookup code for place of supply type
TAX_JURISDICTION VARCHAR2 (30)
Tax jurisdiction code
TAX_CURRENCY_CODE VARCHAR2 (30)
Tax currency code
TAX_CURR_TAX_AMOUNT NUMBER (15)
Tax amount in tax currency
TAX_AMOUNT NUMBER (15)
Tax amount in transaction currency
TAX_RATE_PERCENTAGE NUMBER (15)
Tax rate
TAXABLE_AMOUNT NUMBER (15)
Taxable amount in transaction currency
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (180)
Tax exemption certificate number
EXEMPT_RATE_MODIFIER NUMBER (15)
Percentage of the original tax rate that is exempt
EXEMPT_REASON VARCHAR2 (240)
Tax exemption reason
TAX_ONLY_LINE_FLAG VARCHAR2 (1)
Y or N indicates whether this is a tax only line
INCLUSIVE_TAX_LINE_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is inclusive
USE_TAX_FLAG VARCHAR2 (1)
Y or N indicates whether this is a self-assessed tax line
EBIZ_OVERRIDE_FLAG VARCHAR2 (1)
Y or N indicates whether Oracle eBusiness suite has overridden this tax line
USER_OVERRIDE_FLAG VARCHAR2 (1)
Y or N indicates whether user has overridden this tax line
LAST_MANUAL_ENTRY VARCHAR2 (30)
Column to indicate which column is last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE and TAX_AMOUNT.
MANUALLY_ENTERED_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is manually entered by the user
CANCEL_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is cancelled by the user
DELETE_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is marked for delete by the user
Query Text

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


SELECT TAX_LINE_ID
,      DOCUMENT_TYPE_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LEVEL_TYPE
,      COUNTRY_CODE
,      TAX
,      SITUS
,      TAX_JURISDICTION
,      TAX_CURRENCY_CODE
,      TAX_CURR_TAX_AMOUNT
,      TAX_AMOUNT
,      TAX_RATE_PERCENTAGE
,      TAXABLE_AMOUNT
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_RATE_MODIFIER
,      EXEMPT_REASON
,      TAX_ONLY_LINE_FLAG
,      INCLUSIVE_TAX_LINE_FLAG
,      USE_TAX_FLAG
,      EBIZ_OVERRIDE_FLAG
,      USER_OVERRIDE_FLAG
,      LAST_MANUAL_ENTRY
,      MANUALLY_ENTERED_FLAG
,      CANCEL_FLAG
,      DELETE_FLAG
FROM ZX.ZX_PTNR_NEG_TAX_LINE_GT;

Dependencies

[top of page]

ZX.ZX_PTNR_NEG_TAX_LINE_GT does not reference any database object

ZX.ZX_PTNR_NEG_TAX_LINE_GT is referenced by following:

SchemaAPPS
SynonymZX_PTNR_NEG_TAX_LINE_GT