DBA Data[Home] [Help]

APPS.WMS_PICK_LOAD_UI dependencies on WMS_ITEM_LOCATIONS_KFV

Line 298: from wms_item_locations_kfv

294: IF (g_debug = 1) THEN
295: debug('130', 'wms_pick_load_ui.validate_locator_lpn.p_confirm_locator_hidden:' || p_confirm_locator_hidden);
296: END IF;
297: select concatenated_segments INTO l_locator_lpn
298: from wms_item_locations_kfv
299: where concatenated_segments = p_locator_lpn
300: and SUBINVENTORY_CODE = p_subinventory_code
301: and ORGANIZATION_ID = p_organization_id;
302: ELSE

Line 307: from wms_item_locations_kfv

303: IF (g_debug = 1) THEN
304: debug('131', 'wms_pick_load_ui.validate_locator_lpn.p_confirm_locator_hidden:' || p_confirm_locator_hidden);
305: END IF;
306: select concatenated_segments INTO l_locator_lpn
307: from wms_item_locations_kfv
308: where alias = p_locator_lpn
309: and SUBINVENTORY_CODE = p_subinventory_code
310: and ORGANIZATION_ID = p_organization_id;
311: END IF;