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_OM_WSH_LINE_TAXES

Line 255: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES

251: AND jrg.registration_type = 'TAX_TYPES' ;
252:
253:
254: /*
255: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES
256: */
257: /* Bug 5739005. Added by vkantamn
258: * Included source, source_trx_type and source_table_name in the inner
259: * query for performance issue reported.

Line 281: JAI_OM_WSH_LINE_TAXES jsptl ,

277: jsptl.creation_date ,
278: jtc.tax_type
279: FROM
280: JAI_OM_WSH_LINES_ALL jspl ,
281: JAI_OM_WSH_LINE_TAXES jsptl ,
282: JAI_CMN_TAXES_ALL jtc ,
283: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
284: SELECT jrttv1.tax_type tax_type
285: FROM jai_regime_tax_types_v jrttv1

Line 387: || Fetch the invoice information from ja_in_ra_customer_trx_tax_lines so_picking_lines and JAI_OM_WSH_LINE_TAXES

383: AND jpdi.draft_invoice_id = p_delivery_id
384: GROUP BY jpdi.draft_invoice_id, jcdt.tax_type, jcdt.tax_id, jcdt.tax_rate;
385: /* end bug# 6012570 (5876390) */
386: /*
387: || Fetch the invoice information from ja_in_ra_customer_trx_tax_lines so_picking_lines and JAI_OM_WSH_LINE_TAXES
388: */
389: /* Bug 5739005. Added by vkantamn
390: * Included source, source_trx_type and source_table_name in the inner
391: * query for performance issue reported.