DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on WSH_PICKING_BATCHES

Line 457: FROM wsh_picking_batches

453: ELSIF (p_batch_id IS NOT NULL) THEN
454: -- Query and cache the value based on p_batch_id
455: SELECT *
456: INTO wpb_rec
457: FROM wsh_picking_batches
458: WHERE batch_id = p_batch_id;
459: RETURN TRUE;
460: ELSIF (p_request_number IS NOT NULL) THEN
461: -- Query and cache the value based on p_request_number

Line 464: FROM wsh_picking_batches

460: ELSIF (p_request_number IS NOT NULL) THEN
461: -- Query and cache the value based on p_request_number
462: SELECT *
463: INTO wpb_rec
464: FROM wsh_picking_batches
465: WHERE name = p_request_number;
466: RETURN TRUE;
467: ELSE
468: -- Should not reach this condition