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.WSH_MDC_SRS dependencies on WSH_ZONE_REGIONS

Line 1580: l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID IN (SELECT LOCATION_ID FROM WSH_REGION_LOCATIONS WHERE REGION_ID IN (SELECT REGION_ID FROM WSH_ZONE_REGIONS WHERE PARENT_REGION_ID = :p_zone_id))';

1576:
1577: IF p_sel_del_attr.ulti_ship_to_zone_id IS NOT NULL
1578: THEN
1579: WSH_UTIL_CORE.PrintMsg(' Ultimate ship to zone: '||p_sel_del_attr.ulti_ship_to_zone_id);
1580: l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID IN (SELECT LOCATION_ID FROM WSH_REGION_LOCATIONS WHERE REGION_ID IN (SELECT REGION_ID FROM WSH_ZONE_REGIONS WHERE PARENT_REGION_ID = :p_zone_id))';
1581: l_col_tab(l_col_count) := p_sel_del_attr.ulti_ship_to_zone_id;
1582: l_col_count := l_col_count+1;
1583: END IF;
1584:

Line 2034: FROM WSH_ZONE_REGIONS

2030: SELECT REGION_ID
2031: FROM WSH_REGION_LOCATIONS
2032: WHERE LOCATION_ID = c_location_id
2033: AND REGION_ID IN (SELECT REGION_ID
2034: FROM WSH_ZONE_REGIONS
2035: WHERE PARENT_REGION_ID = c_zone_region_id);
2036:
2037: BEGIN
2038: