APPS.INV_RCV_RESERVATION_UTIL dependencies on MTL_TXN_REQUEST_HEADERS

Line 2377: FROM mtl_txn_request_headers mtrh

2373: or p_cas_mol_rec_tb(1).lpn_id is null) -- Bug 6618890 --Bug#8627996
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

Line 2452: FROM mtl_txn_request_headers mtrh

2448: AND Nvl(mol.lot_number,'&^+') = Nvl(p_cas_mol_rec_tb(1).lot_number,'&^+')
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

Line 2473: FROM mtl_txn_request_headers mtrh

2469: AND Nvl(mol.lot_number,'&#+') = Nvl(p_cas_mol_rec_tb(1).lot_number,'&#+')
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: )

Line 2507: FROM mtl_txn_request_headers mtrh

2503: or p_cas_mol_rec_tb(1).lpn_id is null) -- Bug 6618890 --Bug#8627996
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

Line 2869: FROM mtl_txn_request_headers mtrh

2865: AND (NVL(mtrl.task_id, -999) = NVL(p_cas_mol_rec_tb(1).task_id, -999)
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

Line 3037: FROM mtl_txn_request_headers mtrh

3033: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
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