APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on JTF_TASKS_VL

Line 24: select jtf_tasks_vl.task_id, repair_line_id

20: error_process EXCEPTION;
21:
22: /*CURSOR get_repair_tasks(p_start_repair_line_id number, p_end_repair_line_id number)
23: IS
24: select jtf_tasks_vl.task_id, repair_line_id
25: from jtf_tasks_vl, csd_repairs
26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id

Line 25: from jtf_tasks_vl, csd_repairs

21:
22: /*CURSOR get_repair_tasks(p_start_repair_line_id number, p_end_repair_line_id number)
23: IS
24: select jtf_tasks_vl.task_id, repair_line_id
25: from jtf_tasks_vl, csd_repairs
26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id

Line 26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id

22: /*CURSOR get_repair_tasks(p_start_repair_line_id number, p_end_repair_line_id number)
23: IS
24: select jtf_tasks_vl.task_id, repair_line_id
25: from jtf_tasks_vl, csd_repairs
26: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks

Line 31: where csd_tasks.task_id = jtf_tasks_vl.task_id

27: and source_object_type_code='DR'
28: and repair_line_id between p_start_repair_line_id
29: and p_end_repair_line_id
30: and not exists( select 'x' from csd_tasks
31: where csd_tasks.task_id = jtf_tasks_vl.task_id
32: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);*/
33:
34: BEGIN
35: -- Get the Slab Number for the table

Line 66: jtf_tasks_vl.task_id,

62: LAST_UPDATE_DATE,
63: LAST_UPDATE_LOGIN
64: ) select
65: CSD.csd_tasks_s.nextval,
66: jtf_tasks_vl.task_id,
67: csd_repairs.repair_line_id,
68: 'N',
69: 1,
70: FND_GLOBAL.user_id,

Line 75: from jtf_tasks_vl,

71: SYSDATE,
72: FND_GLOBAL.user_id,
73: SYSDATE,
74: FND_GLOBAL.login_id
75: from jtf_tasks_vl,
76: CSD_REPAIRS
77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max

Line 77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id

73: SYSDATE,
74: FND_GLOBAL.login_id
75: from jtf_tasks_vl,
76: CSD_REPAIRS
77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id

Line 81: where csd_tasks.task_id = jtf_tasks_vl.task_id

77: where jtf_tasks_vl.source_object_id = csd_repairs.repair_line_id
78: and source_object_type_code='DR'
79: and repair_line_id between v_min and v_max
80: and not exists( select 'x' from csd_tasks
81: where csd_tasks.task_id = jtf_tasks_vl.task_id
82: and csd_tasks.repair_line_id = csd_repairs.repair_line_id);
83:
84:
85: COMMIT;