DBA Data[Home] [Help]

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on EGO_FND_DF_COL_USGS_EXT

Line 271: ego_fnd_df_col_usgs_ext efdfce,

267: SELECT ag.attr_group_id,
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

Line 328: ego_fnd_df_col_usgs_ext efdfce,

324: SELECT ag.attr_group_id,
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

Line 413: EGO_FND_DF_COL_USGS_EXT EFDFCE,

409: FCU.END_USER_COLUMN_NAME,
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

Line 478: EGO_FND_DF_COL_USGS_EXT EFDFCE ,

474: FCU.END_USER_COLUMN_NAME,
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

Line 551: EGO_FND_DF_COL_USGS_EXT EFDFCE

547: FCU.END_USER_COLUMN_NAME,
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

Line 647: ego_fnd_df_col_usgs_ext efdfce,

643: efdfce.application_column_name
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

Line 2500: ego_fnd_df_col_usgs_ext efdfce,

2496: decode(upper(fcu.end_user_column_name),upper('addressdtlsxml'),efdfce.application_column_name,null) addressxml,
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