APPS.ENI_DENORM_HRCHY dependencies on MTL_CATEGORIES_B

Line 247: FROM MTL_CATEGORY_SET_VALID_CATS C, MTL_CATEGORIES_B B, FND_LANGUAGES TL

243: -- this procedure is called from the main procedure if sales and marketing is installed.
244: PROCEDURE LOAD_DENORM_PARENTS_PROD_HRCHY(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2) IS
245: CURSOR C1 IS
246: SELECT TL.LANGUAGE_CODE, C.CATEGORY_ID, B.DISABLE_DATE
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

Line 432: CONNECT BY PARENT_CATEGORY_ID = PRIOR CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) D, MTL_CATEGORIES_B B

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
432: CONNECT BY PARENT_CATEGORY_ID = PRIOR CATEGORY_ID AND CATEGORY_SET_ID = g_catset_id) D, MTL_CATEGORIES_B B
433: WHERE B.CATEGORY_ID = D.CATEGORY_ID;
434:
435: CURSOR C3(l_child_id NUMBER, l_language VARCHAR2) IS
436: SELECT TL.DESCRIPTION CHILD_DESC, C.CATEGORY_ID CHILD_ID

Line 743: FROM MTL_CATEGORIES_B

739: l_conc_request_id,
740: l_prog_appl_id,
741: SYSDATE,
742: l_conc_program_id
743: FROM MTL_CATEGORIES_B
744: WHERE STRUCTURE_ID = l_struct_id;
745: ELSE
746: -- Inserting Self-referencing Nodes
747: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting Self Referencing Nodes');

Line 1041: FROM MTL_CATEGORIES_B B

1037: l_conc_request_id,
1038: l_prog_appl_id,
1039: SYSDATE,
1040: l_conc_program_id
1041: FROM MTL_CATEGORIES_B B
1042: WHERE B.STRUCTURE_ID = l_struct_id
1043: AND NOT EXISTS (SELECT NULL FROM ENI_DENORM_HIERARCHIES H
1044: WHERE H.OBJECT_TYPE = 'CATEGORY_SET'
1045: AND H.OBJECT_ID = g_catset_id