APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 3880: FROM mtl_txn_request_headers mtrh

3876: AND mmtt.move_order_line_id = mtrl.line_id
3877: AND (mtrl.quantity - Nvl(mtrl.quantity_delivered, 0)) > 0
3878: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3879: AND exists (SELECT 1
3880: FROM mtl_txn_request_headers mtrh
3881: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3882: AND mtrh.header_id = mtrl.header_id)
3883: ORDER BY 3 DESC;
3884:

Line 3951: FROM mtl_txn_request_headers mtrh

3947: AND mmtt.move_order_line_id (+) = mtrl.line_id
3948: AND mmtt.organization_id (+) = mtrl.organization_id
3949: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
3950: AND exists (SELECT 1
3951: FROM mtl_txn_request_headers mtrh
3952: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
3953: AND mtrh.header_id = mtrl.header_id)
3954: ORDER BY 2, 3 DESC, 4 DESC, 5;--order on 3 should be DESC because,
3955: --if it is not, NULL values wouuld come last

Line 4004: FROM mtl_txn_request_headers mtrh

4000: AND Nvl(crossdock_type,-1) = Nvl(p_crossdock_type,-1)
4001: -- AND Nvl(from_cost_group_id,-1) = Nvl(p_cost_group_id,-1) ????
4002: AND mtrl.line_status <> inv_globals.G_TO_STATUS_CLOSED
4003: AND exists (SELECT 1
4004: FROM mtl_txn_request_headers mtrh
4005: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
4006: AND mtrh.header_id = mtrl.header_id)
4007: ORDER BY 2,3 DESC, 4 ;
4008:

Line 11193: FROM mtl_txn_request_headers mtrh

11189: AND mtrl.lpn_id = v_lpn_id
11190: AND mtrl.line_status = 7
11191: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0
11192: AND exists (SELECT 1
11193: FROM mtl_txn_request_headers mtrh
11194: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
11195: AND mtrh.header_id = mtrl.header_id);
11196:
11197: TYPE mol_mmtt_ctnt_tb_tp IS TABLE OF c_mol_mmtt_ctnt_cur%ROWTYPE;