DBA Data[Home] [Help]

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: