DBA Data[Home] [Help]

APPS.EGO_TEMPL_ATTRS_PUB dependencies on EGO_FND_DF_COL_USGS_EXT

Line 147: EGO_FND_DF_COL_USGS_EXT EXT,

143: --ITA.attribute_name, --Bug8558929
144: Decode (ITA.attribute_name,'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE','MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE', ITA.attribute_name) AS attribute_name, --Bug8558929
145: ITA.attribute_value
146: FROM
147: EGO_FND_DF_COL_USGS_EXT EXT,
148: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT,
149: MTL_ITEM_TEMPL_ATTRIBUTES ITA
150: WHERE
151: EXT.descriptive_flex_context_code = FL_CTX_EXT.descriptive_flex_context_code and

Line 232: ego_fnd_df_col_usgs_ext ext,

228: CURSOR c_check_template_attribute(cp_template_id NUMBER
229: ,cp_attribute_name VARCHAR2) IS
230: SELECT 1
231: FROM fnd_descr_flex_column_usages fl_col ,
232: ego_fnd_df_col_usgs_ext ext,
233: ego_templ_attributes eta
234: WHERE ext.application_id = fl_col.application_id
235: AND ext.descriptive_flexfield_name = fl_col.descriptive_flexfield_name
236: AND ext.descriptive_flex_context_code = fl_col.descriptive_flex_context_code

Line 381: ego_fnd_df_col_usgs_ext ext,

377: CURSOR c_check_template_attribute(cp_template_id NUMBER
378: ,cp_attribute_name VARCHAR2) IS
379: SELECT 1
380: FROM fnd_descr_flex_column_usages fl_col ,
381: ego_fnd_df_col_usgs_ext ext,
382: ego_templ_attributes eta
383: WHERE ext.application_id = fl_col.application_id
384: AND ext.descriptive_flexfield_name = fl_col.descriptive_flexfield_name
385: AND ext.descriptive_flex_context_code = fl_col.descriptive_flex_context_code