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 476: ' wsh_regions_v wrv ' ||

472:
473: l_sql_stmt := ' select wrv.zone ' ||
474: ' from wsh_region_locations wrl, ' ||
475: ' wsh_zone_regions wzr, ' ||
476: ' wsh_regions_v wrv ' ||
477: ' where wrl.location_id = ''' || p_location_id || '''' ||
478: ' and wrl.region_id = wzr.region_id ' ||
479: ' and wzr.parent_region_id = wrv.region_id ' ||
480: ' and wrv.region_type = 10 ' ||

Line 509: wsh_regions_v wrv

505: cursor c1 is
506: select wrv.region_id
507: from wsh_region_locations wrl,
508: wsh_zone_regions wzr,
509: wsh_regions_v wrv
510: where wrl.location_id = p_location_id
511: and wrl.region_id = wzr.region_id
512: and wzr.parent_region_id = wrv.region_id
513: and wrv.region_type = 10