DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORIES_TL

Line 581: INSERT INTO MTL_CATEGORIES_TL(

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(
582: CATEGORY_ID,
583: LANGUAGE,
584: SOURCE_LANG,
585: DESCRIPTION,

Line 604: (select 'Y' FROM mtl_categories_tl m

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
605: where m.category_id= mtl.category_id
606: and m.language=fnd.language);
607:
608: END IF;