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_ZONE_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 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 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: