APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on INV_GLOBALS

Line 343: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away

339: SELECT mol.line_id, mol.line_number
340: FROM mtl_txn_request_headers moh,
341: mtl_txn_request_lines mol
342: WHERE mol.header_id = moh.header_id
343: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
344: AND mol.organization_id = p_organization_id
345: AND mol.lpn_id is not null
346: AND mol.lpn_id = NVL(p_lpn_id, mol.lpn_id)
347: AND (NVL(mol.quantity_delivered,0) + NVL(mol.quantity_detailed,0)) <

Line 365: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away

361: mtl_txn_request_headers moh,
362: mtl_txn_request_lines mol,
363: wms_license_plate_numbers lpn
364: WHERE mol.header_id = moh.header_id
365: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
366: AND mol.organization_id = p_organization_id
367: AND mol.lpn_id is not null
368: AND mol.lpn_id = nvl(p_lpn_id, mol.lpn_id) --BUG3497572 p_lpn_id is an optional argument for concurrent request
369: AND mol.lpn_id = lpn.lpn_id

Line 494: AND line_status <> inv_globals.g_to_status_closed /* 3867448 */

490: FROM DUAL WHERE exists
491: (SELECT 1
492: FROM mtl_txn_request_lines
493: WHERE lpn_id = p_lpn_id
494: AND line_status <> inv_globals.g_to_status_closed /* 3867448 */
495: AND Nvl(wms_process_flag, 1) = 2);
496: EXCEPTION
497: WHEN no_data_found THEN
498: l_process_flag_count := 0;