APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_SERIAL_NUMBERS

Line 235: Select instr(upper(l_query_str),'MTL_SERIAL_NUMBERS',1)

231: AND inv_mwb_globals.g_view_by <> 'SERIAL' THEN
232:
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

Line 2085: from mtl_serial_numbers

2081: AND rec.SERIAL IS NOT NULL THEN
2082:
2083: select status_id
2084: into rec.status_id
2085: from mtl_serial_numbers
2086: where inventory_item_id = rec.item_id
2087: and serial_number = rec.SERIAL;
2088:
2089: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial status_id '||rec.status_id);

Line 2220: where exists (select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt

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
2224: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number

Line 2226: select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt

2222: and wlqv.transaction_temp_id = msnt.transaction_temp_id
2223: and wlqv.inventory_item_id = rec.item_id
2224: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number
2225: union
2226: select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt
2227: where wlqv.serial_transaction_temp_id IS NOT NULL
2228: and wlqv.serial_transaction_temp_id = msnt.transaction_temp_id
2229: and wlqv.inventory_item_id = rec.item_id
2230: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number);

Line 3217: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ',p_mat_loc);

3213: IF inv_mwb_globals.g_serial_from IS NOT NULL
3214: OR inv_mwb_globals.g_serial_to IS NOT NULL
3215: OR inv_mwb_globals.g_tree_serial_number IS NOT NULL
3216: OR l_serial_control IN (2, 5) THEN
3217: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ',p_mat_loc);
3218: add_where_clause('msn.lpn_id = wlpn.lpn_id', p_mat_loc);
3219: add_where_clause('msn.current_organization_id = wlc.organization_id', p_mat_loc);
3220: add_where_clause('msn.inventory_item_id = wlc.inventory_item_id', p_mat_loc);
3221:

Line 3669: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ','RECEIVING');

3665: END IF;
3666:
3667: ELSIF p_flag = 'MSN_RECEIVING' THEN
3668:
3669: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ','RECEIVING');
3670: add_where_clause('msn.current_status = 7', 'RECEIVING');
3671:
3672: /* Bug 8225619. Adding ELSE CONDITION code such that right side grid
3673: retrieves the organizations which are relevant to particular