DBA Data[Home] [Help]

APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1090: FROM fnd_descr_flex_column_usages col,

1086:
1087: SELECT col.descriptive_flex_context_code,
1088: col.application_column_name,
1089: col.end_user_column_name
1090: FROM fnd_descr_flex_column_usages col,
1091: fnd_descr_flex_contexts cont
1092: WHERE
1093: col.application_id = 551 and
1094: col.descriptive_flexfield_name = 'ITEM_FLEX' and

Line 1102: FROM fnd_descr_flex_column_usages col2,

1098: col.descriptive_flex_context_code = cont.descriptive_flex_context_code and
1099: cont.enabled_flag = 'Y' and
1100: col.application_column_name in (
1101: SELECT col2.application_column_name
1102: FROM fnd_descr_flex_column_usages col2,
1103: fnd_descr_flex_contexts cont2
1104: WHERE
1105: col2.application_id = 401 and
1106: col2.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and

Line 1118: FROM fnd_descr_flex_column_usages col,

1114:
1115: SELECT col.descriptive_flex_context_code,
1116: col.application_column_name,
1117: col.end_user_column_name
1118: FROM fnd_descr_flex_column_usages col,
1119: fnd_descr_flex_contexts cont
1120: WHERE
1121: col.application_id = 551 and
1122: col.descriptive_flexfield_name = 'ITEM_FLEX' and

Line 1782: FROM fnd_descr_flex_column_usages col2,

1778: -- Check if the desc flexfield column is used for another column
1779: BEGIN
1780: SELECT end_user_column_name
1781: INTO l_end_user_column_name
1782: FROM fnd_descr_flex_column_usages col2,
1783: fnd_descr_flex_contexts cont2
1784: WHERE
1785: col2.application_id IN (401, 551) and
1786: col2.descriptive_flexfield_name in ('MTL_SYSTEM_ITEMS', 'ITEM_FLEX') AND