APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on OE_ORDER_LINES_ALL

Line 310: from oe_order_lines_all

306: following code is to correct the existing lc_matching order line to new split line id
307: */
308: cursor c_order_line is
309: select split_from_line_id --, split_by
310: from oe_order_lines_all
311: where line_id = pr_new.source_line_id;
312:
313: cursor c_lc_mtch_dlry_line is
314: select order_line_id

Line 1211: oe_order_lines_all b

1207: conversion_rate ,
1208: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
1209: FROM
1210: oe_order_headers_all a ,
1211: oe_order_lines_all b
1212: WHERE
1213: a.header_id = b.header_id AND
1214: b.line_id = v_source_line_id AND
1215: a.header_id = v_source_header_id ;

Line 1277: FROM Oe_order_lines_all

1273: WHERE Sub_Inventory_Name = v_subinventory
1274: AND organization_id = v_organization_id;
1275: CURSOR get_ship_to_org_id_cur( p_line_id NUMBER) IS
1276: SELECT ship_to_org_id
1277: FROM Oe_order_lines_all
1278: WHERE line_id = p_line_id;
1279:
1280: CURSOR rg23d_amount_cur(p_tax_id NUMBER) IS
1281: SELECT nvl(sum(tax_amount),0) ,

Line 1324: FROM oe_order_lines_all

1320:
1321: --2001/10/03 Anuradha Parthasarathy
1322: CURSOR uom_code IS
1323: SELECT order_quantity_uom
1324: FROM oe_order_lines_all
1325: WHERE line_id = v_source_line_id;
1326: v_order_quantity_uom VARCHAR2(3);
1327: v_conversion_rate NUMBER; --File.Sql.35 Cbabu := 0;
1328: --2001/12/20

Line 1467: from oe_order_lines_all

1463: following code is to correct the existing lc_matching order line to new split line id
1464: */
1465: cursor c_order_line is
1466: select split_from_line_id --, split_by
1467: from oe_order_lines_all
1468: where line_id = pr_new.source_line_id;
1469:
1470: cursor c_lc_mtch_dlry_line is
1471: select order_line_id

Line 1758: Added the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the

1754:
1755:
1756: 17.24/09/2003 Aiyer Bug #3139718 File Version : 616.4
1757:
1758: Added the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
1759: conversion_date from oe_order_headers_all.
1760: As a sales order shipment date can be different from its creation date, hence the conversion rate
1761: applicable on the date of shipment should be considerd for all processing rather than the creation
1762: date of the Sales order.