DBA Data[Home] [Help]

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 272: fnd_descr_flex_column_usages fcu

268: efdfce.application_column_name
269: into l_attr_grp_id, l_col_name
270: FROM ego_fnd_dsc_flx_ctx_ext ag,
271: ego_fnd_df_col_usgs_ext efdfce,
272: fnd_descr_flex_column_usages fcu
273: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
274: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
275: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
276: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name

Line 329: fnd_descr_flex_column_usages fcu

325: efdfce.application_column_name
326: into l_attr_grp_id, l_col_name
327: FROM ego_fnd_dsc_flx_ctx_ext ag,
328: ego_fnd_df_col_usgs_ext efdfce,
329: fnd_descr_flex_column_usages fcu
330: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
331: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
332: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
333: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name

Line 414: FND_DESCR_FLEX_COLUMN_USAGES FCU

410: fcu.flex_value_set_id,
411: EFDFCE.data_type
412: FROM
413: EGO_FND_DF_COL_USGS_EXT EFDFCE,
414: FND_DESCR_FLEX_COLUMN_USAGES FCU
415: WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
416: AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE = P_ATTR_GROUP
417: AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
418: AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME

Line 479: FND_DESCR_FLEX_COLUMN_USAGES FCU

475: fcu.flex_value_set_id,
476: EFDFCE.data_type
477: FROM
478: EGO_FND_DF_COL_USGS_EXT EFDFCE ,
479: FND_DESCR_FLEX_COLUMN_USAGES FCU
480: WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
481: AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE = P_ATTR_GROUP
482: AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
483: AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME

Line 552: , FND_DESCR_FLEX_COLUMN_USAGES FCU

548: fcu.flex_value_set_id,
549: EFDFCE.data_type
550: FROM
551: EGO_FND_DF_COL_USGS_EXT EFDFCE
552: , FND_DESCR_FLEX_COLUMN_USAGES FCU
553: WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
554: AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE = P_ATTR_GROUP
555: AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
556: AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME

Line 648: fnd_descr_flex_column_usages fcu

644: into l_attr_grp_id, l_col_name
645:
646: FROM ego_fnd_dsc_flx_ctx_ext ag,
647: ego_fnd_df_col_usgs_ext efdfce,
648: fnd_descr_flex_column_usages fcu
649:
650: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
651: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
652: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code

Line 2501: fnd_descr_flex_column_usages fcu

2497: decode(upper(fcu.end_user_column_name),upper('addresstype'),efdfce.application_column_name,null) addresstype,
2498: decode(upper(fcu.end_user_column_name),upper('contactdtlsxml'),efdfce.application_column_name,null) contacts
2499: FROM ego_fnd_dsc_flx_ctx_ext ag,
2500: ego_fnd_df_col_usgs_ext efdfce,
2501: fnd_descr_flex_column_usages fcu
2502: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
2503: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
2504: and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
2505: and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name