93: fcu.flex_value_set_id,
94: EFDFCE.data_type
95: FROM
96: EGO_FND_DF_COL_USGS_EXT EFDFCE,
97: FND_DESCR_FLEX_COLUMN_USAGES FCU
98: WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
99: AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE = P_ATTR_GROUP
100: AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
101: AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
180: efdfce.application_column_name
181: into l_attr_grp_id, l_col_name
182: FROM ego_fnd_dsc_flx_ctx_ext ag,
183: ego_fnd_df_col_usgs_ext efdfce,
184: fnd_descr_flex_column_usages fcu
185: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
186: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
187: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
188: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
236: efdfce.application_column_name
237: into l_attr_grp_id, l_col_name
238: FROM ego_fnd_dsc_flx_ctx_ext ag,
239: ego_fnd_df_col_usgs_ext efdfce,
240: fnd_descr_flex_column_usages fcu
241: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
242: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
243: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
244: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
296: efdfce.application_column_name
297: into l_attr_grp_id, l_col_name
298: FROM ego_fnd_dsc_flx_ctx_ext ag,
299: ego_fnd_df_col_usgs_ext efdfce,
300: fnd_descr_flex_column_usages fcu
301: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
302: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
303: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
304: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
405: efdfce.application_column_name as appl_col_name,
406: fcu.end_user_column_name as end_user_col_name
407: FROM ego_fnd_dsc_flx_ctx_ext ag,
408: ego_fnd_df_col_usgs_ext efdfce,
409: fnd_descr_flex_column_usages fcu
410: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
411: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
412: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
413: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
566: (ORDER BY efdfce.application_column_name) cols
567: INTO l_attr_group_id, l_col_names
568: FROM ego_fnd_dsc_flx_ctx_ext ag,
569: ego_fnd_df_col_usgs_ext efdfce,
570: fnd_descr_flex_column_usages fcu
571: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
572: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
573: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
574: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
616: efdfce.application_column_name
617: INTO l_attr_grp_id, l_col_name
618: FROM ego_fnd_dsc_flx_ctx_ext ag,
619: ego_fnd_df_col_usgs_ext efdfce,
620: fnd_descr_flex_column_usages fcu
621: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
622: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
623: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
624: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name