APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_HISTORY

Line 5944: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist

5940:
5941: -- check if this task is saved in the repair history
5942: SELECT COUNT(*)
5943: INTO l_check_task
5944: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist
5945: WHERE tsk.source_object_id = hist.repair_line_id
5946: AND hist.paramn1 = p_task_id
5947: AND tsk.source_object_type_code = 'DR'
5948: AND hist.event_code = 'TC';

Line 6203: FROM CSD_REPAIR_HISTORY hist

6199: hist.paramc3, -- tsk.owner
6200: null paramc4, -- tsk.assignee_type
6201: null paramc5, -- tsk.assignee_name
6202: hist.paramc6 -- tsk.task_status
6203: FROM CSD_REPAIR_HISTORY hist
6204: WHERE hist.paramn1 = p_task_id
6205: AND hist.repair_line_id = p_repair_line_id
6206: --and hist.event_code = 'TC'
6207: ORDER BY hist.repair_history_id DESC;

Line 6238: CSD_REPAIR_HISTORY hist

6234: -- check if this task creation / update is saved in the repair history
6235: SELECT COUNT(*)
6236: INTO l_check_id
6237: FROM CSD_REPAIR_TASKS_V tsk,
6238: CSD_REPAIR_HISTORY hist
6239: WHERE tsk.source_object_id = p_repair_line_id
6240: AND hist.paramn1 = p_task_id
6241: AND tsk.task_id = hist.paramn1
6242: AND tsk.source_object_id = hist.repair_line_id

Line 6537: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist

6533:
6534: -- check if this task is saved in the repair history
6535: SELECT COUNT(*)
6536: INTO l_check_task
6537: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist
6538: WHERE tsk.source_object_id = hist.repair_line_id
6539: AND hist.paramn1 = p_task_activity_rec.task_id
6540: AND tsk.source_object_type_code = 'DR'
6541: AND hist.event_code = 'TC';

Line 6798: FROM CSD_REPAIR_HISTORY hist

6794: hist.paramc6, -- task status/null (TAC)
6795: hist.paramn3, -- task owner id/assignee isd (TAC)
6796: hist.paramn5, --status id/null (TAC)
6797: hist.paramn6 -- tsk.assignee_id (TAC)
6798: FROM CSD_REPAIR_HISTORY hist
6799: WHERE hist.paramn1 = p_task_id
6800: AND hist.repair_line_id = p_repair_line_id
6801: --and hist.event_code = 'TC'
6802: ORDER BY hist.repair_history_id DESC;