APPS.INV_MWB_QUERY_MANAGER dependencies on DUAL

Line 237: from dual;

233: --Bug 7611434 Begin
234: begin
235: Select instr(upper(l_query_str),'MTL_SERIAL_NUMBERS',1)
236: into l_if_msn
237: from dual;
238: exception
239: when others then
240: l_if_msn := 0;
241: end;

Line 2219: from dual

2215: begin
2216: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial '||rec.serial);
2217:
2218: select 1 into l_serial_loaded
2219: from dual
2220: where exists (select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt
2221: where wlqv.transaction_temp_id IS NOT NULL
2222: and wlqv.transaction_temp_id = msnt.transaction_temp_id
2223: and wlqv.inventory_item_id = rec.item_id