The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*)
from
ak_objects ao,
ak_object_attributes aoa
where
ao.database_object_name = db_obj_name and
aoa.database_object_name = db_obj_name and
((ao.defaulting_api_pkg is not null and
ao.defaulting_api_proc is not null)
or
(ao.validation_api_pkg is not null and
ao.validation_api_proc is not null)
or
(aoa.defaulting_api_pkg is not null and
aoa.defaulting_api_proc is not null)
or
(aoa.validation_api_pkg is not null and
aoa.validation_api_proc is not null));
select count(*), max(ar.database_object_name)
from
ak_regions ar,
ak_region_items ari
where
ar.region_application_id = db_reg_id and
ar.region_code = db_reg_code and
ari.region_application_id = db_reg_id and
ari.region_code = db_reg_code and
((ar.region_defaulting_api_pkg is not null and
ar.region_defaulting_api_proc is not null)
or
(ar.region_validation_api_pkg is not null and
ar.region_validation_api_proc is not null)
or
(ari.region_defaulting_api_pkg is not null and
ari.region_defaulting_api_proc is not null)
or
(ari.region_validation_api_pkg is not null and
ari.region_validation_api_proc is not null));
select aa.attribute_application_id,
aa.attribute_code,
aa.data_type,
aa.attribute_value_length
from ak_object_attributes aoa,
ak_attributes aa
where aoa.database_object_name = db_obj_name and
aoa.attribute_application_id = aa.attribute_application_id and
aoa.attribute_code = aa.attribute_code
union all
select aa.attribute_application_id,
aa.attribute_code,
aa.data_type,
aa.attribute_value_length
from ak_region_items ari,
ak_attributes aa
where ari.region_application_id = db_reg_id and
ari.region_code = db_reg_code and
ari.attribute_application_id = aa.attribute_application_id and
ari.attribute_code = aa.attribute_code and
upper(ari.object_attribute_flag) = 'N';