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.CSL_LOBS_ACC_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 35: FROM jtf_task_assignments jtf, csf_debrief_headers dbfhdr,

31:
32: CURSOR l_signature_csr(p_task_assignment_id IN number,
33: p_resource_id IN number) IS
34: SELECT distinct lob.file_id, jtrs.user_id
35: FROM jtf_task_assignments jtf, csf_debrief_headers dbfhdr,
36: jtf_rs_resource_extns jtrs, asg_user, fnd_attached_documents fndatt,
37: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc, fnd_lobs lob,
38: fnd_document_categories_tl fnddoccat_tl
39: WHERE jtf.task_assignment_id = p_task_assignment_id

Line 44: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'

40: AND jtf.task_assignment_id = dbfhdr.task_assignment_id
41: AND jtf.resource_id = p_resource_id
42: AND jtrs.resource_id = jtf.resource_id
43: AND asg_user.resource_id = jtf.resource_id
44: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'
45: AND fndatt.pk1_value = dbfhdr.debrief_header_id
46: AND fndatt.document_id = fnddoc_tl.document_id
47: AND fnddoc_tl.document_id = fnddoc.document_id
48: AND fnddoc_tl.language = asg_user.language

Line 146: FROM csm_task_assignments_acc acc , csf_debrief_headers dbfhdr,

142:
143: CURSOR l_signature_csr (p_task_assignment_id IN number,
144: p_resource_id IN number) IS
145: SELECT distinct lob.file_id, acc.user_id
146: FROM csm_task_assignments_acc acc , csf_debrief_headers dbfhdr,
147: asg_user, fnd_attached_documents fndatt, fnd_documents_tl fnddoc_tl,
148: fnd_documents fnddoc, fnd_document_categories_tl fnddoccat_tl,
149: fnd_lobs lob
150: WHERE asg_user.resource_id = p_resource_id

Line 154: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'

150: WHERE asg_user.resource_id = p_resource_id
151: AND acc.task_assignment_id = p_task_assignment_id
152: AND acc.task_assignment_id = dbfhdr.task_assignment_id
153: AND asg_user.user_id = acc.user_id
154: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'
155: AND fndatt.pk1_value = dbfhdr.debrief_header_id
156: AND fndatt.document_id = fnddoc_tl.document_id
157: AND fnddoc_tl.document_id = fnddoc.document_id
158: AND fnddoc_tl.language = asg_user.language

Line 328: JTM_CSF_DEBRIEF_HEADERS_ACC acc, asg_user asg

324: SELECT lobs.file_id, acc.resource_id
325: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
326: fnd_document_categories_tl fnddoccat_tl,
327: fnd_attached_documents fndattdoc, fnd_lobs lobs,
328: JTM_CSF_DEBRIEF_HEADERS_ACC acc, asg_user asg
329: WHERE fndattdoc.document_id = fnddoc_tl.document_id
330: AND fnddoc_tl.language = asg.language
331: AND fnddoc_tl.document_id = fnddoc.document_id
332: AND fnddoc_tl.media_id = lobs.file_id

Line 338: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'

334: AND fnddoccat_tl.language = asg.language
335: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
336: AND asg.resource_id = acc.resource_id
337: AND fnddoccat_tl.name = 'MISC'
338: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
339: AND fnddoc.datatype_id=6
340: AND fndattdoc.last_update_date >= b_lastRundate;
341: */
342: