APPS.INV_RCV_RESERVATION_UTIL dependencies on INV_GLOBALS

Line 2378: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

2374: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered,0)) > 0
2375: AND mtrl.backorder_delivery_detail_id IS NULL
2376: AND exists (SELECT 1
2377: FROM mtl_txn_request_headers mtrh
2378: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2379: AND mtrh.header_id = mtrl.header_id);
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: RAISE fnd_api.g_exc_unexpected_error;

Line 2453: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

2449: AND mol.line_status = 7
2450: AND (mol.quantity-Nvl(mol.quantity_delivered,0))>0
2451: AND exists (SELECT 1
2452: FROM mtl_txn_request_headers mtrh
2453: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2454: AND mtrh.header_id = mol.header_id)
2455: )) OR
2456: (mr.demand_source_line_detail IS NULL
2457: AND exists (SELECT mol.backorder_delivery_detail_id

Line 2474: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

2470: AND mol.line_status = 7
2471: AND (mol.quantity-Nvl(mol.quantity_delivered,0))>0
2472: AND exists (SELECT 1
2473: FROM mtl_txn_request_headers mtrh
2474: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2475: AND mtrh.header_id = mol.header_id)
2476: )
2477: )
2478: )

Line 2508: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

2504: AND mol.crossdock_type = 1
2505: AND NVL(mol.lpn_id, -999) = NVL(p_cas_mol_rec_tb(1).lpn_id, -999)
2506: AND exists (SELECT 1
2507: FROM mtl_txn_request_headers mtrh
2508: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2509: AND mtrh.header_id = mol.header_id);
2510: EXCEPTION
2511: WHEN OTHERS THEN
2512: IF (l_debug = 1) THEN

Line 2870: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

2866: OR p_cas_mol_rec_tb(1).lpn_id IS NULL) -- Bug 6618890 --Bug#8627996
2867: AND Nvl(mtrl.lot_number,'&*_') = Nvl(p_cas_mol_rec_tb(1).lot_number,'&*_')
2868: AND exists (SELECT 1
2869: FROM mtl_txn_request_headers mtrh
2870: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2871: AND mtrh.header_id = mtrl.header_id)
2872: )
2873: LOOP
2874: IF (l_debug = 1) THEN

Line 3038: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away

3034: AND mmtt.move_order_line_id (+) = mtrl.line_id
3035: AND mmtt.organization_id (+) = mtrl.organization_id
3036: AND exists (SELECT 1
3037: FROM mtl_txn_request_headers mtrh
3038: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3039: AND mtrh.header_id = mtrl.header_id)
3040: --only pick up lines that are NOT loaded
3041: AND (mmtt.transaction_temp_id IS NULL
3042: OR