The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT msn.lot_number lot,
count(msn.lot_number) lot_qty
FROM mtl_object_genealogy mog,
mtl_material_transactions mmt,
mtl_serial_numbers msn
WHERE mog.object_id = msn.gen_object_id
AND msn.last_transaction_id = mmt.transaction_id
AND mog.end_date_active IS NULL
AND mog.parent_object_id = p_parentObjID
AND msn.inventory_item_id = p_componentID
AND msn.current_organization_id = p_orgID
AND mmt.operation_seq_num = p_opSeqNum
AND msn.lot_number IS NOT NULL
GROUP BY msn.lot_number;
SELECT msn.parent_serial_number parent_serial,
msn.serial_number serial
FROM mtl_object_genealogy mog,
mtl_material_transactions mmt,
mtl_serial_numbers msn
WHERE mog.object_id = msn.gen_object_id
AND msn.last_transaction_id = mmt.transaction_id
AND mog.end_date_active IS NULL
AND mog.parent_object_id = p_parentObjID
AND msn.inventory_item_id = p_componentID
AND msn.current_organization_id = p_orgID
AND mmt.operation_seq_num = p_opSeqNum
AND ((p_lotNumber IS NULL AND msn.lot_number IS NULL)
OR
(p_lotNumber IS NOT NULL AND msn.lot_number = p_lotNumber))
ORDER BY msn.serial_number;
SELECT mmt.revision revision
FROM mtl_object_genealogy mog,
mtl_material_transactions mmt,
mtl_serial_numbers msn
WHERE mog.object_id = msn.gen_object_id
AND msn.last_transaction_id = mmt.transaction_id
AND mog.end_date_active IS NULL
AND mog.parent_object_id = p_parentObjID
AND msn.inventory_item_id = p_item.inventory_item_id
AND msn.current_organization_id = p_orgID
AND mmt.operation_seq_num = p_item.operation_seq_num;