DBA Data[Home] [Help]

APPS.MSC_DEMANTRA_PKG dependencies on DBA_TAB_COLUMNS

Line 228: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn

224:
225: merge into msc_apcc_custom_measures b
226: using
227: (select m.fact_type, f.column_name
228: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn
229: where m.fact_type in (4,5)
230: and syn.synonym_name='MSC_'||upper(m.entity_name)||'_F'
231: and f.owner=g_msc_schema
232: and f.column_name like 'ATTRIBUTE%'

Line 255: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn

251:
252: delete from msc_apcc_custom_measures b
253: where not exists
254: (select 1
255: from dba_tab_columns f, table(msc_phub_pkg.meta_info) m, user_synonyms syn
256: where m.fact_type in (4,5)
257: and syn.synonym_name='MSC_'||upper(m.entity_name)||'_F'
258: and f.owner=g_msc_schema
259: and f.column_name like 'ATTRIBUTE%'