APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 1055: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b

1051: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1052:
1053: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
1054: SELECT DISTINCT 1
1055: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
1056: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
1057: AND A.line_id = b.line_id;
1058:
1059: -- Date 23/02/2006 by sacsethi for bug 5228046

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

1063: A.func_tax_amount,
1064: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
1065: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
1066: c.tax_type
1067: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
1068: WHERE A.line_id = b.line_id
1069: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
1070: AND A.tax_id = c.tax_id
1071: and c.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/

Line 1361: from JAI_OM_OE_SO_TAXES

1357: where line_id = v_interface_line_attribute6;
1358:
1359: Cursor c_om_taxes(v_so_config_line_id Number) is
1360: select *
1361: from JAI_OM_OE_SO_TAXES
1362: where line_id = v_so_config_line_id;
1363:
1364: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1365: Select line_id

Line 2519: any taxes in JAI_OM_OE_SO_TAXES table then check whether a line exists in JAI_OM_OE_SO_LINES table only.

2515:
2516: Fix Details:-
2517: Added a if clause in the code. Placed the return statement between the if clause.
2518: So the modified functionality is that is a line does not have any taxes in shpiing tables and also does not have
2519: any taxes in JAI_OM_OE_SO_TAXES table then check whether a line exists in JAI_OM_OE_SO_LINES table only.
2520: IF yes then do not retunr, if not found then return.
2521: Also added a nvl clause in the cursor c_cust_trx_tax_line_amt. so that a value of zero would be returned
2522: even if the where clause failed to fetch a record.
2523: This would take care that tax amount would be inserted as 0 and total amount would also be computed properly

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

3913:
3914: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
3915: /*
3916: Update done by aiyer for the bug #3328871
3917: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
3918: would come here.
3919: 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
3920: for the given line_id.
3921: */