DBA Data[Home] [Help]

APPS.ONT_OIP_COMMON dependencies on WSH_LOOKUPS

Line 227: FROM wsh_lookups

223: BEGIN
224:
225: SELECT meaning
226: INTO l_released_status_name
227: FROM wsh_lookups
228: WHERE lookup_type = 'PICK_STATUS'
229: AND lookup_code = 'I';
230:
231: EXCEPTION

Line 241: FROM wsh_lookups

237: -- bug 4267981
238: IF p_released_status = 'S' AND p_move_order_line_id is null THEN
239: SELECT meaning
240: INTO l_released_status_name
241: FROM wsh_lookups
242: WHERE lookup_type = 'PICK_STATUS'
243: AND lookup_code = 'K';
244: ELSE
245: SELECT meaning

Line 247: FROM wsh_lookups

243: AND lookup_code = 'K';
244: ELSE
245: SELECT meaning
246: INTO l_released_status_name
247: FROM wsh_lookups
248: WHERE lookup_type = 'PICK_STATUS'
249: AND lookup_code = p_released_status;
250: END IF;
251: EXCEPTION