APPS.GMI_RESERVATION_UTIL dependencies on OE_ORDER_LINES_ALL

Line 321: FROM oe_order_lines_all

317: /* ====== cursors ============================================================================ */
318: CURSOR c_sales_order (om_line_id IN NUMBER) IS
319: SELECT inventory_item_id,
320: order_quantity_uom
321: FROM oe_order_lines_all
322: WHERE line_id = om_line_id;
323:
324:
325: BEGIN

Line 539: From oe_order_lines_all

535:
536: -- BEGIN - Bug 3216096
537: Cursor get_line_info (l_line_id IN number) IS
538: Select SCHEDULE_SHIP_DATE
539: From oe_order_lines_all
540: Where line_id = l_line_id;
541:
542: l_schedule_ship_date DATE;
543: -- END - Bug 3216096

Line 767: FROM oe_order_lines_all oel

763: SELECT oel.sold_to_org_id
764: , oel.ship_to_org_id
765: , oel.line_number + (oel.shipment_number / 10)
766: , oel.org_id
767: FROM oe_order_lines_all oel
768: WHERE oel.line_id = oe_line_id;
769:
770: CURSOR c_user IS
771: SELECT user_id,

Line 1248: FROM oe_order_lines_all

1244: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Org_from_SO_Line';
1245:
1246: CURSOR c_org (oe_line_id IN NUMBER) IS
1247: SELECT ship_from_org_id
1248: FROM oe_order_lines_all
1249: WHERE line_id = oe_line_id;
1250:
1251: BEGIN
1252: /* ======================================================================= */

Line 1433: FROM oe_order_lines_all

1429: ordered_quantity2 * (-1),
1430: ordered_quantity_uom2,
1431: ship_from_org_id, -- BUG 3538734
1432: inventory_item_id
1433: FROM oe_order_lines_all
1434: WHERE line_id = om_line_id;
1435:
1436:
1437: BEGIN

Line 2353: FROM oe_order_lines_all sol

2349: , sol.schedule_ship_date
2350: , sol.line_number + (sol.shipment_number / 10)
2351: , sol.inventory_item_id
2352: , sol.ship_to_org_id
2353: FROM oe_order_lines_all sol
2354: , oe_order_headers_all soh
2355: , oe_transaction_types_tl tt
2356: , mtl_sales_orders mtl
2357: WHERE mtl.segment1 = to_char(soh.order_number)

Line 3191: From oe_order_lines_all

3187: ,NVL(ordered_quantity,0)
3188: ,NVL(ordered_quantity2,0)
3189: ,ship_from_org_id
3190: ,inventory_item_id
3191: From oe_order_lines_all
3192: Where line_id = l_line_rec.line_id;
3193:
3194: Cursor get_whse_code IS
3195: Select whse_code

Line 3782: oe_order_lines_all sol,

3778: AND w.orgn_code = co.orgn_code;
3779: Cursor get_doc_id IS
3780: Select mtl.sales_order_id
3781: From mtl_sales_orders mtl,
3782: oe_order_lines_all sol,
3783: oe_order_headers_all soh,
3784: oe_transaction_types_tl tt
3785: Where sol.line_id = p_line_id
3786: AND mtl.segment1 = to_char(soh.order_number)

Line 3804: From oe_order_lines_all

3800: -- BEGIN - Bug 3216096.
3801: -- Bug 3558787 get line Number as well
3802: Cursor get_line_info (l_line_id IN number) IS
3803: Select SCHEDULE_SHIP_DATE, line_number+(shipment_number / 10)
3804: From oe_order_lines_all
3805: Where line_id = l_line_id;
3806:
3807: l_schedule_ship_date DATE;
3808: l_line_number NUMBER;

Line 3924: oe_order_lines_all sol,

3920: Cursor get_doc_id IS
3921: Select mtl.sales_order_id
3922: , sol.inventory_item_id
3923: From mtl_sales_orders mtl,
3924: oe_order_lines_all sol,
3925: oe_order_headers_all soh,
3926: oe_transaction_types_tl tt
3927: Where sol.line_id = p_line_id
3928: AND mtl.segment1 = to_char(soh.order_number)

Line 3989: From oe_order_lines_all

3985:
3986: -- BEGIN Bug 3558787 get line Number
3987: Cursor get_line_info (l_line_id IN number) IS
3988: Select SCHEDULE_SHIP_DATE, line_number+(shipment_number / 10)
3989: From oe_order_lines_all
3990: Where line_id = l_line_id;
3991:
3992: l_schedule_ship_date DATE;
3993: l_line_number NUMBER;

Line 4683: FROM oe_order_lines_all

4679:
4680: /* Begin bug 2871929 */
4681: Cursor c_order_line_info IS
4682: SELECT inventory_item_id, Ship_from_org_id
4683: FROM oe_order_lines_all
4684: WHERE line_id = p_old_source_line_id;
4685: /* End bug 2871929 */
4686:
4687: BEGIN