APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on INV_GLOBALS

Line 381: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away

377: SELECT mol.line_id, mol.line_number
378: FROM mtl_txn_request_headers moh,
379: mtl_txn_request_lines mol
380: WHERE mol.header_id = moh.header_id
381: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
382: AND mol.organization_id = p_organization_id
383: AND mol.lpn_id is not null
384: AND mol.lpn_id = NVL(p_lpn_id, mol.lpn_id)
385: AND (NVL(mol.quantity_delivered,0) + NVL(mol.quantity_detailed,0)) <

Line 403: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away

399: mtl_txn_request_headers moh,
400: mtl_txn_request_lines mol,
401: wms_license_plate_numbers lpn
402: WHERE mol.header_id = moh.header_id
403: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
404: AND mol.organization_id = p_organization_id
405: AND mol.lpn_id is not null
406: AND mol.lpn_id = nvl(p_lpn_id, mol.lpn_id) --BUG3497572 p_lpn_id is an optional argument for concurrent request
407: AND mol.lpn_id = lpn.lpn_id

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

528: FROM DUAL WHERE exists
529: (SELECT 1
530: FROM mtl_txn_request_lines
531: WHERE lpn_id = p_lpn_id
532: AND line_status <> inv_globals.g_to_status_closed /* 3867448 */
533: AND Nvl(wms_process_flag, 1) = 2);
534: EXCEPTION
535: WHEN no_data_found THEN
536: l_process_flag_count := 0;