DBA Data[Home] [Help]

APPS.ONT_OIP_COMMON dependencies on WSH_LOOKUPS

Line 519: FROM wsh_lookups

515: BEGIN
516:
517: SELECT meaning
518: INTO l_released_status_name
519: FROM wsh_lookups
520: WHERE lookup_type = 'PICK_STATUS'
521: AND lookup_code = 'I';
522:
523: EXCEPTION

Line 533: FROM wsh_lookups

529: -- bug 4267981
530: IF p_released_status = 'S' AND p_move_order_line_id is null THEN
531: SELECT meaning
532: INTO l_released_status_name
533: FROM wsh_lookups
534: WHERE lookup_type = 'PICK_STATUS'
535: AND lookup_code = 'K';
536: ELSE
537: SELECT meaning

Line 539: FROM wsh_lookups

535: AND lookup_code = 'K';
536: ELSE
537: SELECT meaning
538: INTO l_released_status_name
539: FROM wsh_lookups
540: WHERE lookup_type = 'PICK_STATUS'
541: AND lookup_code = p_released_status;
542: END IF;
543: EXCEPTION