APPS.GMI_PRE_MIGRATION dependencies on FND_DESCR_FLEX_CONTEXTS

Line 61: fnd_descr_flex_contexts cont

57: SELECT col.descriptive_flex_context_code,
58: col.application_column_name,
59: col.end_user_column_name
60: FROM fnd_descr_flex_column_usages col,
61: fnd_descr_flex_contexts cont
62: WHERE
63: col.application_id = 551 and
64: col.descriptive_flexfield_name = p_opm_desc_flex_name and
65: col.enabled_flag = 'Y' and

Line 73: fnd_descr_flex_contexts cont2

69: cont.enabled_flag = 'Y' and
70: col.application_column_name in (
71: SELECT col2.application_column_name
72: FROM fnd_descr_flex_column_usages col2,
73: fnd_descr_flex_contexts cont2
74: WHERE
75: col2.application_id = 401 and
76: col2.descriptive_flexfield_name = p_odm_desc_flex_name and
77: col2.enabled_flag = 'Y' and

Line 89: fnd_descr_flex_contexts cont

85: SELECT col.descriptive_flex_context_code,
86: col.application_column_name,
87: col.end_user_column_name
88: FROM fnd_descr_flex_column_usages col,
89: fnd_descr_flex_contexts cont
90: WHERE
91: col.application_id = 551 and
92: col.descriptive_flexfield_name = p_opm_desc_flex_name and
93: col.enabled_flag = 'Y' and

Line 114: FROM fnd_descr_flex_contexts cont

110: l_context := 'LOTS';
111: END IF;
112: SELECT cont.descriptive_flex_context_code
113: INTO l_opm_context
114: FROM fnd_descr_flex_contexts cont
115: WHERE cont.application_id = 551 and
116: cont.descriptive_flexfield_name = p_opm_desc_flex_name and
117: cont.enabled_flag = 'Y' and
118: cont.global_flag = 'N' and

Line 127: FROM fnd_descr_flex_contexts cont

123: END;
124: BEGIN
125: SELECT cont.descriptive_flex_context_code
126: INTO l_odm_context
127: FROM fnd_descr_flex_contexts cont
128: WHERE cont.application_id = 401 and
129: cont.descriptive_flexfield_name = p_odm_desc_flex_name and
130: cont.enabled_flag = 'Y' and
131: cont.global_flag = 'N' and