DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on WSH_REGION_LOCATIONS_VL

Line 2924: from WSH_REGION_LOCATIONS_VL wlr, WSH_ZONE_REGIONS_V wzr

2920: where hao.organization_id = c_from_org_id
2921: and ism.from_location_id = hao.location_id
2922: and ism.destination_type ='R'
2923: and ism.to_region_id IN (select wlr.region_id
2924: from WSH_REGION_LOCATIONS_VL wlr, WSH_ZONE_REGIONS_V wzr
2925: where wlr.location_id = c_to_location_id
2926: and wzr.REGION_ID(+) = wlr.region_id
2927: and wlr.region_type = (select max(region_type)
2928: from WSH_REGION_LOCATIONS_VL wrl2

Line 2928: from WSH_REGION_LOCATIONS_VL wrl2

2924: from WSH_REGION_LOCATIONS_VL wlr, WSH_ZONE_REGIONS_V wzr
2925: where wlr.location_id = c_to_location_id
2926: and wzr.REGION_ID(+) = wlr.region_id
2927: and wlr.region_type = (select max(region_type)
2928: from WSH_REGION_LOCATIONS_VL wrl2
2929: where wrl2.region_id IN(SELECT ism1.to_region_id FROM
2930: MTL_INTERORG_SHIP_METHODS ISM1,HR_ALL_ORGANIZATION_UNITS hao,WSH_LOCATIONS_REGIONS_V wlr1
2931: where hao.organization_id = c_from_org_id
2932: and ism1.from_location_id = hao.location_id