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 1383: FROM MTL_ITEM_CATEGORIES C

1379: AND B.OBJECT_ID = g_catset_id
1380: AND B.CHILD_ID <> -1
1381: AND B.ITEM_ASSGN_FLAG <> 'Y'
1382: AND EXISTS (SELECT NULL
1383: FROM MTL_ITEM_CATEGORIES C
1384: WHERE C.CATEGORY_SET_ID = g_catset_id
1385: AND C.CATEGORY_ID = B.CHILD_ID);
1386:
1387: l_count := SQL%ROWCOUNT;

Line 1405: FROM MTL_ITEM_CATEGORIES C

1401: AND B.OBJECT_ID = g_catset_id
1402: AND B.CHILD_ID <> -1
1403: AND B.ITEM_ASSGN_FLAG <> 'N'
1404: AND NOT EXISTS (SELECT NULL
1405: FROM MTL_ITEM_CATEGORIES C
1406: WHERE C.CATEGORY_SET_ID = g_catset_id
1407: AND C.CATEGORY_ID = B.CHILD_ID);
1408:
1409: l_count := l_count + SQL%ROWCOUNT;

Line 1744: FROM MTL_ITEM_CATEGORIES C

1740: WHERE B.OBJECT_TYPE = 'CATEGORY_SET'
1741: AND B.OBJECT_ID = g_catset_id
1742: AND B.ITEM_ASSGN_FLAG = 'N'
1743: AND EXISTS (SELECT NULL
1744: FROM MTL_ITEM_CATEGORIES C
1745: WHERE C.CATEGORY_SET_ID = g_catset_id
1746: AND C.CATEGORY_ID = B.CHILD_ID);
1747:
1748: -- updating Item Assignment flag for all categories, which does not have items attached to it

Line 1764: FROM MTL_ITEM_CATEGORIES C

1760: AND B.OBJECT_ID = g_catset_id
1761: AND B.ITEM_ASSGN_FLAG = 'Y'
1762: AND B.CHILD_ID <> -1
1763: AND NOT EXISTS (SELECT NULL
1764: FROM MTL_ITEM_CATEGORIES C
1765: WHERE C.CATEGORY_SET_ID = g_catset_id
1766: AND C.CATEGORY_ID = B.CHILD_ID);
1767:
1768: -- Checking Item assignment flag for Unassigned category

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

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