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

Line 127: , jai_cmn_taxes_all tax

123: SELECT
124: nvl(sum(so_tax.tax_amount),0)
125: FROM
126: JAI_OM_OE_SO_TAXES so_tax
127: , jai_cmn_taxes_all tax
128: WHERE
129: line_id = p_rec_new.line_id AND
130: header_id = p_rec_new.header_id
131: AND so_tax.tax_id = tax.tax_id

Line 168: JAI_CMN_TAXES_ALL jtc ,

164: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE)
165: IS
166: SELECT 1
167: FROM JAI_OM_OE_SO_TAXES jstl ,
168: JAI_CMN_TAXES_ALL jtc ,
169: jai_regime_tax_types_v tax_types
170: WHERE jstl.line_id = cp_line_id
171: AND jstl.header_id = cp_header_id
172: AND jtc.tax_id = jstl.tax_id

Line 182: JAI_CMN_TAXES_ALL jtc

178: )
179: IS
180: SELECT 1
181: FROM JAI_OM_OE_SO_TAXES jstl ,
182: JAI_CMN_TAXES_ALL jtc
183: WHERE jstl.line_id = cp_line_id
184: AND jstl.header_id = cp_header_id
185: AND jtc.tax_id = jstl.tax_id
186: AND jtc.tax_type in ( jai_constants.tax_type_excise,

Line 1160: JAI_CMN_TAXES_ALL jtc

1156: SUM(ptl.func_tax_amount) func_tax_amount,
1157: MIN(ptl.delivery_detail_id) delivery_detail_id
1158: FROM JAI_OM_WSH_LINES_ALL pl,
1159: JAI_OM_WSH_LINE_TAXES ptl,
1160: JAI_CMN_TAXES_ALL jtc
1161: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1162: AND pl.order_header_id = p_source_document_id
1163: AND pl.order_line_id = p_source_document_line_id
1164: AND jtc.tax_id = ptl.tax_id

Line 1659: JAI_CMN_TAXES_ALL jtc

1655: precedence_8,
1656: precedence_9,
1657: precedence_10
1658: FROM JAI_OM_WSH_LINE_TAXES sptl,
1659: JAI_CMN_TAXES_ALL jtc
1660: WHERE order_line_id =
1661: pr_order_line.reference_line_id
1662: AND jtc.tax_id = sptl.tax_id) LOOP
1663: lv_check_vat_type_exists := NULL;

Line 1910: JAI_CMN_TAXES_ALL jtc

1906: SUM(ptl.func_tax_amount) func_tax_amount,
1907: MIN(ptl.delivery_detail_id) delivery_detail_id
1908: FROM JAI_OM_WSH_LINES_ALL pl,
1909: JAI_OM_WSH_LINE_TAXES ptl,
1910: JAI_CMN_TAXES_ALL jtc
1911: WHERE ptl.delivery_detail_id = pl.delivery_detail_id
1912: AND pl.order_header_id = p_source_document_id
1913: AND pl.order_line_id = p_source_document_line_id
1914: AND jtc.tax_id = ptl.tax_id

Line 2493: JAI_CMN_TAXES_ALL jtc

2489: precedence_8,
2490: precedence_9,
2491: precedence_10
2492: FROM JAI_OM_WSH_LINE_TAXES sptl,
2493: JAI_CMN_TAXES_ALL jtc
2494: WHERE order_line_id =
2495: pr_order_line.reference_line_id
2496: AND jtc.tax_id = sptl.tax_id) LOOP
2497: lv_check_vat_type_exists := NULL;

Line 2741: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b

2737: WHERE line_id = p_line_id;
2738:
2739: CURSOR return_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
2740: SELECT SUM(A.tax_amount)
2741: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
2742: WHERE a.rma_line_id = p_line_id
2743: AND b.tax_id = A.tax_id
2744: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
2745: AND NVL(b.inclusive_tax_flag, 'N') = 'N';

Line 2749: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b

2745: AND NVL(b.inclusive_tax_flag, 'N') = 'N';
2746:
2747: CURSOR order_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
2748: SELECT SUM(A.tax_amount)
2749: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
2750: WHERE A.Header_ID = p_header_id
2751: AND A.line_id = p_line_id
2752: AND b.tax_id = A.tax_id
2753: AND b.tax_type <> jai_constants.tax_type_tds

Line 3431: from JAI_CMN_TAXES_ALL

3427: AND line_id = p_line_id;
3428:
3429: cursor c_fetch_rounding_factor(p_tax_id number) is
3430: select nvl(rounding_factor, 0), nvl(adhoc_flag, 'N')
3431: from JAI_CMN_TAXES_ALL
3432: where tax_id = p_tax_id;
3433:
3434: CURSOR order_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
3435: SELECT SUM(A.tax_amount)

Line 3436: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b

3432: where tax_id = p_tax_id;
3433:
3434: CURSOR order_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
3435: SELECT SUM(A.tax_amount)
3436: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
3437: WHERE A.Header_ID = p_header_id
3438: AND A.line_id = p_line_id
3439: AND b.tax_id = A.tax_id
3440: AND b.tax_type <> jai_constants.tax_type_tds

Line 3451: v_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;

3447: l_lc_flag JAI_OM_OE_SO_LINES.LC_FLAG%TYPE;
3448: v_old_quantity NUMBER;
3449: v_so_tax_lines_count NUMBER;
3450: v_tax_line_count NUMBER;
3451: v_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
3452: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type;
3453: v_new_tax_amount NUMBER;
3454: v_new_base_tax_amount NUMBER;
3455: v_header_tax_amount number;

Line 3452: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type;

3448: v_old_quantity NUMBER;
3449: v_so_tax_lines_count NUMBER;
3450: v_tax_line_count NUMBER;
3451: v_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
3452: v_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type;
3453: v_new_tax_amount NUMBER;
3454: v_new_base_tax_amount NUMBER;
3455: v_header_tax_amount number;
3456: v_new_func_tax_amount NUMBER;