APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_OM_OE_SO_TAXES

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 323: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b

319: AND order_line_id = TO_NUMBER(v_interface_line_attribute6);
320:
321: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
322: SELECT DISTINCT 1
323: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
324: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
325: AND A.line_id = b.line_id;
326:
327: CURSOR c_duplicate_tax(cp_tax_id JAI_AR_TRX_TAX_LINES.tax_id%TYPE,

Line 1222: from JAI_OM_OE_SO_TAXES

1218: where line_id = v_interface_line_attribute6;
1219:
1220: Cursor c_om_taxes(v_so_config_line_id Number) is
1221: select *
1222: from JAI_OM_OE_SO_TAXES
1223: where line_id = v_so_config_line_id;
1224:
1225: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1226: Select line_id

Line 2514: -- original logic of getting taxes from JAI_OM_OE_SO_TAXES

2510: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
2511: END IF; -- NVL(v_exist_flag,0) = 1
2512: ELSE -- ELSE OF IF v_interface_line_attribute3 IS NULL ... ...
2513: -- else, the record is not non-shippable item
2514: -- original logic of getting taxes from JAI_OM_OE_SO_TAXES
2515: /*
2516: If records do not exist in JAI_OM_WSH_LINE_TAXES table then control comes to this portion of the code
2517: */
2518:

Line 2610: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control

2606: ;
2607: CLOSE ja_so_lines_info;
2608: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
2609: /*
2610: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
2611: would come here.
2612: Code should return only in case of an RMA i.e return only when a line does not exist in JAI_OM_OE_SO_LINES table
2613: for the given line_id.
2614: */