APPS.WSH_MDC_SRS dependencies on WSH_LOCATIONS

Line 1557: l_from_clause := l_from_clause || ', WSH_LOCATIONS WL';

1553: END IF;
1554:
1555: IF p_sel_del_attr.ulti_ship_to_zip_from IS NOT NULL OR p_sel_del_attr.ulti_ship_to_zip_to IS NOT NULL
1556: THEN
1557: l_from_clause := l_from_clause || ', WSH_LOCATIONS WL';
1558: l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID = WL.WSH_LOCATION_ID';
1559: END IF;
1560:
1561: IF p_sel_del_attr.ulti_ship_to_zip_from IS NOT NULL

Line 1829: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.convert_internal_cust_location',WSH_DEBUG_SV.C_PROC_LEVEL);

1825:
1826: l_int_loc := FALSE;
1827:
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.convert_internal_cust_location',WSH_DEBUG_SV.C_PROC_LEVEL);
1830: END IF;
1831:
1832: WSH_LOCATIONS_PKG.convert_internal_cust_location(
1833: p_internal_cust_location_id => l_deconsol_output_tab(i).deconsol_location,

Line 1832: WSH_LOCATIONS_PKG.convert_internal_cust_location(

1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.convert_internal_cust_location',WSH_DEBUG_SV.C_PROC_LEVEL);
1830: END IF;
1831:
1832: WSH_LOCATIONS_PKG.convert_internal_cust_location(
1833: p_internal_cust_location_id => l_deconsol_output_tab(i).deconsol_location,
1834: x_internal_org_location_id => l_dummy_loc,
1835: x_return_status => l_return_status);
1836:

Line 2023: FROM WSH_LOCATIONS

2019: l_debug_on BOOLEAN;
2020:
2021: CURSOR Get_Loc_Details( c_location_id NUMBER) IS
2022: SELECT COUNTRY, STATE, CITY, POSTAL_CODE
2023: FROM WSH_LOCATIONS
2024: WHERE WSH_LOCATION_ID = c_location_id;
2025:
2026: CURSOR Check_Zone_Location
2027: ( c_zone_region_id NUMBER,