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.INVPULI2 dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 60: FROM MTL_ITEM_CATALOG_GROUPS_B

56: WHERE TEMPLATE_NAME = CP_TEMPLATE_NAME
57: AND EXISTS (SELECT 1
58: FROM EGO_CAT_GRP_TEMPLATES
59: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
60: FROM MTL_ITEM_CATALOG_GROUPS_B
61: START WITH ITEM_CATALOG_GROUP_ID = CP_CAT_GRP_ID
62: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID)
63: AND TEMPLATE_ID = MIT.TEMPLATE_ID);
64:

Line 73: FROM MTL_ITEM_CATALOG_GROUPS_B

69: WHERE TEMPLATE_ID = CP_TEMPLATE_ID
70: AND EXISTS (SELECT 1
71: FROM EGO_CAT_GRP_TEMPLATES
72: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
73: FROM MTL_ITEM_CATALOG_GROUPS_B
74: START WITH ITEM_CATALOG_GROUP_ID = CP_CAT_GRP_ID
75: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID)
76: AND TEMPLATE_ID = MIT.TEMPLATE_ID);
77:

Line 192: FROM MTL_ITEM_CATALOG_GROUPS_B

188: SELECT COUNT(1)
189: INTO L_CAT_TEMPL_COUNT
190: FROM EGO_CAT_GRP_TEMPLATES
191: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
192: FROM MTL_ITEM_CATALOG_GROUPS_B
193: START WITH ITEM_CATALOG_GROUP_ID = CUR.ITEM_CATALOG_GROUP_ID
194: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID);
195:
196:

Line 210: FROM MTL_ITEM_CATALOG_GROUPS_B

206: SELECT COUNT(1)
207: INTO L_CAT_TEMPL_COUNT
208: FROM EGO_CAT_GRP_TEMPLATES
209: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID
210: FROM MTL_ITEM_CATALOG_GROUPS_B
211: START WITH ITEM_CATALOG_GROUP_ID = (SELECT NVL(ITEM_CATALOG_GROUP_ID,0)
212: FROM MTL_SYSTEM_ITEMS_B
213: WHERE INVENTORY_ITEM_ID = CUR.INVENTORY_ITEM_ID
214: AND ORGANIZATION_ID = CUR.ORGANIZATION_ID)