APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_CMN_TAXES_ALL

Line 72: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c

68: A.func_tax_amount,
69: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
70: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
71: c.tax_type
72: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
73: WHERE A.line_id = b.line_id
74: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
75: AND A.tax_id = c.tax_id
76: and c.tax_type <> lc_modvat_tax

Line 125: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

121: WHERE line_id = v_interface_line_attribute6 );
122:
123: CURSOR c_cust_trx_tax_line_amt IS
124: SELECT nvl(SUM(a.tax_amount),0)
125: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
126: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
127: AND a.tax_id = b.tax_id
128: AND nvl(b.inclusive_tax_flag, 'N') = 'N';
129:

Line 193: , JAI_CMN_TAXES_ALL jcta

189: , jowla.vat_invoice_no
190: , jowla.vat_invoice_date
191: FROM JAI_OM_WSH_LINE_TAXES jowlt
192: , JAI_OM_WSH_LINES_ALL jowla
193: , JAI_CMN_TAXES_ALL jcta
194: WHERE jowlt.delivery_detail_id IS NULL
195: AND jowlt.order_line_id = jowla.order_line_id
196: AND jowlt.tax_id= jcta.tax_id
197: AND jcta.tax_type <> 'Modvat Recovery'

Line 234: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D

230: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
231: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
232: b.vat_invoice_no,b.vat_invoice_date
233: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
234: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
235: WHERE A.delivery_detail_id = b.delivery_detail_id
236: AND A.tax_id=c.tax_id
237: and c.tax_type <> 'Modvat Recovery'
238: AND b.delivery_id = D.delivery_id

Line 528: , JAI_CMN_TAXES_ALL jtc

524: is
525: select count(1)
526: from jai_regime_tax_types_v jrttv
527: , JAI_AR_TRX_TAX_LINES jrctt
528: , JAI_CMN_TAXES_ALL jtc
529: where jtc.tax_id = jrctt.tax_id
530: and jtc.tax_type = jrttv.tax_type
531: and regime_code = cp_regime_code
532: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;

Line 979: , JAI_CMN_TAXES_ALL jtc

975: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
976: select max(tax_line_no)
977: into ln_base_line_no
978: from JAI_AR_TRX_TAX_LINES jrctt
979: , JAI_CMN_TAXES_ALL jtc
980: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
981: and jrctt.tax_id = jtc.tax_id
982: and jtc.tax_type = jai_constants.tax_type_tcs;
983: /*

Line 1250: FROM JAI_CMN_TAXES_ALL

1246: A.order_line_id = TO_NUMBER(v_ato_line_id);
1247:
1248: CURSOR c_get_tax_info(p_tax_id Number) is
1249: SELECT tax_type
1250: FROM JAI_CMN_TAXES_ALL
1251: WHERE tax_id = p_tax_id;
1252:
1253: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1254: v_tax_amount Number; --File.Sql.35 Cbabu :=0;

Line 1253: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;

1249: SELECT tax_type
1250: FROM JAI_CMN_TAXES_ALL
1251: WHERE tax_id = p_tax_id;
1252:
1253: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1254: v_tax_amount Number; --File.Sql.35 Cbabu :=0;
1255:
1256: ln_legal_entity_id NUMBER ;
1257: ln_hdr_exist_chk number;

Line 3069: JAI_CMN_TAXES_ALL t

3065: FROM JAI_AR_SUP_TAXES A,
3066: JAI_AR_SUP_LINES b,
3067: ra_customer_trx_all C,
3068: ra_cust_trx_types_all D,
3069: JAI_CMN_TAXES_ALL t
3070: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
3071: AND A.sup_inv_type = b.sup_inv_type
3072: AND b.customer_Trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)
3073: AND pr_new.customer_trx_id = c.customer_trx_id

Line 3094: JAI_CMN_TAXES_ALL t

3090: JAI_AR_SUP_LINES b,
3091: JAI_AR_SUP_HDRS_ALL c,
3092: ra_customer_trx_all D,
3093: ra_cust_trx_types_all e,
3094: JAI_CMN_TAXES_ALL t
3095: WHERE pr_new.customer_trx_id = D.customer_trx_id
3096: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)
3097: AND c.customer_trx_id = b.customer_trx_id
3098: AND b.customer_trx_line_id = A.link_to_cust_trx_line_id

Line 4882: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4878: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
4879: A.func_tax_amount,
4880: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4881: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4882: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4883: WHERE A.rma_line_id = v_interface_line_attribute7
4884: AND A.tax_id = b.tax_id
4885: and b.tax_type <> lc_modvat_tax
4886: ORDER BY tax_line_no;

Line 5053: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

5049: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
5050: A.func_tax_amount,
5051: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
5052: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
5053: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
5054: WHERE A.rma_line_id = TO_NUMBER(v_interface_line_attribute7)
5055: AND A.tax_id = b.tax_id
5056: and b.tax_type <> lc_modvat_tax
5057: ORDER BY tax_line_no;

Line 5104: , JAI_CMN_TAXES_ALL jtc

5100: is
5101: select count(1)
5102: from jai_regime_tax_types_v jrttv
5103: , JAI_AR_TRX_TAX_LINES jrctt
5104: , JAI_CMN_TAXES_ALL jtc
5105: where jtc.tax_id = jrctt.tax_id
5106: and jtc.tax_type = jrttv.tax_type
5107: and regime_code = cp_regime_code
5108: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;

Line 5550: , JAI_CMN_TAXES_ALL jtc

5546: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
5547: select max(tax_line_no)
5548: into ln_base_line_no
5549: from JAI_AR_TRX_TAX_LINES jrctt
5550: , JAI_CMN_TAXES_ALL jtc
5551: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
5552: and jrctt.tax_id = jtc.tax_id
5553: and jtc.tax_type = jai_constants.tax_type_tcs;
5554: /*