APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORIES_B

Line 539: INSERT INTO MTL_CATEGORIES_B(

535:
536: /* Create Categories */
537: IF l_category_set_exists=TRUE THEN
538:
539: INSERT INTO MTL_CATEGORIES_B(
540: CATEGORY_ID,
541: STRUCTURE_ID,
542: DISABLE_DATE,
543: SUMMARY_FLAG,

Line 577: (select 'Y' from mtl_categories_b m where m.structure_id = p_structure_id

573: WHERE lookup_type = l_lookup_type
574: AND language=userenv('lang') -- Bug 6441455
575: AND enabled_flag = 'Y'
576: AND NOT EXISTS
577: (select 'Y' from mtl_categories_b m where m.structure_id = p_structure_id
578: and m.segment1=fnd.lookup_code);
579:
580: /* Create same languages existing in the Lookup Type */
581: INSERT INTO MTL_CATEGORIES_TL(

Line 600: FROM fnd_lookup_values fnd, mtl_categories_b mtl

596: fnd_global.user_id,
597: SYSDATE,
598: fnd_global.user_id,
599: FND_GLOBAL.CONC_LOGIN_ID
600: FROM fnd_lookup_values fnd, mtl_categories_b mtl
601: WHERE lookup_type = l_lookup_type
602: AND FND.lookup_code = mtl.segment1
603: AND NOT EXISTS
604: (select 'Y' FROM mtl_categories_tl m