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

VIEW: APPS.OKL_TAX_TRX_DETAILS_V

Object Details
Object Name: OKL_TAX_TRX_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_TAX_TRX_DETAILS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary Key Column
TXS_ID NUMBER
Yes Foreign key to okl_tax_sources.ID
TAX_DETERMINATION_DATE DATE

No Longer Used
TAX_RATE_ID NUMBER

Tax Rate ID returned by the tax engine
TAX_RATE_CODE VARCHAR2 (150)
Tax Rate Code returned by the tax engine
TAXABLE_AMOUNT NUMBER

No Longer Used
TAX_EXEMPTION_ID NUMBER

Tax Exemption ID returned by the tax engine
TAX_RATE NUMBER

Tax rate returned by the tax engine
TAX_AMOUNT NUMBER

No Longer Used
BILLED_YN VARCHAR2 (1)
Indicator to specify whether stream element has been billed - Used only for tax schedule type of call
TAX_CALL_TYPE_CODE VARCHAR2 (30) Yes Type of Tax Call
PROGRAM_ID NUMBER (15)
Concurrent Manager Column
REQUEST_ID NUMBER

Concurrent Manager Column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager Column
PROGRAM_UPDATE_DATE DATE

Concurrent Manager Column
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield Category Column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield Column
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9)
Column used for locking records during updates
TAX_DETERMINE_DATE DATE

Tax Determination Date
TAXABLE_AMT NUMBER

Taxable Amount
TAX_AMT NUMBER

Tax Amount
TAX_DATE DATE

Tax Date
LINE_AMT NUMBER

Line Amount
INTERNAL_ORGANIZATION_ID NUMBER
Yes Internal Organization Id
APPLICATION_ID NUMBER
Yes Application Id
ENTITY_CODE VARCHAR2 (30) Yes Entity Code
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event Class Code
EVENT_TYPE_CODE VARCHAR2 (30)
Event Type Code
TRX_ID NUMBER
Yes Transaction Id
TRX_LINE_ID NUMBER
Yes Transaction Line Id
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Transaction Level Type
TRX_LINE_NUMBER NUMBER

Transaction Line Number
TAX_LINE_NUMBER NUMBER
Yes Tax Line Number
TAX_REGIME_ID NUMBER (15)
Tax Regime Id
TAX_REGIME_CODE VARCHAR2 (30)
Tax Regime Code
TAX_ID NUMBER (15)
Tax Id
TAX VARCHAR2 (30)
Tax
TAX_STATUS_ID NUMBER (15)
Tax Status Id
TAX_STATUS_CODE VARCHAR2 (30)
Tax Status Code
TAX_APPORTIONMENT_LINE_NUMBER NUMBER

Tax Apportionment Line Number
LEGAL_ENTITY_ID NUMBER

Legal Entity Id
TRX_NUMBER VARCHAR2 (150)
Trx Number
TRX_DATE DATE

Transaction Date
TAX_JURISDICTION_ID NUMBER (15)
Tax Jurisdiction Id
TAX_JURISDICTION_CODE VARCHAR2 (30)
Tax Jurisdiction Code
TAX_TYPE_CODE VARCHAR2 (30)
Tax Type Code
TAX_CURRENCY_CODE VARCHAR2 (15)
Tax Currency Code
TAXABLE_AMT_TAX_CURR NUMBER

Taxable Amt Tax Curr
TRX_CURRENCY_CODE VARCHAR2 (15)
Transaction Currency Code
MINIMUM_ACCOUNTABLE_UNIT NUMBER

Minimum Accountable Unit
PRECISION NUMBER

Precision
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
Query Text

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


SELECT ID
,      TXS_ID
,      TAX_DETERMINATION_DATE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAXABLE_AMOUNT
,      TAX_EXEMPTION_ID
,      TAX_RATE
,      TAX_AMOUNT
,      BILLED_YN
,      TAX_CALL_TYPE_CODE
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      TAX_DETERMINE_DATE
,      TAXABLE_AMT
,      TAX_AMT
,      TAX_DATE
,      LINE_AMT
,      INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_NUMBER
,      TAX_LINE_NUMBER
,      TAX_REGIME_ID
,      TAX_REGIME_CODE
,      TAX_ID
,      TAX
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_APPORTIONMENT_LINE_NUMBER
,      LEGAL_ENTITY_ID
,      TRX_NUMBER
,      TRX_DATE
,      TAX_JURISDICTION_ID
,      TAX_JURISDICTION_CODE
,      TAX_TYPE_CODE
,      TAX_CURRENCY_CODE
,      TAXABLE_AMT_TAX_CURR
,      TRX_CURRENCY_CODE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
FROM APPS.OKL_TAX_TRX_DETAILS_V;

Dependencies

[top of page]

APPS.OKL_TAX_TRX_DETAILS_V references the following:

SchemaAPPS
SynonymOKL_TAX_TRX_DETAILS

APPS.OKL_TAX_TRX_DETAILS_V is not referenced by any database object