APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_ITEM_CATEGORIES
Line 1026: FROM MTL_ITEM_CATEGORIES
1022: if (p_category_id is not null and p_category_id <> fnd_api.g_miss_num) then
1023: l_category_set_id := 1000000014;
1024:
1025: SELECT count(*) into l_count 1026: FROM MTL_ITEM_CATEGORIES 1027: WHERE category_id = p_category_id
1028: AND inventory_item_id = p_inventory_item_id
1029: AND organization_id = p_current_organization_id
1030: AND category_set_id = l_category_set_id;