View: OKL_LA_STX_DTLS_UV

Product:	OKL - Leasing and Finance Management
Description:	Sales Tax Details
Implementation/DBA Data:	APPS.OKL_LA_STX_DTLS_UV

View Text

SELECT TXS.KHR_ID CONTRACT_ID
, TXS.KLE_ID ASSET_ID
, TXS.ASSET_NUMBER ASSET_NUMBER
, TXL.TAX_RATE_CODE TAX_CODE
, TXL.TAX_RATE TAX_RATE
, TXL.TAXABLE_AMOUNT TAXABLE_AMOUNT
, TXL.TAX_AMOUNT TAX_AMOUNT
, TXS.TRX_BUSINESS_CATEGORY TBC_CODE
FROM OKL_TAX_SOURCES TXS
, OKL_TAX_TRX_DETAILS TXL
WHERE TXS.ID = TXL.TXS_ID
AND TXS.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'
AND TXS.TAX_LINE_STATUS_CODE = 'ACTIVE'

Columns