APPS.INV_OPM_LOT_MIGRATION dependencies on FND_DESCR_FLEX_CONTEXTS

Line 622: fnd_descr_flex_contexts cont

618: SELECT col.descriptive_flex_context_code,
619: col.application_column_name,
620: col.end_user_column_name
621: FROM fnd_descr_flex_column_usages col,
622: fnd_descr_flex_contexts cont
623: WHERE
624: col.application_id = 551 and
625: col.descriptive_flexfield_name = 'LOTS_FLEX' and
626: col.enabled_flag = 'Y' and

Line 634: fnd_descr_flex_contexts cont2

630: cont.enabled_flag = 'Y' and
631: col.application_column_name in (
632: SELECT col2.application_column_name
633: FROM fnd_descr_flex_column_usages col2,
634: fnd_descr_flex_contexts cont2
635: WHERE
636: col2.application_id = 401 and
637: col2.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
638: col2.enabled_flag = 'Y' and

Line 650: fnd_descr_flex_contexts cont

646: SELECT col.descriptive_flex_context_code,
647: col.application_column_name,
648: col.end_user_column_name
649: FROM fnd_descr_flex_column_usages col,
650: fnd_descr_flex_contexts cont
651: WHERE
652: col.application_id = 551 and
653: col.descriptive_flexfield_name = 'LOTS_FLEX' and
654: col.enabled_flag = 'Y' and

Line 667: FROM fnd_descr_flex_contexts cont

663: g_desc_flex_conflict := 0;
664: BEGIN
665: SELECT cont.descriptive_flex_context_code
666: INTO l_opm_context
667: FROM fnd_descr_flex_contexts cont
668: WHERE cont.application_id = 551 and
669: cont.descriptive_flexfield_name = 'LOTS_FLEX' and
670: cont.enabled_flag = 'Y' and
671: cont.global_flag = 'N' and

Line 681: FROM fnd_descr_flex_contexts cont

677: END;
678: BEGIN
679: SELECT cont.descriptive_flex_context_code
680: INTO l_odm_context
681: FROM fnd_descr_flex_contexts cont
682: WHERE cont.application_id = 401 and
683: cont.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
684: cont.enabled_flag = 'Y' and
685: cont.global_flag = 'N' and