APPS.WSH_DELIVERY_DETAILS_GRP dependencies on MTL_SERIAL_NUMBERS

Line 7602: FROM mtl_serial_numbers

7598: -- end bug 4766908
7599: l_trx_type_id NUMBER;
7600: CURSOR get_group_mark_id (v_serial_number IN VARCHAR2, v_item_id IN NUMBER) IS
7601: SELECT group_mark_id
7602: FROM mtl_serial_numbers
7603: WHERE serial_number = v_serial_number
7604: AND inventory_item_id = v_item_id;
7605: --
7606: l_debug_on BOOLEAN;

Line 9114: INSERT INTO mtl_serial_numbers_temp

9110: IF l_debug_on THEN
9111: WSH_DEBUG_SV.logmsg(l_module_name, 'Inserting record into msnt');
9112: END IF;
9113:
9114: INSERT INTO mtl_serial_numbers_temp
9115: (
9116: transaction_temp_id, last_update_date,
9117: last_updated_by, creation_date,
9118: created_by, last_update_login, request_id,

Line 9922: FROM mtl_serial_numbers_temp msnt

9918: IS
9919:
9920: cursor c_serial_qty(p_transaction_temp_id number) is
9921: SELECT sum(nvl(msnt.serial_prefix, 0)) serial_qty
9922: FROM mtl_serial_numbers_temp msnt
9923: WHERE msnt.transaction_temp_id = p_transaction_temp_id
9924: GROUP BY msnt.transaction_temp_id;
9925:
9926: l_serial_qty c_serial_qty%ROWTYPE;