APPS.INV_UI_RCV_LOVS dependencies on MTL_TXN_REQUEST_LINES

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

8390: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
8391: AND wlpn.license_plate_number LIKE p_lpn
8392: AND wlpn.organization_id = p_orgid
8393: AND wlpn.lpn_context in (3,5)
8394: AND (wlpn.lpn_context = 3 and wlpn.lpn_id IN (Select mtrl.lpn_id from mtl_txn_request_lines mtrl
8395: where mtrl.lpn_id = wlpn.lpn_id AND NVL(mtrl.project_id, -99) = p_projid
8396: AND NVL(mtrl.task_id, -99) = p_taskid ) )
8397: ORDER BY wlpn.license_plate_number
8398: ;