APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_TASKS_V

Line 6090: FROM CSD_REPAIR_TASKS_V tsk

6086: tsk.planned_start_date, -- hist.paramd1
6087: tsk.actual_start_date, -- hist.paramd2
6088: tsk.actual_end_date, -- hist.paramd3
6089: tsk.last_update_date -- hist.paramd4
6090: FROM CSD_REPAIR_TASKS_V tsk
6091: WHERE tsk.source_object_type_code = 'DR'
6092: AND tsk.source_object_id = p_repair_line_id
6093: AND tsk.task_id = p_task_id;
6094: BEGIN

Line 6099: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist

6095:
6096: -- check if this task is saved in the repair history
6097: SELECT COUNT(*)
6098: INTO l_check_task
6099: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist
6100: WHERE tsk.source_object_id = hist.repair_line_id
6101: AND hist.paramn1 = p_task_id
6102: AND tsk.source_object_type_code = 'DR'
6103: AND hist.event_code = 'TC';

Line 6380: FROM CSD_REPAIR_TASKS_V tsk

6376: tsk.planned_start_date, -- hist.paramd1
6377: tsk.actual_start_date, -- hist.paramd2
6378: tsk.actual_end_date, -- hist.paramd3
6379: tsk.last_update_date -- hist.paramd4
6380: FROM CSD_REPAIR_TASKS_V tsk
6381: WHERE tsk.source_object_type_code = 'DR'
6382: AND tsk.source_object_id = p_repair_line_id
6383: AND tsk.task_id = p_task_id;
6384:

Line 6392: FROM CSD_REPAIR_TASKS_V tsk,

6388: -- assignee_name --> null
6389: -- check if this task creation / update is saved in the repair history
6390: SELECT COUNT(*)
6391: INTO l_check_id
6392: FROM CSD_REPAIR_TASKS_V tsk,
6393: CSD_REPAIR_HISTORY hist
6394: WHERE tsk.source_object_id = p_repair_line_id
6395: AND hist.paramn1 = p_task_id
6396: AND tsk.task_id = hist.paramn1

Line 6663: FROM CSD_REPAIR_TASKS_V tsk

6659: tsk.actual_start_date, -- hist.paramd2
6660: tsk.actual_end_date, -- hist.paramd3
6661: tsk.last_update_date -- hist.paramd4
6662:
6663: FROM CSD_REPAIR_TASKS_V tsk
6664: WHERE tsk.source_object_type_code = 'DR'
6665: AND tsk.source_object_id = p_repair_line_id
6666: AND tsk.task_id = p_task_id;*/
6667:

Line 6682: FROM CSD_REPAIR_TASKS_V tsk

6678: tsk.planned_start_date, -- hist.paramd1
6679: tsk.actual_start_date, -- hist.paramd2
6680: tsk.actual_end_date, -- hist.paramd3
6681: tsk.last_update_date -- hist.paramd4
6682: FROM CSD_REPAIR_TASKS_V tsk
6683: WHERE tsk.source_object_type_code = 'DR'
6684: AND tsk.source_object_id = p_repair_line_id
6685: AND tsk.task_id = p_task_id;
6686:

Line 6692: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist

6688:
6689: -- check if this task is saved in the repair history
6690: SELECT COUNT(*)
6691: INTO l_check_task
6692: FROM CSD_REPAIR_TASKS_V tsk, CSD_REPAIR_HISTORY hist
6693: WHERE tsk.source_object_id = hist.repair_line_id
6694: AND hist.paramn1 = p_task_activity_rec.task_id
6695: AND tsk.source_object_type_code = 'DR'
6696: AND hist.event_code = 'TC';

Line 6973: FROM CSD_REPAIR_TASKS_V tsk

6969: tsk.planned_start_date, -- hist.paramd1
6970: tsk.actual_start_date, -- hist.paramd2
6971: tsk.actual_end_date, -- hist.paramd3
6972: tsk.last_update_date -- hist.paramd4
6973: FROM CSD_REPAIR_TASKS_V tsk
6974: WHERE tsk.source_object_type_code = 'DR'
6975: AND tsk.source_object_id = p_repair_line_id
6976: AND tsk.task_id = p_task_id;
6977: