APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_ITEM_CATEGORIES

Line 994: FROM MTL_ITEM_CATEGORIES

990: if (p_category_id is not null and p_category_id <> fnd_api.g_miss_num) then
991: l_category_set_id := 1000000014;
992:
993: SELECT count(*) into l_count
994: FROM MTL_ITEM_CATEGORIES
995: WHERE category_id = p_category_id
996: AND inventory_item_id = p_inventory_item_id
997: AND organization_id = p_current_organization_id
998: AND category_set_id = l_category_set_id;