The following lines contain the word 'select', 'insert', 'update' or 'delete':
select rct.transaction_date,
rsh.shipment_num,
rsl.quantity_received,
rsl.unit_of_measure
into x_transaction_date,
x_shipment_number,
x_quantity_received,
x_receiving_unit_of_measure
from rcv_transactions rct,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl
where transaction_id = p_last_receipt_transaction_id
and rct.shipment_header_id = rsh.shipment_header_id
and rct.shipment_line_id = rsl.shipment_line_id ;
select sum(quantity_received)
into x_quantity_received
from rcv_shipment_lines rsl
where rsl.shipment_header_id=(select rct.shipment_header_id
from rcv_transactions rct where
transaction_id = p_last_receipt_transaction_id)
and rsl.item_id = p_item_id;
select uom_code
into x_receiving_uom_code
FROM mtl_units_of_measure
WHERE unit_of_measure = X_receiving_unit_of_measure ;
select uom_code
into x_purchasing_uom_code
FROM mtl_units_of_measure
WHERE unit_of_measure = p_purchasing_unit_of_measure ;
SELECT *
INTO bucket_rec
FROM chv_horizontal_schedules
WHERE schedule_id = p_schedule_id
AND schedule_item_id = p_schedule_item_id
AND row_select_order = 1 ;
SELECT *
INTO start_date_rec
FROM chv_horiz_date_schedules_v
WHERE schedule_id = p_schedule_id
AND schedule_item_id = p_schedule_item_id
AND row_select_order = 2 ;
SELECT *
INTO end_date_rec
FROM chv_horiz_date_schedules_v
WHERE schedule_id = p_schedule_id
AND schedule_item_id = p_schedule_item_id
AND row_select_order = 7 ;
SELECT poatt.using_organization_id
INTO x_organization_id
FROM po_asl_attributes_val_v poatt
WHERE poatt.using_organization_id = p_organization_id
AND poatt.vendor_id = p_vendor_id
AND poatt.vendor_site_id = p_vendor_site_id
AND poatt.item_id = p_item_id;
select max(rct.transaction_id)
into x_last_receipt_id
from rcv_transactions rct,
rcv_shipment_lines rsl,
po_headers poh
where rct.shipment_line_id = rsl.shipment_line_id
and rct.transaction_type = 'RECEIVE'
and rct.transaction_date between
to_date(x_cum_period_start_date,'YYYY/MM/DD') and
to_date(x_cum_period_end_date,'YYYY/MM/DD')
and rsl.to_organization_id = x_organization_id
and rsl.item_id = x_item_id
and rsl.po_header_id = poh.po_header_id
and poh.vendor_id = x_vendor_id
and poh.vendor_site_id = x_vendor_site_id
and poh.supply_agreement_flag = 'Y'
and rct.transaction_date in
(select max(rct2.transaction_date)
from rcv_transactions rct2,
rcv_shipment_lines rsl2,
po_headers poh2
where rct2.shipment_line_id = rsl2.shipment_line_id
and rct2.transaction_type = 'RECEIVE'
and rct2.transaction_date between
to_date(x_cum_period_start_date,'YYYY/MM/DD') and
to_date(x_cum_period_end_date,'YYYY/MM/DD')
and rsl2.to_organization_id = x_organization_id
and rsl2.item_id = x_item_id
and rsl2.po_header_id = poh.po_header_id
and poh2.vendor_id = x_vendor_id
and poh2.vendor_site_id = x_vendor_site_id
and poh2.supply_agreement_flag = 'Y');
SELECT displayed_field
INTO x_bucket_type_dsp
FROM po_lookup_codes
WHERE lookup_type = 'SCHEDULE_BUCKET_TYPE'
AND lookup_code = p_bucket_type_code ;