APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CS_INCIDENTS_ALL_B

Line 223: cs_incidents_all_b cs,

219: if l_repair_line_ids.count > 0 then
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)))

Line 1629: from cs_incidents_all_b

1625: -- user has passed incident id. Lets check if it exists in the system.
1626: begin
1627: select 'X'
1628: into l_dummy
1629: from cs_incidents_all_b
1630: where incident_number = l_interface_tbl(i).sr_incident_id;
1631: l_sr_tbl(i).sr_incident_id := l_interface_tbl(i).sr_incident_id;
1632: l_sr_tbl(i).create_sr_flag := 'N';
1633: exception

Line 2040: from cs_incidents_all_b

2036: g_bill_to_use_id,
2037: g_problem_code,
2038: g_severity_id,
2039: g_contract_service_id
2040: from cs_incidents_all_b
2041: where incident_id = x_incident_id;
2042: end if;
2043:
2044: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2214: from cs_incidents_all_b

2210: g_bill_to_use_id,
2211: g_problem_code,
2212: g_severity_id,
2213: g_contract_service_id
2214: from cs_incidents_all_b
2215: where incident_id = x_incident_id;
2216: end if;
2217: -- get the default repair type applying the defaulting rule.
2218: l_rule_input_rec.sr_customer_id := p_sr_rec.sr_party_id;