DBA Data[Home] [Help]

APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1177: FROM fnd_descr_flex_column_usages col,

1173:
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

Line 1189: FROM fnd_descr_flex_column_usages col2,

1185: col.descriptive_flex_context_code = cont.descriptive_flex_context_code and
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

Line 1205: FROM fnd_descr_flex_column_usages col,

1201:
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

Line 1880: FROM fnd_descr_flex_column_usages col2,

1876: -- Check if the desc flexfield column is used for another column
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