APPS.GMI_RESERVATION_UTIL dependencies on OE_ORDER_LINES_ALL

Line 317: FROM oe_order_lines_all

313: /* ====== cursors ============================================================================ */
314: CURSOR c_sales_order (om_line_id IN NUMBER) IS
315: SELECT inventory_item_id,
316: order_quantity_uom
317: FROM oe_order_lines_all
318: WHERE line_id = om_line_id;
319:
320:
321: BEGIN

Line 535: From oe_order_lines_all

531:
532: -- BEGIN - Bug 3216096
533: Cursor get_line_info (l_line_id IN number) IS
534: Select SCHEDULE_SHIP_DATE
535: From oe_order_lines_all
536: Where line_id = l_line_id;
537:
538: l_schedule_ship_date DATE;
539: -- END - Bug 3216096

Line 763: FROM oe_order_lines_all oel

759: SELECT oel.sold_to_org_id
760: , oel.ship_to_org_id
761: , oel.line_number + (oel.shipment_number / 10)
762: , oel.org_id
763: FROM oe_order_lines_all oel
764: WHERE oel.line_id = oe_line_id;
765:
766: CURSOR c_user IS
767: SELECT user_id,

Line 1244: FROM oe_order_lines_all

1240: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Org_from_SO_Line';
1241:
1242: CURSOR c_org (oe_line_id IN NUMBER) IS
1243: SELECT ship_from_org_id
1244: FROM oe_order_lines_all
1245: WHERE line_id = oe_line_id;
1246:
1247: BEGIN
1248: /* ======================================================================= */

Line 1429: FROM oe_order_lines_all

1425: ordered_quantity2 * (-1),
1426: ordered_quantity_uom2,
1427: ship_from_org_id, -- BUG 3538734
1428: inventory_item_id
1429: FROM oe_order_lines_all
1430: WHERE line_id = om_line_id;
1431:
1432:
1433: BEGIN

Line 2341: FROM oe_order_lines_all sol

2337: , sol.schedule_ship_date
2338: , sol.line_number + (sol.shipment_number / 10)
2339: , sol.inventory_item_id
2340: , sol.ship_to_org_id
2341: FROM oe_order_lines_all sol
2342: , oe_order_headers_all soh
2343: , oe_transaction_types_tl tt
2344: , mtl_sales_orders mtl
2345: WHERE mtl.segment1 = to_char(soh.order_number)

Line 3179: From oe_order_lines_all

3175: ,NVL(ordered_quantity,0)
3176: ,NVL(ordered_quantity2,0)
3177: ,ship_from_org_id
3178: ,inventory_item_id
3179: From oe_order_lines_all
3180: Where line_id = l_line_rec.line_id;
3181:
3182: Cursor get_whse_code IS
3183: Select whse_code

Line 3770: oe_order_lines_all sol,

3766: AND w.orgn_code = co.orgn_code;
3767: Cursor get_doc_id IS
3768: Select mtl.sales_order_id
3769: From mtl_sales_orders mtl,
3770: oe_order_lines_all sol,
3771: oe_order_headers_all soh,
3772: oe_transaction_types_tl tt
3773: Where sol.line_id = p_line_id
3774: AND mtl.segment1 = to_char(soh.order_number)

Line 3792: From oe_order_lines_all

3788: -- BEGIN - Bug 3216096.
3789: -- Bug 3558787 get line Number as well
3790: Cursor get_line_info (l_line_id IN number) IS
3791: Select SCHEDULE_SHIP_DATE, line_number+(shipment_number / 10)
3792: From oe_order_lines_all
3793: Where line_id = l_line_id;
3794:
3795: l_schedule_ship_date DATE;
3796: l_line_number NUMBER;

Line 3912: oe_order_lines_all sol,

3908: Cursor get_doc_id IS
3909: Select mtl.sales_order_id
3910: , sol.inventory_item_id
3911: From mtl_sales_orders mtl,
3912: oe_order_lines_all sol,
3913: oe_order_headers_all soh,
3914: oe_transaction_types_tl tt
3915: Where sol.line_id = p_line_id
3916: AND mtl.segment1 = to_char(soh.order_number)

Line 3977: From oe_order_lines_all

3973:
3974: -- BEGIN Bug 3558787 get line Number
3975: Cursor get_line_info (l_line_id IN number) IS
3976: Select SCHEDULE_SHIP_DATE, line_number+(shipment_number / 10)
3977: From oe_order_lines_all
3978: Where line_id = l_line_id;
3979:
3980: l_schedule_ship_date DATE;
3981: l_line_number NUMBER;

Line 4671: FROM oe_order_lines_all

4667:
4668: /* Begin bug 2871929 */
4669: Cursor c_order_line_info IS
4670: SELECT inventory_item_id, Ship_from_org_id
4671: FROM oe_order_lines_all
4672: WHERE line_id = p_old_source_line_id;
4673: /* End bug 2871929 */
4674:
4675: BEGIN