APPS.FLM_KANBAN_PURGE dependencies on MTL_SYSTEM_ITEMS

Line 176: FROM MTL_SYSTEM_ITEMS

172: into l_records_found
173: FROM DUAL
174: WHERE EXISTS
175: ( SELECT 1
176: FROM MTL_SYSTEM_ITEMS
177: WHERE organization_id = arg_org_id
178: AND inventory_item_id = arg_item_id
179: AND wip_supply_subinventory = arg_subinv
180: AND nvl(wip_supply_locator_id,-1) = nvl(arg_loc_id,-1));

Line 377: ' (select inventory_item_id from mtl_system_items ' ||

373: if ((arg_item_from IS NOT NULL) or (arg_item_to IS NOT NULL)) then
374: INVKBCGN.query_range_itm(arg_item_from, arg_item_to,l_where_item);
375: l_sql_stmt := l_sql_stmt || ' AND ' ||
376: ' inventory_item_id in '||
377: ' (select inventory_item_id from mtl_system_items ' ||
378: ' where ' || l_where_item || ' and organization_id = :org_id) ';
379: end if;
380:
381: l_sql_stmt := l_sql_stmt || ' AND ' ||