DBA Data[Home] [Help]

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;