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 194: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES

190: AND jrg.registration_type = 'TAX_TYPES' ;
191:
192:
193: /*
194: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES
195: */
196: /* Bug 5739005. Added by vkantamn
197: * Included source, source_trx_type and source_table_name in the inner
198: * query for performance issue reported.

Line 220: JAI_OM_WSH_LINE_TAXES jsptl ,

216: jsptl.creation_date ,
217: jtc.tax_type
218: FROM
219: JAI_OM_WSH_LINES_ALL jspl ,
220: JAI_OM_WSH_LINE_TAXES jsptl ,
221: JAI_CMN_TAXES_ALL jtc ,
222: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
223: SELECT jrttv1.tax_type tax_type
224: FROM jai_regime_tax_types_v jrttv1

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

283: AND jpdi.draft_invoice_id = p_delivery_id
284: GROUP BY jpdi.draft_invoice_id, jcdt.tax_type, jcdt.tax_id, jcdt.tax_rate;
285: /* end bug# 6012570 (5876390) */
286: /*
287: || Fetch the invoice information from ja_in_ra_customer_trx_tax_lines so_picking_lines and JAI_OM_WSH_LINE_TAXES
288: */
289: /* Bug 5739005. Added by vkantamn
290: * Included source, source_trx_type and source_table_name in the inner
291: * query for performance issue reported.