DBA Data[Home] [Help]

APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_DESCR_FLEX_CONTEXTS

Line 1091: fnd_descr_flex_contexts cont

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
1095: col.enabled_flag = 'Y' and

Line 1103: fnd_descr_flex_contexts cont2

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
1107: col2.enabled_flag = 'Y' and

Line 1119: fnd_descr_flex_contexts cont

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
1123: col.enabled_flag = 'Y' and

Line 1137: FROM fnd_descr_flex_contexts cont

1133: g_desc_flex_conflict := 0;
1134: BEGIN
1135: SELECT cont.descriptive_flex_context_code
1136: INTO l_opm_context
1137: FROM fnd_descr_flex_contexts cont
1138: WHERE cont.application_id = 551 and
1139: cont.descriptive_flexfield_name = 'ITEM_FLEX' and
1140: cont.enabled_flag = 'Y' and
1141: cont.global_flag = 'N' and

Line 1151: FROM fnd_descr_flex_contexts cont

1147: END;
1148: BEGIN
1149: SELECT cont.descriptive_flex_context_code
1150: INTO l_odm_context
1151: FROM fnd_descr_flex_contexts cont
1152: WHERE cont.application_id = 401 and
1153: cont.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and
1154: cont.enabled_flag = 'Y' and
1155: cont.global_flag = 'N' and

Line 1783: fnd_descr_flex_contexts cont2

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
1787: col2.enabled_flag = 'Y' and