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.

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_AR_TRX_LINES

Line 412: JAI_AR_TRX_LINES jctl ,

408: jtc.tax_type ,
409: jcttl.tax_rate ,
410: jcttl.tax_line_no -- Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011
411: FROM
412: JAI_AR_TRX_LINES jctl ,
413: JAI_AR_TRX_TAX_LINES jcttl ,
414: JAI_CMN_TAXES_ALL jtc ,
415: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
416: SELECT jrttv1.tax_type tax_type

Line 457: FROM jai_ar_trx_lines lines

453: --Added by Zhiwei for Open Interface ER bug#11683927 on 10-Feb-2011, begin
454: --------------------------------------------------------------------------------
455: CURSOR get_external_flag_cur IS
456: SELECT COUNT(1)
457: FROM jai_ar_trx_lines lines
458: , jai_interface_lines_all intfs
459: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
460: AND lines.customer_trx_id = p_customer_trx_id
461: AND lines.interface_flag = 'Y'