View: OKL_CS_AR_TAX_LINES_UV

Product:	OKL - Lease and Finance Management
Description:	This view is used by Lease Center screen to display tax lines for a tax schedule.
Implementation/DBA Data:	APPS.OKL_CS_AR_TAX_LINES_UV

View Text

SELECT RTRH.CUSTOMER_TRX_ID
, RTRL.CUSTOMER_TRX_LINE_ID
, RTRH.TRX_DATE TAX_DATE
, ATX.TAX_CODE
, ATX.TAX_RATE
, NVL(RTRL1.TAXABLE_AMOUNT
, RTRL.EXTENDED_AMOUNT) TAXABLE_AMOUNT
, RTRL1.EXTENDED_AMOUNT TAX_AMOUNT
, RTRH.INVOICE_CURRENCY_CODE CURRENCY_CODE
, RTRL.ATTRIBUTE12 TBC
FROM RA_CUSTOMER_TRX RTRH
, RA_CUSTOMER_TRX_LINES_ALL RTRL
, RA_CUSTOMER_TRX_LINES_ALL RTRL1
, AR_VAT_TAX_ALL ATX
WHERE RTRH.CUSTOMER_TRX_ID = RTRL.CUSTOMER_TRX_ID
AND RTRL1.VAT_TAX_ID = ATX.VAT_TAX_ID
AND RTRL.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
AND RTRL1.LINK_TO_CUST_TRX_LINE_ID = RTRL.CUSTOMER_TRX_LINE_ID
AND RTRL1.LINE_TYPE = 'TAX'

Columns