APPS.ENI_DENORM_HRCHY dependencies on MTL_SYSTEM_ITEMS_B

Line 884: FROM MTL_SYSTEM_ITEMS_B IT

880: -- if all items are attached to some categories within this category set then
881: -- Item assignment flag for Unassigned node will be 'N'
882: BEGIN
883: SELECT 1 INTO l_count
884: FROM MTL_SYSTEM_ITEMS_B IT
885: WHERE ROWNUM = 1
886: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C
887: WHERE C.CATEGORY_SET_ID = g_catset_id
888: AND C.INVENTORY_ITEM_ID = IT.INVENTORY_ITEM_ID

Line 1776: FROM MTL_SYSTEM_ITEMS_B IT

1772: l_count := 0;
1773:
1774: BEGIN
1775: SELECT 1 INTO l_count
1776: FROM MTL_SYSTEM_ITEMS_B IT
1777: WHERE ROWNUM = 1
1778: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C
1779: WHERE C.CATEGORY_SET_ID = g_catset_id
1780: AND C.INVENTORY_ITEM_ID = IT.INVENTORY_ITEM_ID