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_SOURCES_T

Object Details

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

This table is used during upgrades to store taxable lines.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TAX_SOURCES_T_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_TAX_SOURCES_T_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID TRX_LEVEL_TYPE TRX_LINE_ID
OKL_TAX_SOURCES_T_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary Key column
KHR_ID	NUMBER			Contract ID
KLE_ID	NUMBER			Contract Line ID
ASSET_NUMBER	VARCHAR2	(150)		No Longer Used
TRX_ID	NUMBER			Source Transaction ID
TRX_LINE_ID	NUMBER			Source Transaction Line ID
ENTITY_CODE	VARCHAR2	(30)		Source Transaction Table
EVENT_CLASS_CODE	VARCHAR2	(30)		Event Class used for tax calculation
TRX_LEVEL_TYPE	VARCHAR2	(30)		Transaction Level Type - header/line
ADJUSTED_DOC_ENTITY_CODE	VARCHAR2	(30)		Source Transaction table for the original transaction such as Credit Memo
ADJUSTED_DOC_EVENT_CLASS_CODE	VARCHAR2	(30)		Event Class Code for original transaction
ADJUSTED_DOC_TRX_ID	NUMBER			Tansaction Id for original transaction
ADJUSTED_DOC_TRX_LINE_ID	NUMBER			Tansaction Line Id for original transaction
ADJUSTED_DOC_TRX_LEVEL_TYPE	VARCHAR2	(30)		Transaction Level Type for original transaction
ADJUSTED_DOC_NUMBER	VARCHAR2	(150)		Document Number of the original transaction
ADJUSTED_DOC_DATE	DATE			Document Date of the original transaction
TAX_CALL_TYPE_CODE	VARCHAR2	(30)		Type of Tax Call
STY_ID	NUMBER			Stream Type ID
TRX_BUSINESS_CATEGORY	VARCHAR2	(240)		Transaction Business Category
TAX_LINE_STATUS_CODE	VARCHAR2	(30)		Status of Tax line
SEL_ID	NUMBER			Stream element ID
REPORTED_YN	VARCHAR2	(1)		No Longer Used
PROGRAM_ID	NUMBER	(15)		Concurernt Manager Column
REQUEST_ID	NUMBER			Concurernt Manager Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurernt Manager Column
PROGRAM_UPDATE_DATE	DATE			Concurernt 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
LINE_NAME	VARCHAR2	(150)		Column used to store asset number / Service Line / Fee Line
APPLICATION_ID	NUMBER			Application Identifier
TAX_REPORTING_FLAG	VARCHAR2	(1)		Whether tax is reported
DEFAULT_TAXATION_COUNTRY	VARCHAR2	(2)		Default Taxation Country
PRODUCT_CATEGORY	VARCHAR2	(240)		Product Category
USER_DEFINED_FISC_CLASS	VARCHAR2	(240)		User Defined Fiscal Classification
LINE_INTENDED_USE	VARCHAR2	(240)		Line Intended Use
TAX_CLASSIFICATION_CODE	VARCHAR2	(50)		Tax Classification Code
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
BILL_TO_CUST_ACCT_ID	NUMBER			Bill To Cust Acct Id
ORG_ID	NUMBER			Org Id
LEGAL_ENTITY_ID	NUMBER			Legal Entity Id
LINE_AMT	NUMBER			Line Amount
ASSESSABLE_VALUE	NUMBER			Assessable Value
TOTAL_TAX	NUMBER			Total Tax
PRODUCT_TYPE	VARCHAR2	(240)		Product Type
PRODUCT_FISC_CLASSIFICATION	VARCHAR2	(240)		Product Fiscal Classification
TRX_DATE	DATE			Transaction Date
PROVNL_TAX_DETERMINATION_DATE	DATE			Provisional Tax Determination Date
TRY_ID	NUMBER			Transaction Type ID
SHIP_TO_LOCATION_ID	NUMBER			Ship To Location ID
SHIP_TO_PARTY_SITE_ID	NUMBER			Ship To Party Site Id
SHIP_TO_PARTY_ID	NUMBER			Ship To Party Id
BILL_TO_PARTY_SITE_ID	NUMBER			Bill To Party Site Id
BILL_TO_LOCATION_ID	NUMBER			Bill To Location Id
BILL_TO_PARTY_ID	NUMBER			Bill To Party Id
SHIP_TO_CUST_ACCT_SITE_USE_ID	NUMBER			Ship To Cust Acct Site Use Id
BILL_TO_CUST_ACCT_SITE_USE_ID	NUMBER			Bill To Cust Acct Site Use Id
TRX_CURRENCY_CODE	VARCHAR2	(15)		Trx Currency Code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency Conversion Type
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
CURRENCY_CONVERSION_DATE	DATE			Currency Conversion Date
ALC_SERIALIZED_YN	VARCHAR2	(1)		Asset Location Change tax call for serialized asset
ALC_SERIALIZED_TOTAL_TAX	NUMBER			Total tax for all serial numbers for an asset
ALC_SERIALIZED_TOTAL_LINE_AMT	NUMBER			Total taxable amount for all serial numbers for an asset
UPGRADED_YN	VARCHAR2	(1)		This column tells whetherrow is upgraded or not
STS_CODE	VARCHAR2	(30)		Contract Status

Query Text

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


SELECT ID
,      KHR_ID
,      KLE_ID
,      ASSET_NUMBER
,      TRX_ID
,      TRX_LINE_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_LEVEL_TYPE
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      ADJUSTED_DOC_TRX_LINE_ID
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      TAX_CALL_TYPE_CODE
,      STY_ID
,      TRX_BUSINESS_CATEGORY
,      TAX_LINE_STATUS_CODE
,      SEL_ID
,      REPORTED_YN
,      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
,      LINE_NAME
,      APPLICATION_ID
,      TAX_REPORTING_FLAG
,      DEFAULT_TAXATION_COUNTRY
,      PRODUCT_CATEGORY
,      USER_DEFINED_FISC_CLASS
,      LINE_INTENDED_USE
,      TAX_CLASSIFICATION_CODE
,      INVENTORY_ITEM_ID
,      BILL_TO_CUST_ACCT_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
,      LINE_AMT
,      ASSESSABLE_VALUE
,      TOTAL_TAX
,      PRODUCT_TYPE
,      PRODUCT_FISC_CLASSIFICATION
,      TRX_DATE
,      PROVNL_TAX_DETERMINATION_DATE
,      TRY_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_PARTY_ID
,      BILL_TO_PARTY_SITE_ID
,      BILL_TO_LOCATION_ID
,      BILL_TO_PARTY_ID
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      TRX_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ALC_SERIALIZED_YN
,      ALC_SERIALIZED_TOTAL_TAX
,      ALC_SERIALIZED_TOTAL_LINE_AMT
,      UPGRADED_YN
,      STS_CODE
FROM OKL.OKL_TAX_SOURCES_T;

Dependencies

[top of page]

OKL.OKL_TAX_SOURCES_T does not reference any database object

OKL.OKL_TAX_SOURCES_T is referenced by following:

OKL: OKL_TAX_SOURCES_T#