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.MSD_DEM_COLLECT_HISTORY_DATA dependencies on DUAL

Line 540: execute immediate 'select fnd_profile.value' || XDBLINK ||'(''MSC_SUBINVENTORY_PART_CONDITION'') from dual'

536: x_add_where_clause := x_add_where_clause || ' AND nvl(ooha.order_source_id, 0) <> 10 ';
537: ELSIF (p_collect_ISO = G_YES) THEN -- BUG#13716734 --kkhatri--12.3--BUG#14683310 --kkhatri--12.2.1
538:
539: MSD_DEM_COMMON_UTILITIES.GET_DBLINK(ERRBUF,RETCODE,P_SR_INSTANCE_ID,XDBLINK);
540: execute immediate 'select fnd_profile.value' || XDBLINK ||'(''MSC_SUBINVENTORY_PART_CONDITION'') from dual'
541: into x_profile_val;
542:
543: IF (x_profile_val is not null) THEN
544: x_add_where_clause := x_add_where_clause

Line 712: execute immediate 'select fnd_profile.value' || XDBLINK ||'(''MSC_SUBINVENTORY_PART_CONDITION'') from dual'

708: x_add_where_clause := x_add_where_clause || ' AND decode(ool.to_whse, NULL, 10, 0) <> 10 ';
709: -- BUG#13716734 kkhatri 12.3 BUG#14683310 --kkhatri --12.2.1
710: ELSIF (p_collect_ISO = G_YES) THEN
711: MSD_DEM_COMMON_UTILITIES.GET_DBLINK(ERRBUF,RETCODE,P_SR_INSTANCE_ID,XDBLINK);
712: execute immediate 'select fnd_profile.value' || XDBLINK ||'(''MSC_SUBINVENTORY_PART_CONDITION'') from dual'
713: into x_profile_val;
714:
715: IF (x_profile_val is not null) THEN
716:

Line 844: FROM dual

840:
841: CURSOR c_check_new_items
842: IS
843: SELECT 1
844: FROM dual
845: WHERE EXISTS (SELECT 1
846: FROM msd_dem_new_items
847: WHERE sr_instance_id = p_sr_instance_id
848: AND process_flag = 2);

Line 2056: utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';

2052:
2053: l_schema_name := trim(l_schema_name);
2054: l_sql := null;
2055: l_sql := 'SELECT
2056: utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema='|| replace(l_schema_name, ' ', '%20') ||'&sync=no'') FROM dual';
2057:
2058: msd_dem_common_utilities.log_debug (l_sql);
2059: execute immediate l_sql into ret_process_id;
2060: msd_dem_common_utilities.log_message(' workflow process_id - ' || ret_process_id);