DBA Data[Home] [Help]

APPS.CS_SR_FUL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 119

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;
Line: 137

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;
Line: 166

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;
Line: 171

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;
Line: 176

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 ;
Line: 184

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;
Line: 194

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;
Line: 232

   select party_name
   from jtf_parties_all_v
   where party_id = l_customer_id;
Line: 238

	select meaning
	from cs_lookups
	where lookup_type = 'REQUEST_PROBLEM_CODE'
	and lookup_code = l_problem_code;
Line: 244

	select meaning
	from cs_lookups
	where lookup_type = 'REQUEST_RESOLUTION_CODE'
	and lookup_code = l_resolution_code;
Line: 250

  select current_serial_number, system_name, platform,version
   from cs_acc_cp_rg_v
   where customer_product_id = l_customer_product_id;
Line: 256

  select serial_number, system_name, platform,version
   from cs_sr_new_acc_cp_rg_v
   where instance_id = l_customer_product_id;
Line: 261

    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;
Line: 268

    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;
Line: 274

    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;
Line: 281

    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;
Line: 291

     select name
     from css_def_platforms
     where platform_id = l_platform_id;
Line: 296

		select version
   		from css_def_plat_versions
   		where platform_version_id = l_platform_version_id;
Line: 303

	   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;
Line: 314

	   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;
Line: 327

select substr(cs_sr_log_pkg.sr_log(p_incident_id),1,27000) log from dual; */
Line: 330

       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);
Line: 340

       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 ;