APPS.MSD_SR_UTIL dependencies on WSH_REGIONS_V

Line 1053: wsh_regions_v wrv

1049: cursor c1 is
1050: select wrv.region_id
1051: from wsh_region_locations wrl,
1052: wsh_zone_regions wzr,
1053: wsh_regions_v wrv
1054: where wrl.location_id = p_location_id
1055: and wrl.region_id = wzr.region_id
1056: and wzr.parent_region_id = wrv.region_id
1057: and wrv.region_type = 10

Line 1475: ' wsh_regions_v wrv ' ||

1471:
1472: l_sql_stmt := ' select wrv.region_id ' ||
1473: ' from wsh_region_locations wrl, ' ||
1474: ' wsh_zone_regions wzr, ' ||
1475: ' wsh_regions_v wrv ' ||
1476: ' where wrl.location_id = ''' || p_location_id || '''' ||
1477: ' and wrl.region_id = wzr.region_id ' ||
1478: ' and wzr.parent_region_id = wrv.region_id ' ||
1479: ' and wrv.region_type = 10 ' ||

Line 1522: ' wsh_regions_v wrv ' ||

1518:
1519: l_sql_stmt := ' select wrv.zone ' ||
1520: ' from wsh_region_locations wrl, ' ||
1521: ' wsh_zone_regions wzr, ' ||
1522: ' wsh_regions_v wrv ' ||
1523: ' where wrl.location_id = ''' || p_location_id || '''' ||
1524: ' and wrl.region_id = wzr.region_id ' ||
1525: ' and wzr.parent_region_id = wrv.region_id ' ||
1526: ' and wrv.region_type = 10 ' ||

Line 1569: ' wsh_regions_v wrv ' ||

1565:
1566: l_sql_stmt := ' select wrv.region_id ' ||
1567: ' from wsh_region_locations wrl, ' ||
1568: ' wsh_zone_regions wzr, ' ||
1569: ' wsh_regions_v wrv ' ||
1570: ' where wrl.location_id = ''' || p_location_id || '''' ||
1571: ' and wrl.region_id = wzr.region_id ' ||
1572: ' and wzr.parent_region_id = wrv.region_id ' ||
1573: ' and wrv.region_type = 10 ' ||

Line 1616: ' wsh_regions_v wrv ' ||

1612:
1613: l_sql_stmt := ' select wrv.zone ' ||
1614: ' from wsh_region_locations wrl, ' ||
1615: ' wsh_zone_regions wzr, ' ||
1616: ' wsh_regions_v wrv ' ||
1617: ' where wrl.location_id = ''' || p_location_id || '''' ||
1618: ' and wrl.region_id = wzr.region_id ' ||
1619: ' and wzr.parent_region_id = wrv.region_id ' ||
1620: ' and wrv.region_type = 10 ' ||