APPS.WSH_MDC_SRS dependencies on WSH_REGION_LOCATIONS

Line 1550: l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID IN (SELECT LOCATION_ID FROM WSH_REGION_LOCATIONS WHERE REGION_ID = :p_region_id)';

1546:
1547: IF p_sel_del_attr.ulti_ship_to_region_id IS NOT NULL
1548: THEN
1549: WSH_UTIL_CORE.PrintMsg(' Ultimate Ship to Region: '||p_sel_del_attr.ulti_ship_to_region_id);
1550: l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID IN (SELECT LOCATION_ID FROM WSH_REGION_LOCATIONS WHERE REGION_ID = :p_region_id)';
1551: l_col_tab(l_col_count) := p_sel_del_attr.ulti_ship_to_region_id;
1552: l_col_count := l_col_count+1;
1553: END IF;
1554:

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 2031: FROM WSH_REGION_LOCATIONS

2027: ( c_zone_region_id NUMBER,
2028: c_location_id NUMBER)
2029: IS
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);