eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 208: JTF_TASK_ASSIGNMENTS jta,

204: from
205: JTF_TASK_STATUSES_B jtsb,
206: CSF_DEBRIEF_HEADERS cdh,
207: JTF_TASKS_B jtb,
208: JTF_TASK_ASSIGNMENTS jta,
209: cs_incidents_all_b ciab
210: WHERE cdh.task_assignment_id = jta.task_assignment_id
211: and jta.task_id = jtb.task_id
212: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 235: JTF_TASK_ASSIGNMENTS jta,

231: from
232: JTF_TASK_STATUSES_B jtsb,
233: CSF_DEBRIEF_HEADERS cdh,
234: JTF_TASKS_B jtb,
235: JTF_TASK_ASSIGNMENTS jta,
236: csd_repairs cr
237: WHERE cdh.task_assignment_id = jta.task_assignment_id
238: and jta.task_id = jtb.task_id
239: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 263: JTF_TASK_ASSIGNMENTS jta,

259: from
260: JTF_TASK_STATUSES_B jtsb,
261: CSF_DEBRIEF_HEADERS cdh,
262: JTF_TASKS_B jtb,
263: JTF_TASK_ASSIGNMENTS jta,
264: cs_incidents_all_b ciab
265: WHERE cdh.task_assignment_id = jta.task_assignment_id
266: and jta.task_id = jtb.task_id
267: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 291: JTF_TASK_ASSIGNMENTS jta,

287: from
288: JTF_TASK_STATUSES_B jtsb,
289: CSF_DEBRIEF_HEADERS cdh,
290: JTF_TASKS_B jtb,
291: JTF_TASK_ASSIGNMENTS jta,
292: csd_repairs cr
293: WHERE cdh.task_assignment_id = jta.task_assignment_id
294: and jta.task_id = jtb.task_id
295: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 324: jtf_task_assignments jta,

320: jtsv.rejected_flag,
321: jtsv.completed_flag,
322: jtsv.closed_flag
323: from csf_debrief_tasks_v cdtv,
324: jtf_task_assignments jta,
325: jtf_task_statuses_vl jtsv
326: where cdtv.debrief_header_id = nvl(p_debrief_header_id, cdtv.debrief_header_id)
327: and cdtv.task_assignment_id = jta.task_assignment_id
328: and jta.assignment_status_id = jtsv.task_status_id

Line 1363: jtf_task_assignments jta,

1359: cdh.debrief_header_id,
1360: cdh.debrief_number,
1361: decode(processed_flag,'PENDING','P','E') debrief_status
1362: from csf_debrief_headers cdh,
1363: jtf_task_assignments jta,
1364: jtf_tasks_b jtb
1365: where processed_flag in ('PENDING','COMPLETED W/ERRORS')
1366: and jta.task_assignment_id = cdh.task_assignment_id
1367: and jtb.task_id = jta.task_id

Line 1378: jtf_task_assignments jta,

1374: cdh.debrief_number,
1375: decode(processed_flag,'PENDING','P','E') debrief_status
1376: from csd_repairs cr,
1377: jtf_tasks_b jtb,
1378: jtf_task_assignments jta,
1379: csf_debrief_headers cdh
1380: where jtb.source_object_id = cr.repair_line_id
1381: and jtb.source_object_type_code = 'DR'
1382: and jta.task_id = jtb.task_id