APPS.INV_RCV_RESERVATION_UTIL dependencies on MTL_TXN_REQUEST_HEADERS

Line 2171: FROM mtl_txn_request_headers mtrh

2167: or p_cas_mol_rec_tb(1).task_id is null) -- Bug 6618890
2168: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered,0)) > 0
2169: AND mtrl.backorder_delivery_detail_id IS NULL
2170: AND exists (SELECT 1
2171: FROM mtl_txn_request_headers mtrh
2172: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2173: AND mtrh.header_id = mtrl.header_id);
2174: EXCEPTION
2175: WHEN OTHERS THEN

Line 2246: FROM mtl_txn_request_headers mtrh

2242: AND Nvl(mol.lot_number,'&^+') = Nvl(p_cas_mol_rec_tb(1).lot_number,'&^+')
2243: AND mol.line_status = 7
2244: AND (mol.quantity-Nvl(mol.quantity_delivered,0))>0
2245: AND exists (SELECT 1
2246: FROM mtl_txn_request_headers mtrh
2247: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2248: AND mtrh.header_id = mol.header_id)
2249: )) OR
2250: (mr.demand_source_line_detail IS NULL

Line 2267: FROM mtl_txn_request_headers mtrh

2263: AND Nvl(mol.lot_number,'&#+') = Nvl(p_cas_mol_rec_tb(1).lot_number,'&#+')
2264: AND mol.line_status = 7
2265: AND (mol.quantity-Nvl(mol.quantity_delivered,0))>0
2266: AND exists (SELECT 1
2267: FROM mtl_txn_request_headers mtrh
2268: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2269: AND mtrh.header_id = mol.header_id)
2270: )
2271: )

Line 2301: FROM mtl_txn_request_headers mtrh

2297: or p_cas_mol_rec_tb(1).task_id is null) -- Bug 6618890
2298: AND mol.crossdock_type = 1
2299: AND NVL(mol.lpn_id, -999) = NVL(p_cas_mol_rec_tb(1).lpn_id, -999)
2300: AND exists (SELECT 1
2301: FROM mtl_txn_request_headers mtrh
2302: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2303: AND mtrh.header_id = mol.header_id);
2304: EXCEPTION
2305: WHEN OTHERS THEN

Line 2663: FROM mtl_txn_request_headers mtrh

2659: AND (NVL(mtrl.task_id, -999) = NVL(p_cas_mol_rec_tb(1).task_id, -999)
2660: OR p_cas_mol_rec_tb(1).task_id IS NULL) -- Bug 6618890
2661: AND Nvl(mtrl.lot_number,'&*_') = Nvl(p_cas_mol_rec_tb(1).lot_number,'&*_')
2662: AND exists (SELECT 1
2663: FROM mtl_txn_request_headers mtrh
2664: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2665: AND mtrh.header_id = mtrl.header_id)
2666: )
2667: LOOP

Line 2831: FROM mtl_txn_request_headers mtrh

2827: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
2828: AND mmtt.move_order_line_id (+) = mtrl.line_id
2829: AND mmtt.organization_id (+) = mtrl.organization_id
2830: AND exists (SELECT 1
2831: FROM mtl_txn_request_headers mtrh
2832: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2833: AND mtrh.header_id = mtrl.header_id)
2834: --only pick up lines that are NOT loaded
2835: AND (mmtt.transaction_temp_id IS NULL