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.

[Home] [Help]

View: OKL_TAX_SOURCES_V

Product:	OKL - Lease and Finance Management
Description:	This is a simple view on top of okl_tax_sources, which stores the taxable lines for the tax events.
Implementation/DBA Data:	APPS.OKL_TAX_SOURCES_V

View Text

SELECT TXS.ID
, TXS.KHR_ID
, TXS.KLE_ID
, TXS.ASSET_NUMBER
, TXS.TRX_ID
, TXS.TRX_LINE_ID
, TXS.ENTITY_CODE
, TXS.EVENT_CLASS_CODE
, TXS.TRX_LEVEL_TYPE
, TXS.ADJUSTED_DOC_ENTITY_CODE
, TXS.ADJUSTED_DOC_EVENT_CLASS_CODE
, TXS.ADJUSTED_DOC_TRX_ID
, TXS.ADJUSTED_DOC_TRX_LINE_ID
, TXS.ADJUSTED_DOC_TRX_LEVEL_TYPE
, TXS.ADJUSTED_DOC_NUMBER
, TXS.ADJUSTED_DOC_DATE
, TXS.TAX_CALL_TYPE_CODE
, TXS.STY_ID
, TXS.TRX_BUSINESS_CATEGORY
, TXS.TAX_LINE_STATUS_CODE
, TXS.SEL_ID
, TXS.REPORTED_YN
, TXS.PROGRAM_ID
, TXS.REQUEST_ID
, TXS.PROGRAM_APPLICATION_ID
, TXS.PROGRAM_UPDATE_DATE
, TXS.ATTRIBUTE_CATEGORY
, TXS.ATTRIBUTE1
, TXS.ATTRIBUTE2
, TXS.ATTRIBUTE3
, TXS.ATTRIBUTE4
, TXS.ATTRIBUTE5
, TXS.ATTRIBUTE6
, TXS.ATTRIBUTE7
, TXS.ATTRIBUTE8
, TXS.ATTRIBUTE9
, TXS.ATTRIBUTE10
, TXS.ATTRIBUTE11
, TXS.ATTRIBUTE12
, TXS.ATTRIBUTE13
, TXS.ATTRIBUTE14
, TXS.ATTRIBUTE15
, TXS.CREATED_BY
, TXS.CREATION_DATE
, TXS.LAST_UPDATED_BY
, TXS.LAST_UPDATE_DATE
, TXS.LAST_UPDATE_LOGIN
, TXS.OBJECT_VERSION_NUMBER
, TXS.LINE_NAME
, TXS.APPLICATION_ID
, TXS.TAX_REPORTING_FLAG
, TXS.DEFAULT_TAXATION_COUNTRY
, TXS.PRODUCT_CATEGORY
, TXS.USER_DEFINED_FISC_CLASS
, TXS.LINE_INTENDED_USE
, TXS.TAX_CLASSIFICATION_CODE
, TXS.INVENTORY_ITEM_ID
, TXS.BILL_TO_CUST_ACCT_ID
, TXS.ORG_ID
, TXS.LEGAL_ENTITY_ID
, TXS.LINE_AMT
, TXS.ASSESSABLE_VALUE
, TXS.TOTAL_TAX
, TXS.PRODUCT_TYPE
, TXS.PRODUCT_FISC_CLASSIFICATION
, TXS.TRX_DATE
, TXS.PROVNL_TAX_DETERMINATION_DATE
, TXS.TRY_ID
, TXS.SHIP_TO_LOCATION_ID
, TXS.SHIP_TO_PARTY_SITE_ID
, TXS.SHIP_TO_PARTY_ID
, TXS.BILL_TO_PARTY_SITE_ID
, TXS.BILL_TO_LOCATION_ID
, TXS.BILL_TO_PARTY_ID
, TXS.SHIP_TO_CUST_ACCT_SITE_USE_ID
, TXS.BILL_TO_CUST_ACCT_SITE_USE_ID
, TXS.TRX_CURRENCY_CODE
, TXS.CURRENCY_CONVERSION_TYPE
, TXS.CURRENCY_CONVERSION_RATE
, TXS.CURRENCY_CONVERSION_DATE
, TXS.ALC_SERIALIZED_YN
, TXS.ALC_SERIALIZED_TOTAL_TAX
, TXS.ALC_SERIALIZED_TOTAL_LINE_AMT
FROM OKL_TAX_SOURCES TXS

Columns

Name
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