eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKL.OKL_TAX_TRX_DETAILS

Object Details

Object Name:	OKL_TAX_TRX_DETAILS
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TAX_TRX_DETAILS
Subobject Name:
Status:	VALID

This table is used to store the tax lines returned by the Global Tax Engine, for each taxable line resulting from a taxable event in OLM. okl_tax_sources is the parent table for okl_tax_trx_details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TAX_TRX_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_TAX_TRX_DETAILS_U2	NORMAL	UNIQUE	APPS_TS_NOLOGGING	APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID TRX_LINE_ID TRX_LEVEL_TYPE TAX_REGIME_CODE TAX TAX_APPORTIONMENT_LINE_NUMBER
OKL_TAX_TRX_DETAILS_U3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TXS_ID

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 or not. Used only for Tax schedule type of calls.
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 Determine 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 OKL.OKL_TAX_TRX_DETAILS;

Dependencies

[top of page]

OKL.OKL_TAX_TRX_DETAILS does not reference any database object

OKL.OKL_TAX_TRX_DETAILS is referenced by following:

OKL: OKL_TAX_TRX_DETAILS#