eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_TASKS_V

Line 5935: FROM CSD_REPAIR_TASKS_V tsk

5931: tsk.planned_start_date, -- hist.paramd1
5932: tsk.actual_start_date, -- hist.paramd2
5933: tsk.actual_end_date, -- hist.paramd3
5934: tsk.last_update_date -- hist.paramd4
5935: FROM CSD_REPAIR_TASKS_V tsk
5936: WHERE tsk.source_object_type_code = 'DR'
5937: AND tsk.source_object_id = p_repair_line_id
5938: AND tsk.task_id = p_task_id;
5939: BEGIN

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 6225: FROM CSD_REPAIR_TASKS_V tsk

6221: tsk.planned_start_date, -- hist.paramd1
6222: tsk.actual_start_date, -- hist.paramd2
6223: tsk.actual_end_date, -- hist.paramd3
6224: tsk.last_update_date -- hist.paramd4
6225: FROM CSD_REPAIR_TASKS_V tsk
6226: WHERE tsk.source_object_type_code = 'DR'
6227: AND tsk.source_object_id = p_repair_line_id
6228: AND tsk.task_id = p_task_id;
6229:

Line 6237: FROM CSD_REPAIR_TASKS_V tsk,

6233: -- assignee_name --> null
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

Line 6508: FROM CSD_REPAIR_TASKS_V tsk

6504: tsk.actual_start_date, -- hist.paramd2
6505: tsk.actual_end_date, -- hist.paramd3
6506: tsk.last_update_date -- hist.paramd4
6507:
6508: FROM CSD_REPAIR_TASKS_V tsk
6509: WHERE tsk.source_object_type_code = 'DR'
6510: AND tsk.source_object_id = p_repair_line_id
6511: AND tsk.task_id = p_task_id;*/
6512:

Line 6527: FROM CSD_REPAIR_TASKS_V tsk

6523: tsk.planned_start_date, -- hist.paramd1
6524: tsk.actual_start_date, -- hist.paramd2
6525: tsk.actual_end_date, -- hist.paramd3
6526: tsk.last_update_date -- hist.paramd4
6527: FROM CSD_REPAIR_TASKS_V tsk
6528: WHERE tsk.source_object_type_code = 'DR'
6529: AND tsk.source_object_id = p_repair_line_id
6530: AND tsk.task_id = p_task_id;
6531:

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 6818: FROM CSD_REPAIR_TASKS_V tsk

6814: tsk.planned_start_date, -- hist.paramd1
6815: tsk.actual_start_date, -- hist.paramd2
6816: tsk.actual_end_date, -- hist.paramd3
6817: tsk.last_update_date -- hist.paramd4
6818: FROM CSD_REPAIR_TASKS_V tsk
6819: WHERE tsk.source_object_type_code = 'DR'
6820: AND tsk.source_object_id = p_repair_line_id
6821: AND tsk.task_id = p_task_id;
6822: