APPS.WMS_WIP_INTEGRATION dependencies on MTL_GEN_OBJECT_ID_S
Line 1516: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1512: where serial_number = p_serial_number
1513: and inventory_item_id = l_item_id;
1514:
1515: if( l_object_id is null ) then 1516: select mtl_gen_object_id_s.nextval into l_object_id from dual; 1517: end if;
1518:
1519: UPDATE mtl_serial_numbers
1520: SET
Line 1645: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1641:
1642: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643:
1644: -- Lot number does not exist 1645: select mtl_gen_object_id_s.nextval into l_object_id from dual; 1646:
1647: INSERT INTO mtl_lot_numbers
1648: (INVENTORY_ITEM_ID
1649: ,ORGANIZATION_ID