APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on MTL_PICK_SLIP_NUMBERS
Line 300: FROM mtl_pick_slip_numbers
296: l_pick_slip_number NUMBER;
297: --
298: CURSOR ps_list IS
299: SELECT pick_slip_number 300: FROM mtl_pick_slip_numbers 301: WHERE pick_slip_batch_id = WSH_PICK_LIST.G_BATCH_ID
302: AND status = 1;
303:
304: BEGIN
Line 481: DELETE FROM mtl_pick_slip_numbers
477: /*if nvl(p_batch_id, -1) = -1 then
478: p_batch_id := wsh_pick_list.g_batch_id;
479: end if; */
480: 481: DELETE FROM mtl_pick_slip_numbers 482: WHERE pick_slip_batch_id = p_batch_id;
483:
484: END delete_pick_slip_numbers;
485: