[Home] [Help]
View: OKL_AR_TAX_LINES_ALL_UV
Product: | OKL - Lease and Finance Management |
Description: | This view is used by Lease Center to get the tax lines from AR, for a tax schedule. |
Implementation/DBA Data: |
APPS.OKL_AR_TAX_LINES_ALL_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_ALL 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
Name |
CUSTOMER_TRX_ID |
CUSTOMER_TRX_LINE_ID |
TAX_DATE |
TAX_CODE |
TAX_RATE |
TAXABLE_AMOUNT |
TAX_AMOUNT |
CURRENCY_CODE |
TBC |