DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on CSD_REPAIR_TASKS_V

Line 9386: from csd_repair_tasks_v tsk

9382: CURSOR c_updated_tasks( p_repair_line_id in number ) is
9383: select tsk.task_id
9384: ,rep.repair_line_id
9385: --,max(hist.repair_history_id) repair_history_id
9386: from csd_repair_tasks_v tsk
9387: ,csd_repair_history hist
9388: ,csd_repairs rep
9389: where rep.repair_line_id = tsk.source_object_id
9390: and tsk.source_object_id = hist.repair_line_id

Line 9414: from CSD_REPAIR_TASKS_V tsk

9410: tsk.actual_end_date, -- hist.paramd3
9411: tsk.last_update_date, -- hist.paramd4
9412: hist.paramc3, -- tsk.owner
9413: hist.paramc6 -- tsk.task_status
9414: from CSD_REPAIR_TASKS_V tsk
9415: ,csd_repair_history hist
9416: where tsk.source_object_type_code = 'DR'
9417: and tsk.task_id = l_task_id
9418: and tsk.source_object_id = l_repair_line_id