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 FND_ATTACHED_DOCUMENTS

Line 36: jtf_rs_resource_extns jtrs, asg_user, fnd_attached_documents fndatt,

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
40: AND jtf.task_assignment_id = dbfhdr.task_assignment_id

Line 147: asg_user, fnd_attached_documents fndatt, fnd_documents_tl fnddoc_tl,

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
151: AND acc.task_assignment_id = p_task_assignment_id

Line 246: fnd_attached_documents fndattdoc, fnd_lobs lobs,

242: CURSOR c_SRAtt (b_lastRundate date) IS
243: SELECT lobs.file_id, acc.resource_id
244: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
245: fnd_document_categories_tl fnddoccat_tl,
246: fnd_attached_documents fndattdoc, fnd_lobs lobs,
247: csl_cs_incidents_all_acc acc, asg_user asg
248: WHERE fndattdoc.document_id = fnddoc_tl.document_id
249: AND fnddoc_tl.language = asg.language
250: AND fnddoc_tl.document_id = fnddoc.document_id

Line 266: fnd_attached_documents fndattdoc, fnd_lobs lobs,

262: CURSOR c_TaskAtt (b_lastRundate date) IS
263: SELECT lobs.file_id, acc.resource_id
264: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
265: fnd_document_categories_tl fnddoccat_tl,
266: fnd_attached_documents fndattdoc, fnd_lobs lobs,
267: csl_jtf_tasks_acc acc, asg_user asg
268: WHERE fndattdoc.document_id = fnddoc_tl.document_id
269: AND fnddoc_tl.language = asg.language
270: AND fnddoc_tl.document_id = fnddoc.document_id

Line 287: fnd_attached_documents fndattdoc, fnd_lobs lobs,

283: CURSOR c_PartyAtt (b_lastRundate date) IS
284: SELECT lobs.file_id, acc.resource_id
285: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
286: fnd_document_categories_tl fnddoccat_tl,
287: fnd_attached_documents fndattdoc, fnd_lobs lobs,
288: csl_hz_parties_acc acc, asg_user asg
289: WHERE fndattdoc.document_id = fnddoc_tl.document_id
290: AND fnddoc_tl.language = asg.language
291: AND fnddoc_tl.document_id = fnddoc.document_id

Line 307: fnd_attached_documents fndattdoc, fnd_lobs lobs,

303: CURSOR c_IBItemAtt (b_lastRundate date) IS
304: SELECT lobs.file_id, acc.resource_id
305: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
306: fnd_document_categories_tl fnddoccat_tl,
307: fnd_attached_documents fndattdoc, fnd_lobs lobs,
308: csl_csi_item_instances_acc acc, asg_user asg
309: WHERE fndattdoc.document_id = fnddoc_tl.document_id
310: AND fnddoc_tl.language = asg.language
311: AND fnddoc_tl.document_id = fnddoc.document_id

Line 327: fnd_attached_documents fndattdoc, fnd_lobs lobs,

323: CURSOR c_DebriefAtt (b_lastRundate date) IS
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

Line 588: fnd_attached_documents fndattdoc, fnd_lobs lobs,

584: CURSOR c_SRAtt (b_incident_id number) IS
585: SELECT lobs.file_id, acc.resource_id
586: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
587: fnd_document_categories_tl fnddoccat_tl,
588: fnd_attached_documents fndattdoc, fnd_lobs lobs,
589: csl_cs_incidents_all_acc acc, asg_user asg
590: WHERE fndattdoc.document_id = fnddoc_tl.document_id
591: AND fnddoc_tl.language = asg.language
592: AND fnddoc_tl.document_id = fnddoc.document_id

Line 701: fnd_attached_documents fndattdoc, fnd_lobs lobs,

697: CURSOR c_TaskAtt (b_task_id number) IS
698: SELECT lobs.file_id, acc.resource_id
699: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
700: fnd_document_categories_tl fnddoccat_tl,
701: fnd_attached_documents fndattdoc, fnd_lobs lobs,
702: csl_jtf_tasks_acc acc, asg_user asg
703: WHERE fndattdoc.document_id = fnddoc_tl.document_id
704: AND fnddoc_tl.language = asg.language
705: AND fnddoc_tl.document_id = fnddoc.document_id

Line 812: fnd_attached_documents fndattdoc, fnd_lobs lobs,

808: b_resource_id IN NUMBER) IS
809: SELECT lobs.file_id, b_resource_id
810: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
811: fnd_document_categories_tl fnddoccat_tl,
812: fnd_attached_documents fndattdoc, fnd_lobs lobs,
813: asg_user asg
814: WHERE fndattdoc.document_id = fnddoc_tl.document_id
815: AND fnddoc_tl.language = asg.language
816: AND fnddoc_tl.document_id = fnddoc.document_id

Line 831: fnd_attached_documents fndattdoc, fnd_lobs lobs,

827: b_resource_id IN NUMBER) IS
828: SELECT lobs.file_id, b_resource_id
829: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
830: fnd_document_categories_tl fnddoccat_tl,
831: fnd_attached_documents fndattdoc, fnd_lobs lobs,
832: asg_user asg
833: WHERE fndattdoc.document_id = fnddoc_tl.document_id
834: AND fnddoc_tl.language = asg.language
835: AND fnddoc_tl.document_id = fnddoc.document_id