APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on OE_ORDER_LINES_ALL

Line 138: from oe_order_lines_all

134: v_lc_shipped_qty NUMBER;
135:
136: cursor c_order_line is
137: select split_from_line_id
138: from oe_order_lines_all
139: where line_id = pr_new.source_line_id;
140:
141: cursor c_lc_mtch_dlry_line is
142: select order_line_id

Line 553: oe_order_lines_all b

549: conversion_rate ,
550: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
551: FROM
552: oe_order_headers_all a ,
553: oe_order_lines_all b
554: WHERE
555: a.header_id = b.header_id AND
556: b.line_id = v_source_line_id AND
557: a.header_id = v_source_header_id ;

Line 623: FROM Oe_order_lines_all

619: AND organization_id = v_organization_id;
620:
621: CURSOR get_ship_to_org_id_cur( p_line_id NUMBER) IS
622: SELECT ship_to_org_id, invoice_to_org_id
623: FROM Oe_order_lines_all
624: WHERE line_id = p_line_id;
625:
626: Cursor cur_get_bill_to_cust_id (cp_site_use_id IN NUMBER)
627: IS

Line 668: FROM oe_order_lines_all

664: v_item_trading_flag VARCHAR2(1);
665:
666: CURSOR uom_code IS
667: SELECT order_quantity_uom
668: FROM oe_order_lines_all
669: WHERE line_id = v_source_line_id;
670: v_order_quantity_uom VARCHAR2(3);
671: v_conversion_rate NUMBER;
672:

Line 2939: oe_order_lines_all b

2935: conversion_rate ,
2936: nvl(b.actual_shipment_date,sysdate) actual_shipment_date
2937: FROM
2938: oe_order_headers_all a ,
2939: oe_order_lines_all b
2940: WHERE
2941: a.header_id = b.header_id AND
2942: b.line_id = v_source_line_id AND
2943: a.header_id = v_source_header_id ;