APPS.CSD_ISUP_DEPOT_WF_PVT SQL Statements

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

Line: 29

SELECT cit.business_process_id
FROM cs_incidents_all_b ci,
	 cs_incident_types_b cit,
	 cs_business_processes cbp
where ci.incident_number = g_incident_number
	and ci.incident_type_id = cit.incident_type_id
	and cbp.business_process_id = cit.business_process_id
	and cbp.name  = 'Depot Repair';

Line: 146

SELECT REPAIR_MODE
FROM csd_repair_types_b
WHERE repair_type_id=p_repair_type_id;

Line: 153

SELECT cs.incident_id,
    cs.org_id,
    cs.inventory_item_id,
    cs.current_serial_number,
    cs.customer_product_id,
    cs.inv_organization_id,
    cs.customer_id,
    cs.bill_to_site_use_id,
    cs.account_id,
    cs.incident_date,
    cs.incident_severity_id,
    mtl.primary_uom_code,
    cit.business_process_id,
    cs.contract_id,
    cs.contract_service_id,
    cs.ship_to_site_use_id,
    cs.problem_code
FROM cs_incidents_all_b cs,
    mtl_system_items_b  mtl,
    cs_incident_types cit
WHERE
    cs.inventory_item_id = mtl.inventory_item_id AND
    cs.inv_organization_id = mtl.organization_id AND
    cs.INCIDENT_NUMBER = p_incident_number		 AND
    cs.incident_type_id = cit.incident_type_id;

Line: 182

SELECT sr.cont_email,
       ro.repair_number,
       ro.serial_number,
       ro.item,
       decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
FROM csd_incidents_v sr,
     csd_repairs_v ro
WHERE ro.incident_id  = sr.incident_id
AND ro.repair_line_id = p_repair_line_id;

Line: 193

SELECT wr.name
FROM wf_roles wr,
     cs_incidents_v sr,
     csd_repairs    ro
WHERE ro.repair_line_id = p_repair_line_id
AND ro.incident_id = sr.incident_id
AND wr.orig_system_id = sr.contact_party_id
AND wr.orig_system = 'HZ_PARTY'
AND nvl(wr.expiration_date,sysdate) >= sysdate
AND wr.status = 'ACTIVE';

Line: 207

SELECT prod_txn_status,
	  order_number
FROM csd_product_txns_v
WHERE repair_line_id = p_repair_line_id
AND action_type='RMA';

Line: 245

		SELECT instance_id
		INTO l_customer_product_id
		FROM csi_item_instances
		WHERE inventory_item_id = l_inventory_item_id
			AND serial_number = l_current_serial_number
			AND sysdate BETWEEN trunc(NVL(active_start_date, sysdate -1)) AND
				trunc(NVL(active_end_date,sysdate+1));

Line: 356

SELECT nvl(auto_process_rma,'N')
INTO l_auto_process_rma
FROM csd_repair_types_vl
WHERE repair_type_id = l_repair_type_id;