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.CSP_SCH_INT_PVT dependencies on WSH_LOCATIONS_REGIONS_V

Line 2914: from WSH_LOCATIONS_REGIONS_V wlr, WSH_ZONE_REGIONS_V wzr

2910: where hao.organization_id = c_from_org_id
2911: and ism.from_location_id = hao.location_id
2912: and ism.destination_type ='R'
2913: and ism.to_region_id IN(select wlr.REGION_ID
2914: from WSH_LOCATIONS_REGIONS_V wlr, WSH_ZONE_REGIONS_V wzr
2915: where wlr.location_id = c_to_location_id
2916: and wzr.REGION_ID(+) = wlr.region_id)*/
2917: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
2918: ism.intransit_time,ism.from_location_id,ism.to_location_id,ism.destination_type

Line 2930: MTL_INTERORG_SHIP_METHODS ISM1,HR_ALL_ORGANIZATION_UNITS hao,WSH_LOCATIONS_REGIONS_V wlr1

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
2933: and ism1.destination_type ='R')))
2934: UNION ALL

Line 2942: from WSH_LOCATIONS_REGIONS_V wlr, WSH_ZONE_REGIONS_V wzr

2938: where hao.organization_id = c_from_org_id
2939: and ism.from_location_id = hao.location_id
2940: and ism.destination_type ='Z'
2941: and ism.to_region_id IN(select wzr.zone_id
2942: from WSH_LOCATIONS_REGIONS_V wlr, WSH_ZONE_REGIONS_V wzr
2943: where wlr.location_id = c_to_location_id
2944: and wzr.REGION_ID(+) = wlr.region_id);
2945:
2946: