155: fcu.flex_value_set_id,
156: EFDFCE.data_type
157: FROM
158: EGO_FND_DF_COL_USGS_EXT EFDFCE,
159: FND_DESCR_FLEX_COLUMN_USAGES FCU
160: WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
161: AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE = P_ATTR_GROUP
162: AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
163: AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
255: efdfce.application_column_name
256: into l_attr_grp_id, l_col_name
257: FROM ego_fnd_dsc_flx_ctx_ext ag,
258: ego_fnd_df_col_usgs_ext efdfce,
259: fnd_descr_flex_column_usages fcu
260: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
261: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
262: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
263: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
312: efdfce.application_column_name
313: into l_attr_grp_id, l_col_name
314: FROM ego_fnd_dsc_flx_ctx_ext ag,
315: ego_fnd_df_col_usgs_ext efdfce,
316: fnd_descr_flex_column_usages fcu
317: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
318: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
319: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
320: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name