APPS.CSD_ISUP_DEPOT_WF_PVT SQL Statements

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

Line: 28

SELECT cit.business_process_id
FROM cs_incidents_all_b ci,
	 cs_incident_types_b cit
where ci.incident_number = g_incident_number
	and ci.incident_type_id = cit.incident_type_id;

Line: 157

select REPAIR_MODE
from csd_repair_types_b
where repair_type_id=p_repair_type_id;

Line: 164

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
FROM cs_incidents_all_b cs,
    mtl_system_items_b  mtl
WHERE
    cs.inventory_item_id = mtl.inventory_item_id AND
    cs.inv_organization_id = mtl.organization_id AND
    cs.INCIDENT_NUMBER = p_incident_number;

Line: 186

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: 197

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: 211

select prod_txn_status,
	  order_number
from csd_product_txns_v
where repair_line_id = p_repair_line_id
	and action_type='RMA';