DBA Data[Home] [Help]

APPS.ICX_DATATEMPLATE_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 97: FND_DESCR_FLEX_COLUMN_USAGES FCU

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

Line 184: fnd_descr_flex_column_usages fcu

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

Line 240: fnd_descr_flex_column_usages fcu

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

Line 300: fnd_descr_flex_column_usages fcu

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

Line 409: fnd_descr_flex_column_usages fcu

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

Line 570: fnd_descr_flex_column_usages fcu

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

Line 620: fnd_descr_flex_column_usages fcu

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