APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 3936: FROM mtl_txn_request_headers mtrh

3932: AND mmtt.move_order_line_id = mtrl.line_id
3933: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3934: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3935: AND exists (SELECT 1
3936: FROM mtl_txn_request_headers mtrh
3937: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3938: AND mtrh.header_id = mtrl.header_id)
3939: ORDER BY 3 DESC;
3940:

Line 4010: FROM mtl_txn_request_headers mtrh

4006: AND mtrl.reference_id = p_new_reference_id --14133874
4007: AND mmtt.organization_id (+) = mtrl.organization_id
4008: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4009: AND exists (SELECT 1
4010: FROM mtl_txn_request_headers mtrh
4011: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4012: AND mtrh.header_id = mtrl.header_id)
4013: ORDER BY 2, 3 DESC, 4 DESC, 5;--order on 3 should be DESC because,
4014: --if it is not, NULL values wouuld come last

Line 4068: FROM mtl_txn_request_headers mtrh

4064: AND Nvl(crossdock_type,-1) = Nvl(p_crossdock_type,-1)
4065: -- AND Nvl(from_cost_group_id,-1) = Nvl(p_cost_group_id,-1) ????
4066: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4067: AND exists (SELECT 1
4068: FROM mtl_txn_request_headers mtrh
4069: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4070: AND mtrh.header_id = mtrl.header_id)
4071: ORDER BY 2,3 DESC, 4 ;
4072:

Line 11670: FROM mtl_txn_request_headers mtrh

11666: AND mtrl.lpn_id = v_lpn_id
11667: AND mtrl.line_status = 7
11668: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0
11669: AND exists (SELECT 1
11670: FROM mtl_txn_request_headers mtrh
11671: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
11672: AND mtrh.header_id = mtrl.header_id);
11673:
11674: TYPE mol_mmtt_ctnt_tb_tp IS TABLE OF c_mol_mmtt_ctnt_cur%ROWTYPE;