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 DUAL

Line 55: ' select cast(null as varchar2(100)) level_name from dual where 1=2';

51: msc_phub_util.log('msc_demantra_pkg.create_item_hierarchy_view');
52: if (g_demantra_schema is null) then
53: l_sql :=
54: ' create or replace view '||l_apps_schema||'.msc_dmtra_item_hies_v as'||
55: ' select cast(null as varchar2(100)) level_name from dual where 1=2';
56: else
57: l_sql :=
58: ' create or replace view '||l_apps_schema||'.msc_dmtra_item_hies_v as'||
59: ' select table_label level_name from ('||

Line 193: ' '||list_result('select '''||g_demantra_schema||'.''||gtable from ('||l_sql||') where gtable is not null', ', ')||' dual'||LF||

189: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
190: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
191: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
192: ' from'||LF||
193: ' '||list_result('select '''||g_demantra_schema||'.''||gtable from ('||l_sql||') where gtable is not null', ', ')||' dual'||LF||
194: ' where'||LF||
195: ' '||list_result('select gtable||''.''||id_field2||''=''||gtable2||''.''||id_field2 from ('||l_sql||') where gtable2 is not null', ' and '||LF)||
196: ' t_ep_item.ebs_item_dest_key is not null';
197:

Line 441: select msc_hub_query_s.nextval into l_qid_wf from dual;

437: msc_phub_util.log('(g_demantra_schema is null)');
438: return;
439: end if;
440:
441: select msc_hub_query_s.nextval into l_qid_wf from dual;
442: l_sql :=
443: ' insert into msc_hub_query ('||LF||
444: ' query_id, number1, clob1,'||LF||
445: ' created_by, creation_date,'||LF||

Line 473: ' (select 4 fact_type, ''apps.msc_phub_pkg.archive_demantra_ods'' proc_name from dual'||LF||

469: ' (select /*+ ordered */ distinct m.fact_type, c.computed_name, c.computed_title, c.int_aggr_func'||LF||
470: ' from'||LF||
471: ' (select /*+ ordered */ distinct b.fact_type, q.id'||LF||
472: ' from'||LF||
473: ' (select 4 fact_type, ''apps.msc_phub_pkg.archive_demantra_ods'' proc_name from dual'||LF||
474: ' union select 5 fact_type, ''apps.msc_phub_pkg.archive_demantra_plan'' proc_name from dual'||LF||
475: ' ) b,'||LF||
476: ' (select extract(f.column_value, ''/PROCEDURE'') s'||LF||
477: ' from msc_hub_query t, xmltable(''/WORKFLOW/STOREDPROCEDURESTEP/PROCEDURE'' PASSING xmltype(t.clob1)) f'||LF||

Line 474: ' union select 5 fact_type, ''apps.msc_phub_pkg.archive_demantra_plan'' proc_name from dual'||LF||

470: ' from'||LF||
471: ' (select /*+ ordered */ distinct b.fact_type, q.id'||LF||
472: ' from'||LF||
473: ' (select 4 fact_type, ''apps.msc_phub_pkg.archive_demantra_ods'' proc_name from dual'||LF||
474: ' union select 5 fact_type, ''apps.msc_phub_pkg.archive_demantra_plan'' proc_name from dual'||LF||
475: ' ) b,'||LF||
476: ' (select extract(f.column_value, ''/PROCEDURE'') s'||LF||
477: ' from msc_hub_query t, xmltable(''/WORKFLOW/STOREDPROCEDURESTEP/PROCEDURE'' PASSING xmltype(t.clob1)) f'||LF||
478: ' where t.query_id='||l_qid_wf||LF||

Line 728: ' select ''LEVEL1'' column_name, ''t_ep_item_EP_ID'' id_field from dual'||LF||

724: l_sql_debug varchar2(16384);
725: l_sql varchar2(16384);
726: begin
727: l_sql_debug :=
728: ' select ''LEVEL1'' column_name, ''t_ep_item_EP_ID'' id_field from dual'||LF||
729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||
730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||

Line 729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||

725: l_sql varchar2(16384);
726: begin
727: l_sql_debug :=
728: ' select ''LEVEL1'' column_name, ''t_ep_item_EP_ID'' id_field from dual'||LF||
729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||
730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||

Line 730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||

726: begin
727: l_sql_debug :=
728: ' select ''LEVEL1'' column_name, ''t_ep_item_EP_ID'' id_field from dual'||LF||
729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||
730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||
734: ' union select ''SDATE'', null from dual'||LF||

Line 731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||

727: l_sql_debug :=
728: ' select ''LEVEL1'' column_name, ''t_ep_item_EP_ID'' id_field from dual'||LF||
729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||
730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||
734: ' union select ''SDATE'', null from dual'||LF||
735: ' union select ''RECORD_TYPE'', null from dual';

Line 732: ' union select ''DKEY_ITEM'', null from dual'||LF||

728: ' select ''LEVEL1'' column_name, ''t_ep_item_EP_ID'' id_field from dual'||LF||
729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||
730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||
734: ' union select ''SDATE'', null from dual'||LF||
735: ' union select ''RECORD_TYPE'', null from dual';
736:

Line 733: ' union select ''DKEY_SITE'', null from dual'||LF||

729: ' union select ''LEVEL2'', ''t_ep_ebs_demand_class_EP_ID'' from dual'||LF||
730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||
734: ' union select ''SDATE'', null from dual'||LF||
735: ' union select ''RECORD_TYPE'', null from dual';
736:
737: l_sql :=

Line 734: ' union select ''SDATE'', null from dual'||LF||

730: ' union select ''LEVEL3'', ''t_ep_organization_EP_ID'' from dual'||LF||
731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||
734: ' union select ''SDATE'', null from dual'||LF||
735: ' union select ''RECORD_TYPE'', null from dual';
736:
737: l_sql :=
738: ' select v.column_name, d.id_field'||LF||

Line 735: ' union select ''RECORD_TYPE'', null from dual';

731: ' union select ''LEVEL4'', ''t_ep_site_EP_ID'' from dual'||LF||
732: ' union select ''DKEY_ITEM'', null from dual'||LF||
733: ' union select ''DKEY_SITE'', null from dual'||LF||
734: ' union select ''SDATE'', null from dual'||LF||
735: ' union select ''RECORD_TYPE'', null from dual';
736:
737: l_sql :=
738: ' select v.column_name, d.id_field'||LF||
739: ' from'||LF||