VIEW: APPS.OKL_LA_STX_DTLS_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'