The following lines contain the word 'select', 'insert', 'update' or 'delete':
select problem_code,resolution_code,customer_product_id,inv_organization_id,
cp_component_id,cp_subcomponent_id,inventory_item_id,inv_component_id,
inv_component_version,inv_subcomponent_id,inv_subcomponent_version,
current_serial_number_nv,platform_id,platform_version_id,
status_code,incident_type,severity,urgency,owner,
company_name,account,customer_id,
customer_ticket_number,person_first_name, person_last_name,
incident_date,date_closed,
product_name,product_description,summary
from cs_incidents_v
where incident_id = l_incident_id;
SELECT problem_code,
resolution_code,
customer_product_id,
inv_organization_id,
cp_component_id,
cp_subcomponent_id,
inventory_item_id,
inv_component_id,
inv_component_version,
inv_subcomponent_id,
inv_subcomponent_version,
current_serial_number_nv,
platform_id,
platform_version_id,
status_code,
incident_type,
severity,
urgency,
customer_id,
customer_ticket_number,
incident_date,
date_closed,
SUMMARY
FROM
CS_SR_INCIDENTS_V
WHERE
incident_id = l_incident_id;
SELECT a.resource_name from cs_sr_owners_v a, cs_sr_incidents_v b
where a.resource_id = b.incident_owner_id
and b.incident_id = l_incident_id;
SELECT a.account_number from jtf_cust_accounts_all_v a, cs_sr_incidents_v b
where b.account_id = a.cust_account_id
and b.incident_id = l_incident_id;
SELECT a.sub_first_name, a.sub_last_name from csc_hz_parties_self_v a, cs_hz_sr_contact_points b,
cs_sr_incidents_v c
where b.incident_id = c.incident_id
and b.party_id = a.party_id
and b.primary_flag = 'Y'
and c.incident_id = l_incident_id ;
SELECT a.concatenated_segments, a.description from mtl_system_items_kfv a, cs_sr_incidents_v b
where a.inventory_item_id = b.inventory_item_id
and a.organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id
and b.incident_id = l_incident_id;
SELECT problem_code,
resolution_code,
customer_product_id,
inv_organization_id,
cp_component_id,
cp_subcomponent_id,
inventory_item_id,
inv_component_id,
inv_component_version,
inv_subcomponent_id,
inv_subcomponent_version,
current_serial_number_nv,
platform_id,
platform_version_id,
status_code,
incident_type,
severity,
urgency,
owner,
company_name,
account,
customer_id,
customer_ticket_number,
person_first_name,
person_last_name,
incident_date,
date_closed,
PRODUCT_NAME,
PRODUCT_DESCRIPTION,
SUMMARY
FROM
CS_NEW_INCIDENTS_V
WHERE
incident_id = l_incident_id;
select party_name
from jtf_parties_all_v
where party_id = l_customer_id;
select meaning
from cs_lookups
where lookup_type = 'REQUEST_PROBLEM_CODE'
and lookup_code = l_problem_code;
select meaning
from cs_lookups
where lookup_type = 'REQUEST_RESOLUTION_CODE'
and lookup_code = l_resolution_code;
select current_serial_number, system_name, platform,version
from cs_acc_cp_rg_v
where customer_product_id = l_customer_product_id;
select serial_number, system_name, platform,version
from cs_sr_new_acc_cp_rg_v
where instance_id = l_customer_product_id;
select product_name,substr(product_description,1,15),revision
from cs_acc_cp_rg_v
where config_parent_id = l_customer_product_id and
customer_product_id = l_component_id;
select product_name,substr(product_description,1,15),inventory_revision
from cs_sr_new_acc_cp_rg_v
where object_id = l_customer_product_id and
instance_id = l_component_id;
select product_name,product_description,revision
from cs_acc_cp_rg_v
where config_parent_id = l_component_id and
customer_product_id = l_subcomponent_id;
select product_name,product_description,inventory_revision
from cs_sr_new_acc_cp_rg_v
where object_id = l_component_id and
instance_id = l_subcomponent_id;
select name
from css_def_platforms
where platform_id = l_platform_id;
select version
from css_def_plat_versions
where platform_version_id = l_platform_version_id;
select concatenated_segments, sr_comp.description,revision
from cs_sr_inv_components_v sr_comp, mtl_item_revisions rev
where
sr_comp.component_id = rev.inventory_item_id and
sr_comp.organization_id = rev.organization_id and
sr_comp.inventory_item_id = l_inventory_item_id and
sr_comp.organization_id = l_mfg_org_id and
sr_comp.component_id = l_inv_component_id;
select concatenated_segments, sr_sub.description,revision
from cs_sr_inv_subcomponents_v sr_sub, mtl_item_revisions rev
where
sr_sub.component_id = rev.inventory_item_id and
sr_sub.organization_id = rev.organization_id and
sr_sub.component_id = l_inv_component_id and
sr_sub.organization_id = l_mfg_org_id and
sr_sub.subcomponent_id = l_inv_subcomponent_id;
select substr(cs_sr_log_pkg.sr_log(p_incident_id),1,27000) log from dual; */
select notes from jtf_notes_vl
where source_object_id = p_incident_id and
note_type = l_note_type and
jtf_note_id = (select max(jtf_note_id) from jtf_notes_vl
where source_object_id = p_incident_id
and note_type = l_note_type);
select incident.platform_version,item.concatenated_segments platform
from mtl_system_items_vl item,
mtl_item_categories ic,
cs_sr_incidents_v incident
where item.organization_id = fnd_profile.value('CS_INV_VALIDATION_ORG')
and item.serv_req_enabled_code = 'E'
and item.organization_id = ic.organization_id
and item.inventory_item_id = ic.inventory_item_id
and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')
and item.inventory_item_id = incident.platform_id
and item.inventory_item_id = l_platform_id
and incident.incident_id = l_incident_id ;