DBA Data[Home] [Help]

APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on MTL_PICK_SLIP_NUMBERS

Line 301: FROM mtl_pick_slip_numbers

297: l_pick_slip_number NUMBER;
298: --
299: CURSOR ps_list IS
300: SELECT pick_slip_number
301: FROM mtl_pick_slip_numbers
302: WHERE pick_slip_batch_id = WSH_PICK_LIST.G_BATCH_ID
303: AND status = 1;
304:
305: BEGIN

Line 482: DELETE FROM mtl_pick_slip_numbers

478: /*if nvl(p_batch_id, -1) = -1 then
479: p_batch_id := wsh_pick_list.g_batch_id;
480: end if; */
481:
482: DELETE FROM mtl_pick_slip_numbers
483: WHERE pick_slip_batch_id = p_batch_id;
484:
485: END delete_pick_slip_numbers;
486: