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: