272: jtsb.closed_flag,
273: cdh.travel_start_time, --FOR TRAVEL LINES
274: cdh.travel_end_time, ciab.system_id system_id
275: from
276: JTF_TASK_STATUSES_B jtsb,
277: CSF_DEBRIEF_HEADERS cdh,
278: JTF_TASKS_B jtb,
279: JTF_TASK_ASSIGNMENTS jta,
280: cs_incidents_all_b ciab
301: jtsb.closed_flag,
302: cdh.travel_start_time, --FOR TRAVEL LINES
303: cdh.travel_end_time, to_number(null) system_id
304: from
305: JTF_TASK_STATUSES_B jtsb,
306: CSF_DEBRIEF_HEADERS cdh,
307: JTF_TASKS_B jtb,
308: JTF_TASK_ASSIGNMENTS jta,
309: csd_repairs cr
331: jtsb.closed_flag,
332: cdh.travel_start_time, --FOR TRAVEL LINES
333: cdh.travel_end_time, ciab.system_id system_id
334: from
335: JTF_TASK_STATUSES_B jtsb,
336: CSF_DEBRIEF_HEADERS cdh,
337: JTF_TASKS_B jtb,
338: JTF_TASK_ASSIGNMENTS jta,
339: cs_incidents_all_b ciab
362: jtsb.closed_flag,
363: cdh.travel_start_time, --FOR TRAVEL LINES
364: cdh.travel_end_time, to_number(null) system_id
365: from
366: JTF_TASK_STATUSES_B jtsb,
367: CSF_DEBRIEF_HEADERS cdh,
368: JTF_TASKS_B jtb,
369: JTF_TASK_ASSIGNMENTS jta,
370: csd_repairs cr