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_OM_WSH_PKG dependencies on JAI_CMN_TAXES_ALL

Line 242: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b

238: AND b.order_type_id = p_order_type_id ;
239:
240: CURSOR for_modvat_tax_rate(p_delivery_detail_id NUMBER) IS
241: SELECT A.tax_rate, b.rounding_factor
242: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b
243: WHERE A.tax_id = b.tax_id
244: AND A.delivery_detail_id = p_delivery_detail_id
245: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /* --'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
246:

Line 477: JAI_CMN_TAXES_ALL JTC

473: ln_excise_tax_cnt number;
474: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS
475: SELECT count(1)
476: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
477: JAI_CMN_TAXES_ALL JTC
478: WHERE JSPTL.TAX_ID = JTC.TAX_ID
479: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
480: AND upper(jtc.tax_type) like '%EXCISE%';
481:

Line 490: JAI_CMN_TAXES_ALL JTC

486: */
487: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
488: SELECT SUM(NVL(JSPTL.tax_rate,0)) , count(1) --NVL(sum(JSPTL.tax_rate),0)
489: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
490: JAI_CMN_TAXES_ALL JTC
491: WHERE JSPTL.TAX_ID = JTC.TAX_ID
492: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
493: AND UPPER(JTC.TAX_TYPE) = 'EXCISE';
494:

Line 495: ln_total_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

491: WHERE JSPTL.TAX_ID = JTC.TAX_ID
492: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
493: AND UPPER(JTC.TAX_TYPE) = 'EXCISE';
494:
495: ln_total_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
496: ln_number_of_Taxes NUMBER;
497: /*
498: || Added by Ramananda
499: || End of bug#4543424

Line 505: JAI_CMN_TAXES_ALL jtc

501:
502: CURSOR c_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
503: SELECT sum(jsptl.func_tax_amount) tax_amount
504: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
505: JAI_CMN_TAXES_ALL jtc
506: WHERE jtc.tax_id = jsptl.tax_id
507: AND delivery_detail_id in
508: (SELECT delivery_detail_id
509: FROM JAI_OM_WSH_LINES_ALL

Line 519: JAI_CMN_TAXES_ALL jtc

515: /*Cursor added by ssawant for bug 5989740 */
516: CURSOR c_sh_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
517: SELECT sum(jsptl.func_tax_amount) tax_amount
518: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
519: JAI_CMN_TAXES_ALL jtc
520: WHERE jtc.tax_id = jsptl.tax_id
521: AND delivery_detail_id in
522: (SELECT delivery_detail_id
523: FROM JAI_OM_WSH_LINES_ALL

Line 550: jai_cmn_taxes_all jtc

546: sum(func_tax_amount) cess_amount
547: FROM
548: jai_om_wsh_lines_all jspl ,
549: jai_om_wsh_line_taxes jsptl,
550: jai_cmn_taxes_all jtc
551: WHERE
552: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
553: jsptl.tax_id = jtc.tax_id AND
554: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND

Line 568: JAI_CMN_TAXES_ALL jtc

564: sum(func_tax_amount) cess_amount
565: FROM
566: JAI_OM_WSH_LINES_ALL jspl,
567: JAI_OM_WSH_LINE_TAXES jsptl,
568: JAI_CMN_TAXES_ALL jtc
569: WHERE
570: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
571: jsptl.tax_id = jtc.tax_id AND
572: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,