DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORIES_TL

Line 602: INSERT INTO MTL_CATEGORIES_TL(

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 */
602: INSERT INTO MTL_CATEGORIES_TL(
603: CATEGORY_ID,
604: LANGUAGE,
605: SOURCE_LANG,
606: DESCRIPTION,

Line 625: (select 'Y' FROM mtl_categories_tl m

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
626: where m.category_id= mtl.category_id
627: and m.language=fnd.language);
628:
629: END IF;