APPS.WMS_ZONES_PVT dependencies on WMS_ZONES_VL

Line 1003: || ' and inventory_location_id not in (select inventory_location_id from wms_zone_locators wzl, wms_zones_vl wz where

999:
1000:
1001: l_where_str :=
1002: l_where_str
1003: || ' and inventory_location_id not in (select inventory_location_id from wms_zone_locators wzl, wms_zones_vl wz where
1004: wz.zone_id=wzl.zone_id and wz.zone_type=''L'') ';
1005:
1006: end if;
1007:

Line 1978: FROM WMS_ZONES_VL

1974: l_module_name CONSTANT VARCHAR2(30) := 'LOCK_ROW';
1975:
1976: CURSOR C1 IS
1977: SELECT *
1978: FROM WMS_ZONES_VL
1979: WHERE ZONE_ID = P_ZONE_ID
1980: FOR UPDATE OF ZONE_ID NOWAIT;
1981:
1982: rec1 C1%ROWTYPE;

Line 2312: FROM wms_zones_vl

2308: WHERE organization_id = p_organization_id;
2309:
2310: CURSOR c_zone_name IS
2311: SELECT 1
2312: FROM wms_zones_vl
2313: WHERE zone_name = p_zone_name
2314: AND organization_id = p_organization_id;
2315:
2316: BEGIN