eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_AR_TAX_LINES_UV

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'