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.CSM_LOBS_EVENT_PKG dependencies on FND_DOCUMENT_DATATYPES

Line 68: FND_DOCUMENT_DATATYPES doctype

64: fnd_document_categories_tl fnddoccat_tl,
65: fnd_attached_documents fndattdoc,
66: -- fnd_lobs lobs,
67: csm_incidents_all_acc acc, asg_user asg,
68: FND_DOCUMENT_DATATYPES doctype
69: WHERE fndattdoc.document_id = fnddoc_tl.document_id
70: AND fnddoc_tl.language = asg.language
71: AND asg.user_id=asg.owner_id
72: AND fnddoc_tl.document_id = fnddoc.document_id

Line 101: FND_DOCUMENT_DATATYPES doctype

97: fnd_document_categories_tl fnddoccat_tl,
98: fnd_attached_documents fndattdoc,
99: -- fnd_lobs lobs,
100: csm_tasks_acc acc, asg_user asg,
101: FND_DOCUMENT_DATATYPES doctype
102: WHERE fndattdoc.document_id = fnddoc_tl.document_id
103: AND fnddoc_tl.language = asg.language
104: AND fnddoc_tl.document_id = fnddoc.document_id
105: --AND fnddoc.media_id = lobs.file_id(+)

Line 134: FND_DOCUMENT_DATATYPES doctype

130: fnd_document_categories_tl fnddoccat_tl,
131: fnd_attached_documents fndattdoc,
132: -- fnd_lobs lobs,
133: csm_debrief_headers_acc acc, asg_user asg,
134: FND_DOCUMENT_DATATYPES doctype
135: WHERE fndattdoc.document_id = fnddoc_tl.document_id
136: AND fnddoc_tl.language = asg.language
137: AND fnddoc_tl.document_id = fnddoc.document_id
138: -- AND fnddoc.media_id = lobs.file_id

Line 428: FND_DOCUMENT_DATATYPES doctype

424: fnd_document_categories_tl fnddoccat_tl,
425: fnd_attached_documents fndattdoc,
426: -- fnd_lobs lobs,
427: csm_incidents_all_acc acc, asg_user asg,
428: FND_DOCUMENT_DATATYPES doctype
429: WHERE fndattdoc.document_id = fnddoc_tl.document_id
430: AND fnddoc_tl.language = asg.language
431: AND fnddoc_tl.document_id = fnddoc.document_id
432: -- AND fnddoc.media_id = lobs.file_id (+)

Line 457: FND_DOCUMENT_DATATYPES doctype

453: fnd_document_categories_tl fnddoccat_tl,
454: fnd_attached_documents fndattdoc,
455: -- fnd_lobs lobs,
456: csm_tasks_acc acc, asg_user asg,
457: FND_DOCUMENT_DATATYPES doctype
458: WHERE fndattdoc.document_id = fnddoc_tl.document_id
459: AND fnddoc_tl.language = asg.language
460: AND fnddoc_tl.document_id = fnddoc.document_id
461: -- AND fnddoc.media_id = lobs.file_id (+)

Line 486: FND_DOCUMENT_DATATYPES doctype

482: fnd_document_categories_tl fnddoccat_tl,
483: fnd_attached_documents fndattdoc,
484: -- fnd_lobs lobs,
485: csm_debrief_headers_acc acc, asg_user asg,
486: FND_DOCUMENT_DATATYPES doctype
487: WHERE fndattdoc.document_id = fnddoc_tl.document_id
488: AND fnddoc_tl.language = asg.language
489: AND fnddoc_tl.document_id = fnddoc.document_id
490: -- AND fnddoc.media_id = lobs.file_id

Line 805: FND_DOCUMENT_DATATYPES doctype

801: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
802: -- fnd_lobs lobs,
803: fnd_document_categories_tl fnddoccat_tl,
804: csm_debrief_headers_acc acc,asg_user asg,
805: FND_DOCUMENT_DATATYPES doctype
806: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
807: AND acc.debrief_header_id = dbfhdr.debrief_header_id
808: AND acc.user_id = b_user_id
809: AND asg.user_id = b_user_id

Line 842: FND_DOCUMENT_DATATYPES doctype

838: fnd_document_categories_tl fnddoccat_tl,
839: fnd_attached_documents fndattdoc,
840: -- fnd_lobs lobs,
841: csm_incidents_all_acc acc,asg_user asg,
842: FND_DOCUMENT_DATATYPES doctype
843: WHERE jta.task_assignment_id = b_task_assignment_id
844: AND jta.task_id = jt.task_id
845: AND jt.source_object_id = acc.incident_id
846: AND jt.source_object_type_code = 'SR'

Line 881: FND_DOCUMENT_DATATYPES doctype

877: fnd_document_categories_tl fnddoccat_tl,
878: fnd_attached_documents fndattdoc,
879: -- fnd_lobs lobs,
880: csm_tasks_acc acc,asg_user asg,
881: FND_DOCUMENT_DATATYPES doctype
882: WHERE jta.task_assignment_id = b_task_assignment_id
883: AND acc.task_id = jta.task_id
884: AND fndattdoc.document_id = fnddoc_tl.document_id
885: AND fnddoc_tl.language = b_lang

Line 1424: FND_DOCUMENT_DATATYPES doctype

1420: fnd_document_categories_tl fnddoccat_tl,
1421: fnd_attached_documents fndattdoc,
1422: csm_incidents_all_acc acc,
1423: asg_user asg,
1424: FND_DOCUMENT_DATATYPES doctype
1425: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1426: AND fnddoc_tl.language = asg.language
1427: AND fnddoc_tl.document_id = fnddoc.document_id
1428: AND fnddoccat_tl.category_id = fnddoc.category_id

Line 1460: FND_DOCUMENT_DATATYPES doctype

1456: fnd_document_categories_tl fnddoccat_tl,
1457: fnd_attached_documents fndattdoc,
1458: csm_tasks_acc acc,
1459: asg_user asg,
1460: FND_DOCUMENT_DATATYPES doctype
1461: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1462: AND fnddoc_tl.language = asg.language
1463: AND fnddoc_tl.document_id = fnddoc.document_id
1464: AND fnddoccat_tl.category_id = fnddoc.category_id

Line 1494: FND_DOCUMENT_DATATYPES doctype

1490: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
1491: fnd_document_categories_tl fnddoccat_tl,
1492: fnd_attached_documents fndattdoc,
1493: csm_debrief_headers_acc acc, asg_user asg,
1494: FND_DOCUMENT_DATATYPES doctype
1495: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1496: AND fnddoc_tl.language = asg.language
1497: AND fnddoc_tl.document_id = fnddoc.document_id
1498: AND fnddoccat_tl.category_id = fnddoc.category_id