APPS.INV_OPM_LOT_MIGRATION dependencies on FND_DESCR_FLEX_CONTEXTS

Line 528: fnd_descr_flex_contexts cont

524: SELECT col.descriptive_flex_context_code,
525: col.application_column_name,
526: col.end_user_column_name
527: FROM fnd_descr_flex_column_usages col,
528: fnd_descr_flex_contexts cont
529: WHERE
530: col.application_id = 551 and
531: col.descriptive_flexfield_name = 'LOTS_FLEX' and
532: col.enabled_flag = 'Y' and

Line 540: fnd_descr_flex_contexts cont2

536: cont.enabled_flag = 'Y' and
537: col.application_column_name in (
538: SELECT col2.application_column_name
539: FROM fnd_descr_flex_column_usages col2,
540: fnd_descr_flex_contexts cont2
541: WHERE
542: col2.application_id = 401 and
543: col2.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
544: col2.enabled_flag = 'Y' and

Line 556: fnd_descr_flex_contexts cont

552: SELECT col.descriptive_flex_context_code,
553: col.application_column_name,
554: col.end_user_column_name
555: FROM fnd_descr_flex_column_usages col,
556: fnd_descr_flex_contexts cont
557: WHERE
558: col.application_id = 551 and
559: col.descriptive_flexfield_name = 'LOTS_FLEX' and
560: col.enabled_flag = 'Y' and

Line 573: FROM fnd_descr_flex_contexts cont

569: g_desc_flex_conflict := 0;
570: BEGIN
571: SELECT cont.descriptive_flex_context_code
572: INTO l_opm_context
573: FROM fnd_descr_flex_contexts cont
574: WHERE cont.application_id = 551 and
575: cont.descriptive_flexfield_name = 'LOTS_FLEX' and
576: cont.enabled_flag = 'Y' and
577: cont.global_flag = 'N' and

Line 587: FROM fnd_descr_flex_contexts cont

583: END;
584: BEGIN
585: SELECT cont.descriptive_flex_context_code
586: INTO l_odm_context
587: FROM fnd_descr_flex_contexts cont
588: WHERE cont.application_id = 401 and
589: cont.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
590: cont.enabled_flag = 'Y' and
591: cont.global_flag = 'N' and