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 1747: FROM MTL_SYSTEM_ITEMS_B IT

1743: l_count := 0;
1744:
1745: BEGIN
1746: SELECT 1 INTO l_count
1747: FROM MTL_SYSTEM_ITEMS_B IT
1748: WHERE ROWNUM = 1
1749: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C
1750: WHERE C.CATEGORY_SET_ID = g_catset_id
1751: AND C.INVENTORY_ITEM_ID = IT.INVENTORY_ITEM_ID