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_SR_UTIL dependencies on WSH_REGIONS_V

Line 500: ' wsh_regions_v wrv ' ||

496:
497: l_sql_stmt := ' select wrv.zone ' ||
498: ' from wsh_region_locations wrl, ' ||
499: ' wsh_zone_regions wzr, ' ||
500: ' wsh_regions_v wrv ' ||
501: ' where wrl.location_id = ''' || p_location_id || '''' ||
502: ' and wrl.region_id = wzr.region_id ' ||
503: ' and wzr.parent_region_id = wrv.region_id ' ||
504: ' and wrv.region_type = 10 ' ||

Line 533: wsh_regions_v wrv

529: cursor c1 is
530: select wrv.region_id
531: from wsh_region_locations wrl,
532: wsh_zone_regions wzr,
533: wsh_regions_v wrv
534: where wrl.location_id = p_location_id
535: and wrl.region_id = wzr.region_id
536: and wzr.parent_region_id = wrv.region_id
537: and wrv.region_type = 10