[Home] [Help]
218:
219: --end
220: /*added by rchandan for bug #6030615*/
221: /*
222: ||Fetch the information from jai_mtl_trxs and jai_cmn_document_taxes
223: */
224: CURSOR cur_get_mtltxns
225: IS
226: SELECT
232: jmt.vat_assessable_value,
233: jmt.creation_date,
234: jcdt.tax_amt
235: FROM
236: jai_mtl_trxs jmt,
237: jai_cmn_document_taxes jcdt,
238: jai_cmn_taxes_all jtc,
239: jai_rgm_registrations jrg,
240: jai_rgm_definitions jrr