APPS.GMI_RESERVATION_UTIL dependencies on MTL_SALES_ORDERS

Line 76: | for retrieval of mtl_sales_orders |

72: | Aug 2004 Plowe BUG#3770264 - Added code in Procedures |
73: | create_transaction_for_rcv, set_pick_lots and |
74: | create_dflt_lot_from_scratch to |
75: | retrieve correct lang |
76: | for retrieval of mtl_sales_orders |
77: +=========================================================================+
78: API Name : GMI_Reservation_Util
79: Type : Private Package Body
80: Function : This package contains Private Utilities procedures used to

Line 2344: , mtl_sales_orders mtl

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)
2346: AND mtl.segment2 = tt.name
2347: AND mtl.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
2348: -- AND tt.language = userenv('LANG') -- OPM bug 3770264

Line 3769: From mtl_sales_orders mtl,

3765: Where w.whse_code = p_whse_code
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

Line 3911: From mtl_sales_orders mtl,

3907: AND w.orgn_code = co.orgn_code;
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