DBA Data[Home] [Help]

APPS.CSD_DEPOT_REPAIR_CNTR dependencies on CSD_REPAIR_TASKS_V

Line 1631: from csd_repair_tasks_v tsk

1627: CURSOR c_updated_tasks( p_repair_line_id number ) is
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

Line 1659: from CSD_REPAIR_TASKS_V tsk

1655: tsk.actual_end_date, -- hist.paramd3
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