APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_SERIAL_NUMBERS

Line 1981: from mtl_serial_numbers

1977: AND rec.SERIAL IS NOT NULL THEN
1978:
1979: select status_id
1980: into rec.status_id
1981: from mtl_serial_numbers
1982: where inventory_item_id = rec.item_id
1983: and serial_number = rec.SERIAL;
1984:
1985: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial status_id '||rec.status_id);

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

2794: IF inv_mwb_globals.g_serial_from IS NOT NULL
2795: OR inv_mwb_globals.g_serial_to IS NOT NULL
2796: OR inv_mwb_globals.g_tree_serial_number IS NOT NULL
2797: OR l_serial_control IN (2, 5) THEN
2798: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ',p_mat_loc);
2799: add_where_clause('msn.lpn_id = wlpn.lpn_id', p_mat_loc);
2800: add_where_clause('msn.current_organization_id = wlc.organization_id', p_mat_loc);
2801: add_where_clause('msn.inventory_item_id = wlc.inventory_item_id', p_mat_loc);
2802:

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

3088: END IF;
3089:
3090: ELSIF p_flag = 'MSN_RECEIVING' THEN
3091:
3092: inv_mwb_query_manager.add_from_clause(' mtl_serial_numbers msn ','RECEIVING');
3093: add_where_clause('msn.current_status = 7', 'RECEIVING');
3094:
3095: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
3096: add_where_clause('msn.current_organization_id = :rcv_to_organization_id', 'RECEIVING');