The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE zone_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE locator_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE lot_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE serial_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE onhand_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;
SELECT default_status_id
INTO l_org_default_status_id
FROM mtl_parameters
WHERE organization_id = p_organization_id;
SELECT mms.status_code, mms.status_id
FROM mtl_material_statuses_vl mms
WHERE mms.onhand_control = 1
and mms.enabled_flag = 1
and mms.status_code like (p_status_code)
and not exists ( select 1 from mtl_status_transaction_control mstc
where mms.status_id = mstc.status_id
and mstc.is_allowed = 2
and mstc.transaction_type_id = p_trx_type_id )
order by mms.status_code;
SELECT mms.status_code, mms.status_id
FROM mtl_material_statuses_vl mms
WHERE mms.onhand_control = 1
and mms.enabled_flag = 1
and mms.status_code like (p_status_code)
order by mms.status_code;
SELECT mms.status_code, mms.status_id
FROM mtl_material_statuses_vl mms
WHERE mms.lot_control = 1
and mms.enabled_flag = 1
and mms.status_code like (p_status_code)
and not exists ( select 1 from mtl_status_transaction_control mstc
where mms.status_id = mstc.status_id
and mstc.is_allowed = 2
and mstc.transaction_type_id = p_trx_type_id )
order by mms.status_code;
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE lot_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;
SELECT mms.status_code, mms.status_id
FROM mtl_material_statuses_vl mms
WHERE mms.serial_control = 1
and mms.enabled_flag = 1
and mms.status_code like (p_status_code)
and not exists ( select 1 from mtl_status_transaction_control mstc
where mms.status_id = mstc.status_id
and mstc.is_allowed = 2
and mstc.transaction_type_id = p_trx_type_id )
order by mms.status_code;
SELECT status_code, status_id
FROM mtl_material_statuses_vl
WHERE serial_control = 1
and enabled_flag = 1
and status_code like (p_status_code)
order by status_code;