APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORIES_B

Line 558: INSERT INTO MTL_CATEGORIES_B(

554:
555: /* Create Categories */
556: IF l_category_set_exists=TRUE THEN
557:
558: INSERT INTO MTL_CATEGORIES_B(
559: CATEGORY_ID,
560: STRUCTURE_ID,
561: DISABLE_DATE,
562: SUMMARY_FLAG,

Line 597: from mtl_categories_b m

593: AND language=userenv('lang') -- Bug 6441455
594: AND enabled_flag = 'Y'
595: AND NOT EXISTS
596: (select 'Y'
597: from mtl_categories_b m
598: where m.structure_id = p_structure_id
599: and m.segment1=fnd.lookup_code);
600:
601: /* Create same languages existing in the Lookup Type */

Line 621: FROM fnd_lookup_values fnd, mtl_categories_b mtl

617: fnd_global.user_id,
618: SYSDATE,
619: fnd_global.user_id,
620: FND_GLOBAL.CONC_LOGIN_ID
621: FROM fnd_lookup_values fnd, mtl_categories_b mtl
622: WHERE lookup_type = l_lookup_type
623: AND FND.lookup_code = mtl.segment1
624: AND NOT EXISTS
625: (select 'Y' FROM mtl_categories_tl m