eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENI_DENORM_HRCHY dependencies on MTL_ITEM_CATEGORIES

Line 870: FROM MTL_ITEM_CATEGORIES C

866: SET ITEM_ASSGN_FLAG = 'Y'
867: WHERE B.OBJECT_TYPE = 'CATEGORY_SET'
868: AND B.OBJECT_ID = g_catset_id
869: AND EXISTS (SELECT NULL
870: FROM MTL_ITEM_CATEGORIES C
871: WHERE C.CATEGORY_SET_ID = g_catset_id
872: AND C.CATEGORY_ID = B.CHILD_ID);
873:
874: l_count := SQL%ROWCOUNT;

Line 886: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C

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
889: AND C.ORGANIZATION_ID = IT.ORGANIZATION_ID);
890: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1354: FROM MTL_ITEM_CATEGORIES C

1350: AND B.OBJECT_ID = g_catset_id
1351: AND B.CHILD_ID <> -1
1352: AND B.ITEM_ASSGN_FLAG <> 'Y'
1353: AND EXISTS (SELECT NULL
1354: FROM MTL_ITEM_CATEGORIES C
1355: WHERE C.CATEGORY_SET_ID = g_catset_id
1356: AND C.CATEGORY_ID = B.CHILD_ID);
1357:
1358: l_count := SQL%ROWCOUNT;

Line 1376: FROM MTL_ITEM_CATEGORIES C

1372: AND B.OBJECT_ID = g_catset_id
1373: AND B.CHILD_ID <> -1
1374: AND B.ITEM_ASSGN_FLAG <> 'N'
1375: AND NOT EXISTS (SELECT NULL
1376: FROM MTL_ITEM_CATEGORIES C
1377: WHERE C.CATEGORY_SET_ID = g_catset_id
1378: AND C.CATEGORY_ID = B.CHILD_ID);
1379:
1380: l_count := l_count + SQL%ROWCOUNT;

Line 1715: FROM MTL_ITEM_CATEGORIES C

1711: WHERE B.OBJECT_TYPE = 'CATEGORY_SET'
1712: AND B.OBJECT_ID = g_catset_id
1713: AND B.ITEM_ASSGN_FLAG = 'N'
1714: AND EXISTS (SELECT NULL
1715: FROM MTL_ITEM_CATEGORIES C
1716: WHERE C.CATEGORY_SET_ID = g_catset_id
1717: AND C.CATEGORY_ID = B.CHILD_ID);
1718:
1719: -- updating Item Assignment flag for all categories, which does not have items attached to it

Line 1735: FROM MTL_ITEM_CATEGORIES C

1731: AND B.OBJECT_ID = g_catset_id
1732: AND B.ITEM_ASSGN_FLAG = 'Y'
1733: AND B.CHILD_ID <> -1
1734: AND NOT EXISTS (SELECT NULL
1735: FROM MTL_ITEM_CATEGORIES C
1736: WHERE C.CATEGORY_SET_ID = g_catset_id
1737: AND C.CATEGORY_ID = B.CHILD_ID);
1738:
1739: -- Checking Item assignment flag for Unassigned category

Line 1749: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES C

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
1752: AND C.ORGANIZATION_ID = IT.ORGANIZATION_ID);
1753: EXCEPTION WHEN NO_DATA_FOUND THEN