DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on WSH_PICKING_BATCHES

Line 456: FROM wsh_picking_batches

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

Line 463: FROM wsh_picking_batches

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