APPS.WSH_DELIVERY_DETAILS_GRP dependencies on MTL_SERIAL_NUMBERS

Line 7510: FROM mtl_serial_numbers

7506: -- end bug 4766908
7507: l_trx_type_id NUMBER;
7508: CURSOR get_group_mark_id (v_serial_number IN VARCHAR2, v_item_id IN NUMBER) IS
7509: SELECT group_mark_id
7510: FROM mtl_serial_numbers
7511: WHERE serial_number = v_serial_number
7512: AND inventory_item_id = v_item_id;
7513: --
7514: l_debug_on BOOLEAN;

Line 8995: INSERT INTO mtl_serial_numbers_temp

8991: IF l_debug_on THEN
8992: WSH_DEBUG_SV.logmsg(l_module_name, 'Inserting record into msnt');
8993: END IF;
8994:
8995: INSERT INTO mtl_serial_numbers_temp
8996: (
8997: transaction_temp_id, last_update_date,
8998: last_updated_by, creation_date,
8999: created_by, last_update_login, request_id,

Line 9802: FROM mtl_serial_numbers_temp msnt

9798: IS
9799:
9800: cursor c_serial_qty(p_transaction_temp_id number) is
9801: SELECT sum(nvl(msnt.serial_prefix, 0)) serial_qty
9802: FROM mtl_serial_numbers_temp msnt
9803: WHERE msnt.transaction_temp_id = p_transaction_temp_id
9804: GROUP BY msnt.transaction_temp_id;
9805:
9806: l_serial_qty c_serial_qty%ROWTYPE;