APPS.CSD_DEPOT_REPAIR_CNTR dependencies on CSD_REPAIR_HISTORY

Line 190: FROM csd_Repair_history crh,

186: AND rcvt.source_document_code = 'RMA'
187: And rcvt.organization_id = hou.organization_id
188: AND rcvt.transaction_id NOT IN
189: (SELECT paramn1
190: FROM csd_Repair_history crh,
191: csd_repairs cra
192: WHERE crh.repair_line_id = cra.repair_line_id
193: AND event_code='RR'
194: AND cra.repair_line_id = nvl(p_repair_line_id,cra.repair_line_id)) -- travi 020903 change

Line 1171: from csd_Repair_history

1167: and dd.source_line_id = ced.order_line_id
1168: and dd.released_status = 'C' -- travi 022002
1169: and dd.delivery_detail_id not in
1170: (select paramn1
1171: from csd_Repair_history
1172: where repair_line_id = cra.repair_line_id
1173: and event_code='PS')
1174: and mtlu.uom_code = dd.requested_quantity_uom
1175: and cra.repair_line_id = nvl(p_repair_line_id, cra.repair_line_id);

Line 1632: ,csd_repair_history hist

1628: select tsk.task_id
1629: ,rep.repair_line_id
1630: --,max(hist.repair_history_id) repair_history_id
1631: from csd_repair_tasks_v tsk
1632: ,csd_repair_history hist
1633: ,csd_repairs rep
1634: where rep.repair_line_id = tsk.source_object_id
1635: and tsk.source_object_id = hist.repair_line_id
1636: and tsk.task_id = hist.paramn1

Line 1660: ,csd_repair_history hist

1656: tsk.last_update_date, -- hist.paramd4
1657: hist.paramc3, -- tsk.owner
1658: hist.paramc6 -- tsk.task_status
1659: from CSD_REPAIR_TASKS_V tsk
1660: ,csd_repair_history hist
1661: where tsk.source_object_type_code = 'DR'
1662: and tsk.task_id = l_task_id
1663: and tsk.source_object_id = l_repair_line_id
1664: and hist.repair_history_id = l_rep_hist_id

Line 1705: from CSD_REPAIR_HISTORY hist2

1701: l_task_status := ''; -- tsk.task_status
1702:
1703: select max(hist2.repair_history_id)
1704: into l_rep_hist_id
1705: from CSD_REPAIR_HISTORY hist2
1706: where hist2.repair_line_id = R.repair_line_id
1707: and hist2.paramn1 = R.task_id;
1708:
1709: l_task_id := R.task_id;

Line 1870: csd_gen_utility_pvt.add('Inserted into CSD_REPAIR_HISTORY table '||to_char(v_total_records)||' Records');

1866: csd_gen_utility_pvt.add('Completed depot_update_task_hist with Success..');
1867: END IF;
1868:
1869: IF (g_debug > 0 ) THEN
1870: csd_gen_utility_pvt.add('Inserted into CSD_REPAIR_HISTORY table '||to_char(v_total_records)||' Records');
1871: END IF;
1872:
1873:
1874: -- travi check for call from tools