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 EGO_PROD_CAT_SALES_MARKET_AGV

Line 251: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A

247: FROM MTL_CATEGORY_SET_VALID_CATS C, MTL_CATEGORIES_B B, FND_LANGUAGES TL
248: WHERE C.CATEGORY_SET_ID = g_catset_id
249: AND TL.INSTALLED_FLAG IN ('I', 'B')
250: AND B.CATEGORY_ID = C.CATEGORY_ID
251: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A
252: WHERE A.CATEGORY_SET_ID = g_catset_id
253: AND A.CATEGORY_ID = C.CATEGORY_ID
254: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y');
255:

Line 266: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A

262: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id
263: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) C
264: WHERE C.CATEGORY_ID = TL.CATEGORY_ID
265: AND TL.LANGUAGE = l_language
266: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A
267: WHERE A.CATEGORY_SET_ID = g_catset_id
268: AND A.CATEGORY_ID = C.CATEGORY_ID
269: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y')
270: ORDER BY hrchy ASC; -- Bug 4749088

Line 427: WHERE NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A

423: CURSOR C2(p_child NUMBER) IS
424: SELECT D.CATEGORY_ID, B.DISABLE_DATE FROM
425: (SELECT C.CATEGORY_ID
426: FROM MTL_CATEGORY_SET_VALID_CATS C
427: WHERE NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A
428: WHERE A.CATEGORY_SET_ID = g_catset_id
429: AND A.CATEGORY_ID = C.CATEGORY_ID
430: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y')
431: START WITH CATEGORY_ID = p_child AND CATEGORY_SET_ID = g_catset_id

Line 445: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A

441: START WITH CATEGORY_ID = l_child_id AND CATEGORY_SET_ID = g_catset_id
442: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) C
443: WHERE C.CATEGORY_ID = TL.CATEGORY_ID
444: AND TL.LANGUAGE = l_language
445: AND NOT EXISTS (SELECT NULL FROM EGO_PROD_CAT_SALES_MARKET_AGV A
446: WHERE A.CATEGORY_SET_ID = g_catset_id
447: AND A.CATEGORY_ID = C.CATEGORY_ID
448: AND NVL(A.EXCLUDE_USER_VIEW, 'N') = 'Y')
449: ORDER BY hrchy ASC; -- Bug 4749088