APPS.INV_UI_RCV_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 7334: AND (wlpn.lpn_context = 3 and wlpn.lpn_id IN (Select mtrl.lpn_id from mtl_txn_request_lines mtrl

7330: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
7331: AND wlpn.license_plate_number LIKE p_lpn
7332: AND wlpn.organization_id = p_orgid
7333: AND wlpn.lpn_context in (3,5)
7334: AND (wlpn.lpn_context = 3 and wlpn.lpn_id IN (Select mtrl.lpn_id from mtl_txn_request_lines mtrl
7335: where mtrl.lpn_id = wlpn.lpn_id AND NVL(mtrl.project_id, -99) = p_projid
7336: AND NVL(mtrl.task_id, -99) = p_taskid ) )
7337: ORDER BY wlpn.license_plate_number
7338: ;