APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CSI_ITEM_INSTANCES

Line 224: csi_item_instances csi

220: select cr.repair_number,cs.incident_number,cr.serial_number,csi.instance_number
221: bulk collect into l_repair_numbers,l_incident_numbers,l_serial_numbers,l_instance_numbers
222: from csd_repairs cr,
223: cs_incidents_all_b cs,
224: csi_item_instances csi
225: where cr.incident_id = cs.incident_id
226: and cr.repair_line_id in
227: (select * from table(cast(l_repair_line_ids as JTF_NUMBER_TABLE)))
228: and cr.customer_product_id = csi.instance_id(+);

Line 1981: from csi_item_instances

1977: -- if its Serial controlled. Check if the Instance already exists.
1978: begin
1979: select instance_id
1980: into l_instance_id
1981: from csi_item_instances
1982: where serial_number = p_repln_rec.serial_number
1983: and inventory_item_id = p_repln_rec.inventory_item_id;
1984: exception
1985: when no_data_found then

Line 2008: from csi_item_instances

2004: else
2005: begin
2006: select instance_id
2007: into l_instance_id
2008: from csi_item_instances
2009: where inventory_item_id = p_repln_rec.inventory_item_id
2010: and external_reference = p_external_reference;
2011: l_create_instance := false;
2012: update_external_reference(p_external_reference,

Line 2504: from csi_item_instances

2500: End if;
2501:
2502: select object_version_number
2503: into l_object_version_number
2504: from csi_item_instances
2505: where instance_id = p_instance_id;
2506:
2507: l_instance_rec.instance_id := p_instance_id;
2508: l_instance_rec.external_reference := p_external_reference;