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 210: from jtf_task_assignments jta

206: cursor c_debrief_error is
207: select fnd_profile.value('CSF_DEBRIEF_ERROR_STATUS'),
208: jta.assignment_status_id,
209: jta.object_version_number
210: from jtf_task_assignments jta
211: where jta.task_assignment_id = l_task_assignment_id;
212:
213: cursor c_lines (p_debrief_header_id Number) is
214: select cdl.debrief_line_id,

Line 279: JTF_TASK_ASSIGNMENTS jta,

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
281: WHERE cdh.task_assignment_id = jta.task_assignment_id
282: and jta.task_id = jtb.task_id
283: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 308: JTF_TASK_ASSIGNMENTS jta,

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
310: WHERE cdh.task_assignment_id = jta.task_assignment_id
311: and jta.task_id = jtb.task_id
312: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 338: JTF_TASK_ASSIGNMENTS jta,

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
340: WHERE cdh.task_assignment_id = jta.task_assignment_id
341: and jta.task_id = jtb.task_id
342: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 369: JTF_TASK_ASSIGNMENTS jta,

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
371: WHERE cdh.task_assignment_id = jta.task_assignment_id
372: and jta.task_id = jtb.task_id
373: and nvl(jtb.deleted_flag,'N') <> 'Y'

Line 464: jtf_task_assignments jta

460:
461: cursor c_default_defective is
462: select cila.organization_id,cila.subinventory_code
463: from csp_inv_loc_assignments cila,
464: jtf_task_assignments jta
465: where cila.default_code = 'OUT'
466: and cila.resource_type = jta.resource_type_code
467: and cila.resource_id = jta.resource_id
468: and jta.task_assignment_id = l_task_assignment_id;

Line 1976: jtf_task_assignments jta,

1972: cdh.debrief_header_id,
1973: cdh.debrief_number,
1974: decode(processed_flag,'PENDING','P','E') debrief_status
1975: from csf_debrief_headers cdh,
1976: jtf_task_assignments jta,
1977: jtf_tasks_b jtb
1978: where processed_flag in ('PENDING','COMPLETED W/ERRORS')
1979: and jta.task_assignment_id = cdh.task_assignment_id
1980: and jtb.task_id = jta.task_id

Line 1991: jtf_task_assignments jta,

1987: cdh.debrief_number,
1988: decode(processed_flag,'PENDING','P','E') debrief_status
1989: from csd_repairs cr,
1990: jtf_tasks_b jtb,
1991: jtf_task_assignments jta,
1992: csf_debrief_headers cdh
1993: where jtb.source_object_id = cr.repair_line_id
1994: and jtb.source_object_type_code = 'DR'
1995: and jta.task_id = jtb.task_id