APPS.GMI_RESERVATION_UTIL dependencies on MTL_SALES_ORDERS

Line 76: | 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: | retrieval of mtl_sales_orders |
77: | Oct 2012 Bug 14722708 - Commenting out this procedure as GMI module |
78: | is obsolete in R12. This procedure should not be used for |
79: | debugging R12 code. Instead please use appropriate product |
80: | (INV/OM/WSH) specific debugging mechanism. |

Line 2356: , mtl_sales_orders mtl

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

Line 3781: From mtl_sales_orders mtl,

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

Line 3923: From mtl_sales_orders mtl,

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