APPS.EAM_MATERIAL_REQUEST_PVT dependencies on MTL_TXN_REQUEST_LINES
Line 165: from mtl_txn_request_lines
161: end if;
162:
163: if (l_return_status = 'P') then
164: select sum(quantity_detailed) into l_partial_qty 165: from mtl_txn_request_lines 166: where header_id = (select header_id from mtl_txn_request_headers
167: where request_number = x_request_number
168: and organization_id = p_organization_id);
169: if (l_partial_qty = 0) then