DBA Data[Home] [Help]

APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_DESCR_FLEX_CONTEXTS

Line 1178: fnd_descr_flex_contexts cont

1174: SELECT col.descriptive_flex_context_code,
1175: col.application_column_name,
1176: col.end_user_column_name
1177: FROM fnd_descr_flex_column_usages col,
1178: fnd_descr_flex_contexts cont
1179: WHERE
1180: col.application_id = 551 and
1181: col.descriptive_flexfield_name = 'ITEM_FLEX' and
1182: col.enabled_flag = 'Y' and

Line 1190: fnd_descr_flex_contexts cont2

1186: cont.enabled_flag = 'Y' and
1187: col.application_column_name in (
1188: SELECT col2.application_column_name
1189: FROM fnd_descr_flex_column_usages col2,
1190: fnd_descr_flex_contexts cont2
1191: WHERE
1192: col2.application_id = 401 and
1193: col2.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and
1194: col2.enabled_flag = 'Y' and

Line 1206: fnd_descr_flex_contexts cont

1202: SELECT col.descriptive_flex_context_code,
1203: col.application_column_name,
1204: col.end_user_column_name
1205: FROM fnd_descr_flex_column_usages col,
1206: fnd_descr_flex_contexts cont
1207: WHERE
1208: col.application_id = 551 and
1209: col.descriptive_flexfield_name = 'ITEM_FLEX' and
1210: col.enabled_flag = 'Y' and

Line 1224: FROM fnd_descr_flex_contexts cont

1220: g_desc_flex_conflict := 0;
1221: BEGIN
1222: SELECT cont.descriptive_flex_context_code
1223: INTO l_opm_context
1224: FROM fnd_descr_flex_contexts cont
1225: WHERE cont.application_id = 551 and
1226: cont.descriptive_flexfield_name = 'ITEM_FLEX' and
1227: cont.enabled_flag = 'Y' and
1228: cont.global_flag = 'N' and

Line 1238: FROM fnd_descr_flex_contexts cont

1234: END;
1235: BEGIN
1236: SELECT cont.descriptive_flex_context_code
1237: INTO l_odm_context
1238: FROM fnd_descr_flex_contexts cont
1239: WHERE cont.application_id = 401 and
1240: cont.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and
1241: cont.enabled_flag = 'Y' and
1242: cont.global_flag = 'N' and

Line 1881: fnd_descr_flex_contexts cont2

1877: BEGIN
1878: SELECT end_user_column_name
1879: INTO l_end_user_column_name
1880: FROM fnd_descr_flex_column_usages col2,
1881: fnd_descr_flex_contexts cont2
1882: WHERE
1883: col2.application_id IN (401, 551) and
1884: col2.descriptive_flexfield_name in ('MTL_SYSTEM_ITEMS', 'ITEM_FLEX') AND
1885: col2.enabled_flag = 'Y' and