APPS.MSD_SR_UTIL dependencies on WSH_REGIONS_V

Line 985: wsh_regions_v wrv

981: cursor c1 is
982: select wrv.region_id
983: from wsh_region_locations wrl,
984: wsh_zone_regions wzr,
985: wsh_regions_v wrv
986: where wrl.location_id = p_location_id
987: and wrl.region_id = wzr.region_id
988: and wzr.parent_region_id = wrv.region_id
989: and wrv.region_type = 10

Line 1400: ' wsh_regions_v wrv ' ||

1396:
1397: l_sql_stmt := ' select wrv.region_id ' ||
1398: ' from wsh_region_locations wrl, ' ||
1399: ' wsh_zone_regions wzr, ' ||
1400: ' wsh_regions_v wrv ' ||
1401: ' where wrl.location_id = ''' || p_location_id || '''' ||
1402: ' and wrl.region_id = wzr.region_id ' ||
1403: ' and wzr.parent_region_id = wrv.region_id ' ||
1404: ' and wrv.region_type = 10 ' ||

Line 1447: ' wsh_regions_v wrv ' ||

1443:
1444: l_sql_stmt := ' select wrv.zone ' ||
1445: ' from wsh_region_locations wrl, ' ||
1446: ' wsh_zone_regions wzr, ' ||
1447: ' wsh_regions_v wrv ' ||
1448: ' where wrl.location_id = ''' || p_location_id || '''' ||
1449: ' and wrl.region_id = wzr.region_id ' ||
1450: ' and wzr.parent_region_id = wrv.region_id ' ||
1451: ' and wrv.region_type = 10 ' ||

Line 1494: ' wsh_regions_v wrv ' ||

1490:
1491: l_sql_stmt := ' select wrv.region_id ' ||
1492: ' from wsh_region_locations wrl, ' ||
1493: ' wsh_zone_regions wzr, ' ||
1494: ' wsh_regions_v wrv ' ||
1495: ' where wrl.location_id = ''' || p_location_id || '''' ||
1496: ' and wrl.region_id = wzr.region_id ' ||
1497: ' and wzr.parent_region_id = wrv.region_id ' ||
1498: ' and wrv.region_type = 10 ' ||

Line 1541: ' wsh_regions_v wrv ' ||

1537:
1538: l_sql_stmt := ' select wrv.zone ' ||
1539: ' from wsh_region_locations wrl, ' ||
1540: ' wsh_zone_regions wzr, ' ||
1541: ' wsh_regions_v wrv ' ||
1542: ' where wrl.location_id = ''' || p_location_id || '''' ||
1543: ' and wrl.region_id = wzr.region_id ' ||
1544: ' and wzr.parent_region_id = wrv.region_id ' ||
1545: ' and wrv.region_type = 10 ' ||