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

Line 165: , jai_cmn_taxes_all tax

161: SELECT
162: nvl(sum(so_tax.tax_amount),0)
163: FROM
164: JAI_OM_OE_SO_TAXES so_tax
165: , jai_cmn_taxes_all tax
166: WHERE
167: line_id = pr_new.source_line_id AND
168: header_id = pr_new.source_header_id
169: AND so_tax.tax_id = tax.tax_id

Line 589: JAI_CMN_TAXES_ALL b

585: A.Tax_Amount,
586: A.Base_Tax_Amount,
587: A.Func_Tax_Amount
588: FROM JAI_OM_OE_SO_TAXES A,
589: JAI_CMN_TAXES_ALL b
590: WHERE Line_id = v_source_line_id
591: AND A.Tax_Id = b.Tax_Id
592: ORDER BY A.Tax_Line_No;
593:

Line 603: JAI_CMN_TAXES_ALL b

599:
600: CURSOR Get_Tot_Tax_Amount_Cur IS
601: SELECT SUM(A.Tax_Amount)
602: FROM JAI_OM_WSH_LINE_TAXES A,
603: JAI_CMN_TAXES_ALL b
604: WHERE A.Delivery_Detail_Id = v_delivery_detail_id
605: AND b.Tax_Id = A.Tax_Id
606: AND b.Tax_Type <> 'TDS';
607:

Line 648: JAI_CMN_TAXES_ALL b

644: SELECT
645: nvl(sum(a.func_tax_amount),0)
646: FROM
647: JAI_CMN_MATCH_TAXES a,
648: JAI_CMN_TAXES_ALL b
649: WHERE
650: a.tax_id = b.tax_id AND
651: b.tax_type = p_tax_type AND
652: A.ref_line_id = v_delivery_detail_id AND

Line 754: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b

750: AND location_id = p_location_id;
751:
752: CURSOR Get_Tax_Lines_Details_Cur1 IS
753: SELECT A.Tax_Rate, NVL(b.Rounding_Factor,0) Rounding_Factor
754: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
755: WHERE Line_id = v_source_line_id
756: AND A.Tax_Id = b.Tax_Id
757: AND b.tax_type = 'Modvat Recovery'
758: ORDER BY A.Tax_Line_No;

Line 774: JAI_CMN_TAXES_ALL jtc

770:
771: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
772: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
773: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
774: JAI_CMN_TAXES_ALL jtc
775: WHERE jtc.tax_id = jsptl.tax_id
776: AND delivery_detail_id in
777: (SELECT delivery_detail_id
778: FROM JAI_OM_WSH_LINES_ALL

Line 788: JAI_CMN_TAXES_ALL jtc

784:
785: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
786: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
787: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
788: JAI_CMN_TAXES_ALL jtc
789: WHERE jtc.tax_id = jsptl.tax_id
790: AND delivery_detail_id in
791: (SELECT delivery_detail_id
792: FROM JAI_OM_WSH_LINES_ALL

Line 812: JAI_CMN_TAXES_ALL jtc

808: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
809: IS
810: SELECT 1
811: FROM JAI_OM_WSH_LINE_TAXES jsptl,
812: JAI_CMN_TAXES_ALL jtc
813: , jai_regime_tax_types_v tax_types
814: WHERE jsptl.delivery_detail_id = cp_del_det_id
815: AND jtc.tax_id = jsptl.tax_id
816: AND jtc.tax_type = tax_types.tax_type

Line 842: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )

838: /*
839: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
840: */
841: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
842: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
843: IS
844: SELECT 1
845: FROM JAI_OM_WSH_LINE_TAXES jsptl,
846: JAI_CMN_TAXES_ALL jtc

Line 846: JAI_CMN_TAXES_ALL jtc

842: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
843: IS
844: SELECT 1
845: FROM JAI_OM_WSH_LINE_TAXES jsptl,
846: JAI_CMN_TAXES_ALL jtc
847: WHERE jsptl.delivery_detail_id = cp_del_det_id
848: AND jtc.tax_id = jsptl.tax_id
849: AND jtc.tax_type = cp_tax_type ;
850:

Line 875: , JAI_CMN_TAXES_ALL JTC

871: IS
872: SELECT COUNT(1)
873: FROM JAI_REGIME_TAX_TYPES_V JRTTV
874: , JAI_OM_WSH_LINE_TAXES JSPT
875: , JAI_CMN_TAXES_ALL JTC
876: WHERE JTC.TAX_ID = JSPT.TAX_ID
877: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
878: AND REGIME_CODE = CP_REGIME_CODE
879: AND JSPT.DELIVERY_DETAIL_ID = CP_DELIVERY_DETAIL_ID;

Line 1344: , JAI_CMN_TAXES_ALL jtc

1340: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
1341: select max(tax_line_no)
1342: into ln_base_line_no
1343: from JAI_OM_WSH_LINE_TAXES jsptl
1344: , JAI_CMN_TAXES_ALL jtc
1345: where jsptl.delivery_detail_id = v_delivery_detail_id
1346: and jsptl.tax_id = jtc.tax_id
1347: and jtc.tax_type = jai_constants.tax_type_tcs;
1348:

Line 2078: FROM jai_om_wsh_line_taxes a, jai_cmn_taxes_all b

2074: WHERE currency_code = cp_curr_code;
2075:
2076: CURSOR c_inclusive_flag(CP_DDID IN NUMBER) IS
2077: SELECT count(*)
2078: FROM jai_om_wsh_line_taxes a, jai_cmn_taxes_all b
2079: where a.delivery_Detail_id = cp_ddid
2080: and a.tax_id = b.tax_id
2081: and upper(b.tax_type) like '%EXCISE%'
2082: AND B.INCLUSIVE_TAX_FLAG = 'Y';

Line 3035: , JAI_CMN_TAXES_ALL JTC

3031: IS
3032: SELECT COUNT(1)
3033: FROM JAI_REGIME_TAX_TYPES_V JRTTV
3034: , JAI_OM_WSH_LINE_TAXES JSPT
3035: , JAI_CMN_TAXES_ALL JTC
3036: WHERE JTC.TAX_ID = JSPT.TAX_ID
3037: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
3038: AND REGIME_CODE = CP_REGIME_CODE
3039: AND JSPT.DELIVERY_DETAIL_ID = CP_DELIVERY_DETAIL_ID;

Line 3187: JAI_CMN_TAXES_ALL jtc ,

3183: jtc.tax_type
3184: FROM
3185: JAI_OM_WSH_LINES_ALL jspl ,
3186: JAI_OM_WSH_LINE_TAXES jsptl,
3187: JAI_CMN_TAXES_ALL jtc ,
3188: jai_regime_tax_types_v jrttv
3189: WHERE
3190: jspl.delivery_detail_id = jsptl.delivery_detail_id
3191: AND jspl.delivery_id = v_delivery_id