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_DOCUMENTS_TL

Line 37: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc, fnd_lobs lob,

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
41: AND jtf.resource_id = p_resource_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 244: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

240:
241: --Cursor to get the SR attachemnts
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

Line 264: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

260:
261: --Cursor to get the task attachemnts
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

Line 285: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

281: /* For future support
282: --Cursor to get the Customer attachemnts
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

Line 305: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

301:
302: --Cursor to get the IB Item attachemnts
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

Line 325: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

321:
322: --Cursor to get the debrief attachemnts
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

Line 586: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

582:
583: --Cursor to get the SR attachemnts
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

Line 699: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

695:
696: --Cursor to get the SR attachemnts
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

Line 810: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

806:
807: CURSOR c_SRAtt ( b_incident_id IN NUMBER,
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

Line 829: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

825:
826: CURSOR c_TaskAtt ( b_task_id IN NUMBER,
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