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 ASG_USER

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 43: AND asg_user.resource_id = jtf.resource_id

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
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

Line 48: AND fnddoc_tl.language = asg_user.language

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
49: AND fnddoc_tl.media_id = lob.file_id
50: AND fnddoccat_tl.category_id = fnddoc.category_id
51: AND fnddoccat_tl.language = asg_user.language
52: AND fnddoccat_tl.user_name = 'Signature';

Line 51: AND fnddoccat_tl.language = asg_user.language

47: AND fnddoc_tl.document_id = fnddoc.document_id
48: AND fnddoc_tl.language = asg_user.language
49: AND fnddoc_tl.media_id = lob.file_id
50: AND fnddoccat_tl.category_id = fnddoc.category_id
51: AND fnddoccat_tl.language = asg_user.language
52: AND fnddoccat_tl.user_name = 'Signature';
53:
54: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS
55: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_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 150: WHERE asg_user.resource_id = p_resource_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
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'

Line 153: AND asg_user.user_id = acc.user_id

149: fnd_lobs lob
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

Line 158: AND fnddoc_tl.language = asg_user.language

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
159: AND fnddoc_tl.media_id = lob.file_id
160: AND fnddoccat_tl.category_id = fnddoc.category_id
161: AND fnddoccat_tl.language = asg_user.language
162: AND fnddoccat_tl.user_name = 'Signature';

Line 161: AND fnddoccat_tl.language = asg_user.language

157: AND fnddoc_tl.document_id = fnddoc.document_id
158: AND fnddoc_tl.language = asg_user.language
159: AND fnddoc_tl.media_id = lob.file_id
160: AND fnddoccat_tl.category_id = fnddoc.category_id
161: AND fnddoccat_tl.language = asg_user.language
162: AND fnddoccat_tl.user_name = 'Signature';
163:
164: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS
165: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;

Line 247: csl_cs_incidents_all_acc acc, asg_user asg

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
251: AND fnddoc_tl.media_id = lobs.file_id

Line 267: csl_jtf_tasks_acc acc, asg_user asg

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
271: AND fnddoc_tl.media_id = lobs.file_id

Line 288: csl_hz_parties_acc acc, asg_user asg

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
292: AND fnddoc_tl.media_id = lobs.file_id

Line 308: csl_csi_item_instances_acc acc, asg_user asg

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
312: AND fnddoc_tl.media_id = lobs.file_id

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 589: csl_cs_incidents_all_acc acc, asg_user asg

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
593: AND fnddoc_tl.media_id = lobs.file_id

Line 702: csl_jtf_tasks_acc acc, asg_user asg

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
706: AND fnddoc_tl.media_id = lobs.file_id

Line 813: asg_user asg

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
817: AND fnddoc_tl.media_id = lobs.file_id

Line 832: asg_user asg

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
836: AND fnddoc_tl.media_id = lobs.file_id