APPS.WMS_ATF_DEST_LOCATOR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

,  p_mode                in  number -- 1. Selection  2. Validation
,  p_task_id             in  number -- MMTT.transaction_temp_id
,  p_activity_type_id    in  number -- 1. Inbound   2. Outbound
,  p_hook_call_id	 in  number -- Seeded/Custom API call hook id in the wms_api_hook_calls.
,  p_locator_id          in  number -- Locator_id for Validation pruposes.
,  p_item_id             in  number -- Item ID for Validation purposes.
,  p_api_version         in  number
,  p_init_msg_list       in  varchar2
,  p_commit              in  varchar2
)
is

l_debug  			number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line: 86

select wahe.current_package_cntr, wahc.effective_to_date
from   wms_api_hook_calls wahc, wms_api_hooked_entities wahe
where  wahe.module_hook_id = wahc.module_hook_id
-- Restricts the output to "Locator Selection/Validation" only
and    wahe.short_name_id = 1
and    wahc.hook_call_id = p_hook_call_id;