[Home] [Help]
View: OKL_LA_STX_DTLS_UV
Product: | OKL - Lease 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
Name |
CONTRACT_ID |
ASSET_ID |
ASSET_NUMBER |
TAX_CODE |
TAX_RATE |
TAXABLE_AMOUNT |
TAX_AMOUNT |
TBC_CODE |