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.

[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 247: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b

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

Line 487: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS

483:
484: /* added by bgowrava for forward porting - bug# 5554420 */
485: lv_exc_inv_gen_for_dlry_flag varchar2(1);
486: ln_excise_tax_cnt number;
487: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS
488: SELECT count(1)
489: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
490: JAI_CMN_TAXES_ALL JTC
491: WHERE JSPTL.TAX_ID = JTC.TAX_ID

Line 489: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,

485: lv_exc_inv_gen_for_dlry_flag varchar2(1);
486: ln_excise_tax_cnt number;
487: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS
488: SELECT count(1)
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) like '%EXCISE%';

Line 500: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS

496: /*
497: || Added by Ramananda
498: || Start of bug#4543424
499: */
500: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
501: SELECT SUM(NVL(JSPTL.tax_rate,0)) , count(1) --NVL(sum(JSPTL.tax_rate),0)
502: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
503: JAI_CMN_TAXES_ALL JTC
504: WHERE JSPTL.TAX_ID = JTC.TAX_ID

Line 502: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,

498: || Start of bug#4543424
499: */
500: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
501: SELECT SUM(NVL(JSPTL.tax_rate,0)) , count(1) --NVL(sum(JSPTL.tax_rate),0)
502: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
503: JAI_CMN_TAXES_ALL JTC
504: WHERE JSPTL.TAX_ID = JTC.TAX_ID
505: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
506: AND UPPER(JTC.TAX_TYPE) = 'EXCISE';

Line 516: CURSOR c_excise_base_tax_amt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS

512: || End of bug#4543424
513: */
514:
515: /*Start additions by mmurtuza for bug 15971482*/
516: CURSOR c_excise_base_tax_amt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
517: SELECT sum(NVL(JSPTL.base_tax_amount,0) / JOWLA.quantity)
518: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
519: JAI_CMN_TAXES_ALL JTC,
520: JAI_OM_WSH_LINES_ALL JOWLA

Line 518: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,

514:
515: /*Start additions by mmurtuza for bug 15971482*/
516: CURSOR c_excise_base_tax_amt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
517: SELECT sum(NVL(JSPTL.base_tax_amount,0) / JOWLA.quantity)
518: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
519: JAI_CMN_TAXES_ALL JTC,
520: JAI_OM_WSH_LINES_ALL JOWLA
521: WHERE JSPTL.TAX_ID = JTC.TAX_ID
522: AND JSPTL.delivery_detail_id = cp_delivery_detail_id

Line 532: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

528: /*End additions by mmurtuza for bug 15971482*/
529:
530: CURSOR c_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
531: SELECT sum(jsptl.func_tax_amount) tax_amount
532: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
533: JAI_CMN_TAXES_ALL jtc
534: WHERE jtc.tax_id = jsptl.tax_id
535: AND delivery_detail_id in
536: (SELECT delivery_detail_id

Line 546: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

542:
543: /*Cursor added by ssawant for bug 5989740 */
544: CURSOR c_sh_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
545: SELECT sum(jsptl.func_tax_amount) tax_amount
546: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
547: JAI_CMN_TAXES_ALL jtc
548: WHERE jtc.tax_id = jsptl.tax_id
549: AND delivery_detail_id in
550: (SELECT delivery_detail_id

Line 577: jai_om_wsh_line_taxes jsptl,

573: SELECT
574: sum(func_tax_amount) cess_amount
575: FROM
576: jai_om_wsh_lines_all jspl ,
577: jai_om_wsh_line_taxes jsptl,
578: jai_cmn_taxes_all jtc
579: WHERE
580: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
581: jsptl.tax_id = jtc.tax_id AND

Line 595: JAI_OM_WSH_LINE_TAXES jsptl,

591: SELECT
592: sum(func_tax_amount) cess_amount
593: FROM
594: JAI_OM_WSH_LINES_ALL jspl,
595: JAI_OM_WSH_LINE_TAXES jsptl,
596: JAI_CMN_TAXES_ALL jtc
597: WHERE
598: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
599: jsptl.tax_id = jtc.tax_id AND