APPS.WMS_TASK_MGMT_PUB dependencies on WMS_SAVED_QUERIES

Line 5177: , p_query_name IN WMS_SAVED_QUERIES.QUERY_NAME%TYPE

5173: provided by the user.
5174:
5175: PROCEDURE query_task (
5176: p_transaction_number IN NUMBER DEFAULT NULL
5177: , p_query_name IN WMS_SAVED_QUERIES.QUERY_NAME%TYPE
5178: , x_task_tab OUT NOCOPY WMS_TASKS_PUB.TASK_TABLE
5179: , x_return_status OUT NOCOPY VARCHAR2
5180: , x_msg_count OUT NOCOPY NUMBER
5181: , x_msg_data OUT NOCOPY VARCHAR2 );

Line 6179: FROM wms_saved_queries

6175: SELECT REPLACE(field_name,'FIND_TASKS.','') field_name,
6176: decode(field_value,'Y','T','N','F',field_value) field_value
6177: BULK COLLECT
6178: INTO l_query_tab
6179: FROM wms_saved_queries
6180: WHERE query_name = p_query_name
6181: ORDER BY 1;
6182: EXCEPTION
6183: WHEN OTHERS THEN

Line 6283: FROM wms_saved_queries

6279: --- Derive organization_id
6280: BEGIN
6281: SELECT DISTINCT organization_id
6282: INTO l_organization_id
6283: FROM wms_saved_queries
6284: WHERE query_name = p_query_name;
6285: EXCEPTION
6286: WHEN OTHERS THEN
6287: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');