DBA Data[Home] [Help]

APPS.GME_PICKING_PVT dependencies on INV_GLOBALS

Line 306: ,inv_globals.g_move_order_put_away)

302: AND l.line_status NOT IN (5, 6)
303: AND h.header_id = l.header_id
304: AND h.move_order_type NOT IN
305: (gme_common_pvt.g_invis_move_order_type
306: ,inv_globals.g_move_order_put_away)
307: ORDER BY l.header_id, l.line_id;
308:
309: -- Bug 13076579
310: l_index NUMBER;

Line 331: ,inv_globals.g_move_order_put_away);

327: AND l.line_status NOT IN (5, 6)
328: AND h.header_id = l.header_id
329: AND h.move_order_type NOT IN
330: (gme_common_pvt.g_invis_move_order_type
331: ,inv_globals.g_move_order_put_away);
332:
333:
334: -- Bug 13076579 - get the sum across all open move orders to see what is still open.
335: CURSOR cur_pending_move_orders_sum (

Line 351: ,inv_globals.g_move_order_put_away)

347: AND l.line_status NOT IN (5, 6)
348: AND h.header_id = l.header_id
349: AND h.move_order_type NOT IN
350: (gme_common_pvt.g_invis_move_order_type
351: ,inv_globals.g_move_order_put_away)
352: GROUP BY l.txn_source_line_id;
353:
354: TYPE pend_lines_tab IS TABLE OF cur_pending_move_orders%ROWTYPE
355: INDEX BY BINARY_INTEGER;