APPS.WMS_TASK_MGMT_PUB dependencies on WMS_SAVED_QUERIES

Line 5266: , p_query_name IN WMS_SAVED_QUERIES.QUERY_NAME%TYPE

5262: provided by the user.
5263:
5264: PROCEDURE query_task (
5265: p_transaction_number IN NUMBER DEFAULT NULL
5266: , p_query_name IN WMS_SAVED_QUERIES.QUERY_NAME%TYPE
5267: , x_task_tab OUT NOCOPY WMS_TASKS_PUB.TASK_TABLE
5268: , x_return_status OUT NOCOPY VARCHAR2
5269: , x_msg_count OUT NOCOPY NUMBER
5270: , x_msg_data OUT NOCOPY VARCHAR2 );

Line 6274: FROM wms_saved_queries

6270: SELECT REPLACE(field_name,'FIND_TASKS.','') field_name,
6271: decode(field_value,'Y','T','N','F',field_value) field_value
6272: BULK COLLECT
6273: INTO l_query_tab
6274: FROM wms_saved_queries
6275: WHERE query_name = p_query_name
6276: ORDER BY 1;
6277: EXCEPTION
6278: WHEN OTHERS THEN

Line 6378: FROM wms_saved_queries

6374: --- Derive organization_id
6375: BEGIN
6376: SELECT DISTINCT organization_id
6377: INTO l_organization_id
6378: FROM wms_saved_queries
6379: WHERE query_name = p_query_name;
6380: EXCEPTION
6381: WHEN OTHERS THEN
6382: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');