APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on OE_ORDER_LINES_ALL

Line 335: from oe_order_lines_all

331: following code is to correct the existing lc_matching order line to new split line id
332: */
333: cursor c_order_line is
334: select split_from_line_id --, split_by
335: from oe_order_lines_all
336: where line_id = pr_new.source_line_id;
337:
338: cursor c_lc_mtch_dlry_line is
339: select order_line_id

Line 515: oe_order_lines_all oel

511: SELECT
512: oel.ato_line_id
513: FROM
514: oe_order_headers_all oeh,
515: oe_order_lines_all oel
516: WHERE
517: oeh.header_id = pr_new.source_header_id
518: AND oeh.header_id = oel.header_id
519: AND item_type_code = 'CONFIG' ;

Line 521: CURSOR c_model_item_id(cp_ato_line_id oe_order_lines_all.line_id%TYPE) IS

517: oeh.header_id = pr_new.source_header_id
518: AND oeh.header_id = oel.header_id
519: AND item_type_code = 'CONFIG' ;
520:
521: CURSOR c_model_item_id(cp_ato_line_id oe_order_lines_all.line_id%TYPE) IS
522: SELECT
523: oel.inventory_item_id
524: FROM
525: oe_order_lines_all oel

Line 525: oe_order_lines_all oel

521: CURSOR c_model_item_id(cp_ato_line_id oe_order_lines_all.line_id%TYPE) IS
522: SELECT
523: oel.inventory_item_id
524: FROM
525: oe_order_lines_all oel
526: WHERE
527: oel.line_id = cp_ato_line_id
528: AND item_type_code = 'MODEL' ;
529:

Line 1443: oe_order_lines_all b

1439: conversion_rate ,
1440: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
1441: FROM
1442: oe_order_headers_all a ,
1443: oe_order_lines_all b
1444: WHERE
1445: a.header_id = b.header_id AND
1446: b.line_id = v_source_line_id AND
1447: a.header_id = v_source_header_id ;

Line 1510: FROM Oe_order_lines_all

1506: WHERE Sub_Inventory_Name = v_subinventory
1507: AND organization_id = v_organization_id;
1508: CURSOR get_ship_to_org_id_cur( p_line_id NUMBER) IS
1509: SELECT ship_to_org_id, invoice_to_org_id --added invoice_to_org_id for bug#8731696
1510: FROM Oe_order_lines_all
1511: WHERE line_id = p_line_id;
1512:
1513: --added the cursor for bug#8731696
1514: Cursor cur_get_bill_to_cust_id (cp_site_use_id IN NUMBER)

Line 1564: FROM oe_order_lines_all

1560:
1561: --2001/10/03 Anuradha Parthasarathy
1562: CURSOR uom_code IS
1563: SELECT order_quantity_uom
1564: FROM oe_order_lines_all
1565: WHERE line_id = v_source_line_id;
1566: v_order_quantity_uom VARCHAR2(3);
1567: v_conversion_rate NUMBER; --File.Sql.35 Cbabu := 0;
1568: --2001/12/20

Line 1707: from oe_order_lines_all

1703: following code is to correct the existing lc_matching order line to new split line id
1704: */
1705: cursor c_order_line is
1706: select split_from_line_id --, split_by
1707: from oe_order_lines_all
1708: where line_id = pr_new.source_line_id;
1709:
1710: cursor c_lc_mtch_dlry_line is
1711: select order_line_id

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

1994:
1995:
1996: 17.24/09/2003 Aiyer Bug #3139718 File Version : 616.4
1997:
1998: Added the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
1999: conversion_date from oe_order_headers_all.
2000: As a sales order shipment date can be different from its creation date, hence the conversion rate
2001: applicable on the date of shipment should be considerd for all processing rather than the creation
2002: date of the Sales order.