The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
transaction_id,
primary_quantity,
primary_unit_of_measure,
unit_of_measure,
source_doc_unit_of_measure,
transaction_type,
shipment_line_id,
po_line_location_id,
parent_transaction_id
FROM
rcv_transactions
START WITH transaction_id = c_transaction_id
CONNECT BY parent_transaction_id = PRIOR transaction_id;
SELECT item_id INTO X_item_id
FROM rcv_shipment_lines
WHERE shipment_line_id = v_shipment_line_id;
SELECT transaction_type INTO v_parent_type
FROM rcv_transactions
WHERE transaction_id = v_parent_id;
SELECT transaction_type INTO v_parent_type
FROM rcv_transactions
WHERE transaction_id = v_parent_id;
SELECT transaction_type INTO v_parent_type
FROM rcv_transactions
WHERE transaction_id = v_parent_id;
SELECT transaction_type,parent_transaction_id
INTO v_parent_type,grand_parent_id
FROM rcv_transactions
WHERE transaction_id = v_parent_id;
SELECT transaction_type INTO grand_parent_type
FROM rcv_transactions
WHERE transaction_id = grand_parent_id;
SELECT lpn_id into isLPN
FROM rcv_transactions rt
WHERE shipment_line_id = p_rcv_shipment_line_id
AND transaction_type = 'RECEIVE';
SELECT lot_control_code, serial_number_control_code into isLot, isSerial
FROM mtl_system_items msi, rcv_shipment_lines rsl
WHERE msi.organization_id = rsl.to_organization_id
AND msi.inventory_item_id = rsl.item_id
AND rsl.shipment_line_id = p_rcv_shipment_line_id;
SELECT DISTINCT(ph.clm_document_number||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
FROM rcv_shipment_lines rsl, po_headers_all ph, po_releases_all pr
WHERE rsl.shipment_header_id= l_shipment_header_id
AND rsl.po_header_id = ph.po_header_id
AND rsl.po_release_id = pr.po_release_id
AND ph.type_lookup_code = 'BLANKET'
UNION ALL
SELECT DISTINCT ph.clm_document_number, ph.po_header_id, null
FROM rcv_shipment_lines rsl, po_headers_all ph
WHERE rsl.shipment_header_id= l_shipment_header_id
AND rsl.po_header_id = ph.po_header_id
AND ph.type_lookup_code = 'STANDARD';
SELECT DISTINCT ap.invoice_num,ap.invoice_id
FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
WHERE ap.invoice_id = al.invoice_id
AND al.rcv_transaction_id = rt.transaction_id
AND rt.shipment_header_id = l_shipment_header_id;
SELECT DISTINCT ap.invoice_num,ap.invoice_id
FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
WHERE ap.invoice_id = al.invoice_id
AND al.rcv_transaction_id = rt.transaction_id
AND rt.shipment_line_id = l_shipment_line_id;