APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 1124: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b

1120: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1121:
1122: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
1123: SELECT DISTINCT 1
1124: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
1125: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
1126: AND A.line_id = b.line_id;
1127:
1128: -- Date 23/02/2006 by sacsethi for bug 5228046

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

1132: A.func_tax_amount,
1133: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
1134: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
1135: c.tax_type
1136: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
1137: WHERE A.line_id = b.line_id
1138: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
1139: AND A.tax_id = c.tax_id
1140: and c.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/

Line 1446: from JAI_OM_OE_SO_TAXES

1442: where line_id = v_interface_line_attribute6;
1443:
1444: Cursor c_om_taxes(v_so_config_line_id Number) is
1445: select *
1446: from JAI_OM_OE_SO_TAXES
1447: where line_id = v_so_config_line_id;
1448:
1449: Cursor c_get_config_line_id(v_ato_line_id Varchar2, cp_item_code oe_order_lines_all.item_type_code%type) is
1450: Select line_id

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

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

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

4219:
4220: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
4221: /*
4222: Update done by aiyer for the bug #3328871
4223: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
4224: would come here.
4225: 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
4226: for the given line_id.
4227: */