eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_DEMANTRA_PKG dependencies on MSC_APCC_CUSTOM_MEASURES

Line 225: merge into msc_apcc_custom_measures b

221: is
222: begin
223: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table');
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)

Line 249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);

245: fnd_global.user_id, sysdate,
246: sysdate, fnd_global.user_id, fnd_global.login_id,
247: fnd_global.conc_program_id, fnd_global.conc_login_id,
248: fnd_global.prog_appl_id, fnd_global.conc_request_id);
249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);
250: commit;
251:
252: delete from msc_apcc_custom_measures b
253: where not exists

Line 252: delete from msc_apcc_custom_measures b

248: fnd_global.prog_appl_id, fnd_global.conc_request_id);
249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);
250: commit;
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)

Line 264: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: delete from msc_apcc_custom_measures: '||sql%rowcount);

260: and f.owner=syn.table_owner
261: and f.table_name=syn.table_name
262: and f.column_name=b.column_name
263: and m.fact_type=b.fact_type);
264: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: delete from msc_apcc_custom_measures: '||sql%rowcount);
265: commit;
266:
267: msc_phub_util.log(fnd_message.get_string('MSC','MSC_APCC_DM_R01'));
268:

Line 465: ' from msc_apcc_custom_measures'||LF||

461: ' nvl(b.source_column_name, v.computed_name) computed_name,'||LF||
462: ' v.computed_title, v.int_aggr_func'||LF||
463: ' from'||LF||
464: ' (select fact_type, source_column_name'||LF||
465: ' from msc_apcc_custom_measures'||LF||
466: ' where source_column_name is not null'||LF||
467: ' ) b'||LF||
468: ' full outer join'||LF||
469: ' (select /*+ ordered */ distinct m.fact_type, c.computed_name, c.computed_title, c.int_aggr_func'||LF||

Line 504: update msc_apcc_custom_measures

500:
501: msc_phub_util.log('('||l_fact_type||','||','||l_op||','||l_source_column_name||','||l_column_title||','||l_aggregation_method||')');
502: begin
503: case when l_op='D' then
504: update msc_apcc_custom_measures
505: set source_column_name=null,
506: column_title=null,
507: aggregation_method=null,
508: last_update_date=sysdate,

Line 520: from msc_apcc_custom_measures

516: commit;
517:
518: when l_op='I' then
519: select column_name into l_column_name
520: from msc_apcc_custom_measures
521: where fact_type=l_fact_type and source_column_name is null and rownum=1
522: order by to_number(substr(column_name,10));
523:
524: update msc_apcc_custom_measures

Line 524: update msc_apcc_custom_measures

520: from msc_apcc_custom_measures
521: where fact_type=l_fact_type and source_column_name is null and rownum=1
522: order by to_number(substr(column_name,10));
523:
524: update msc_apcc_custom_measures
525: set source_column_name=l_source_column_name,
526: column_title=l_column_title,
527: aggregation_method=l_aggregation_method,
528: last_update_date=sysdate,

Line 539: update msc_apcc_custom_measures

535: where fact_type=l_fact_type and column_name=l_column_name;
536: commit;
537:
538: when l_op='U' then
539: update msc_apcc_custom_measures
540: set last_update_date=sysdate,
541: last_updated_by=fnd_global.user_id,
542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,

Line 567: from msc_apcc_custom_measures f, table(msc_phub_pkg.meta_info) m

563: select
564: '00' lang_id,
565: g_msg_num_prefix2||upper(m.entity_name)||'_'||substr(to_char(substr(f.column_name,10),'09'),2) msg_num,
566: f.column_title msg_text
567: from msc_apcc_custom_measures f, table(msc_phub_pkg.meta_info) m
568: where f.fact_type=m.fact_type
569: and f.source_column_name is not null
570: order by to_number(substr(f.column_name,10));
571: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: insert into msc_translated_message: '||sql%rowcount);

Line 686: ' msc_apcc_custom_measures c,'||LF||

682: ' union all'||LF||
683: ' select c.source_column_name, nvl(c.aggregation_method, ''sum''), c.column_name,'||LF||
684: ' decode(c.source_column_name, null, null, ''t.''||c.source_column_name) formula'||LF||
685: ' from'||LF||
686: ' msc_apcc_custom_measures c,'||LF||
687: ' all_tab_columns v'||LF||
688: ' where v.table_name='''||source_table(p_publisher)||''''||LF||
689: ' and v.owner='''||g_demantra_schema||''''||LF||
690: ' and v.column_name=upper(c.source_column_name)'||LF||

Line 701: ' from msc_apcc_custom_measures'||LF||

697: ' from table(msc_demantra_pkg.seeded_measure_mapping)'||LF||
698: ' where fact_type='||p_fact_type||LF||
699: ' union all'||LF||
700: ' select column_name, nvl(aggregation_method, ''sum'')'||LF||
701: ' from msc_apcc_custom_measures'||LF||
702: ' where fact_type='||p_fact_type;
703:
704: case when p_list_type=1 then
705: l_sql := 'select distinct aggregation_method||''(''||'''||p_prefix||'.''||source_column_name||'') ''||source_column_name s from ('||l_sql||') where source_column_name is not null';