DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on WSH_REGION_LOCATIONS

Line 5879: wsh_region_locations wlr,

5875: function get_city_code(p_location_id NUMBER) return VARCHAR2 IS
5876: Cursor city_code is
5877: select nvl(wr.city_code, wr.city) from
5878: wsh_locations wsh,
5879: wsh_region_locations wlr,
5880: wsh_regions_v wr
5881: where wsh.wsh_location_id = p_location_id
5882: and wsh.wsh_location_id = wlr.location_id
5883: and wlr.region_type = 2 -- city