APPS.WMS_CONTAINER2_PUB dependencies on MTL_SERIAL_NUMBERS

Line 70: FROM MTL_SERIAL_NUMBERS

66: SELECT 'Check for empty LPN'
67: FROM DUAL
68: WHERE EXISTS
69: (SELECT 'Serialized items'
70: FROM MTL_SERIAL_NUMBERS
71: WHERE lpn_id = p_lpn_id);
72:
73: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
74: BEGIN

Line 129: /* Check MTL_SERIAL_NUMBERS table for any serialized item(s) stored within the LPN */

125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127: CLOSE c_lpn_contents;
128:
129: /* Check MTL_SERIAL_NUMBERS table for any serialized item(s) stored within the LPN */
130: OPEN c_lpn_serial_contents;
131: FETCH c_lpn_serial_contents INTO l_lpn_serial_contents_exist;
132: IF c_lpn_serial_contents%FOUND THEN
133: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_NON_EMPTY_LPN');

Line 259: FROM MTL_SERIAL_NUMBERS

255: -- Bug# 1546081
256: -- SELECT *
257: SELECT inventory_item_id, current_organization_id, lpn_id,
258: revision, lot_number, serial_number, cost_group_id
259: FROM MTL_SERIAL_NUMBERS
260: WHERE lpn_id = l_current_lpn;
261: l_container_content_rec WMS_CONTAINER_PUB.WMS_Container_Content_Rec_Type;
262: l_temp_uom_code VARCHAR2(3);
263:

Line 572: UPDATE MTL_SERIAL_NUMBERS

568: UPDATE WMS_LPN_CONTENTS
569: SET parent_lpn_id = p_lpn_id_dest
570: WHERE parent_lpn_id = p_lpn_id_source;
571:
572: UPDATE MTL_SERIAL_NUMBERS
573: SET lpn_id = p_lpn_id_dest
574: WHERE lpn_id = p_lpn_id_source;
575:
576: -- End of API body