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 493: FND_DOCUMENT_DATATYPES doctype

489: fnd_document_categories_tl fnddoccat_tl,
490: fnd_attached_documents fndattdoc,
491: -- fnd_lobs lobs,
492: csm_incidents_all_acc acc, asg_user asg,
493: FND_DOCUMENT_DATATYPES doctype
494: WHERE fndattdoc.document_id = fnddoc_tl.document_id
495: AND fnddoc_tl.language = asg.language
496: AND fnddoc_tl.document_id = fnddoc.document_id
497: -- AND fnddoc.media_id = lobs.file_id (+)

Line 522: FND_DOCUMENT_DATATYPES doctype

518: fnd_document_categories_tl fnddoccat_tl,
519: fnd_attached_documents fndattdoc,
520: -- fnd_lobs lobs,
521: csm_tasks_acc acc, asg_user asg,
522: FND_DOCUMENT_DATATYPES doctype
523: WHERE fndattdoc.document_id = fnddoc_tl.document_id
524: AND fnddoc_tl.language = asg.language
525: AND fnddoc_tl.document_id = fnddoc.document_id
526: -- AND fnddoc.media_id = lobs.file_id (+)

Line 551: FND_DOCUMENT_DATATYPES doctype

547: fnd_document_categories_tl fnddoccat_tl,
548: fnd_attached_documents fndattdoc,
549: -- fnd_lobs lobs,
550: csm_debrief_headers_acc acc, asg_user asg,
551: FND_DOCUMENT_DATATYPES doctype
552: WHERE fndattdoc.document_id = fnddoc_tl.document_id
553: AND fnddoc_tl.language = asg.language
554: AND fnddoc_tl.document_id = fnddoc.document_id
555: -- AND fnddoc.media_id = lobs.file_id

Line 870: FND_DOCUMENT_DATATYPES doctype

866: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
867: -- fnd_lobs lobs,
868: fnd_document_categories_tl fnddoccat_tl,
869: csm_debrief_headers_acc acc,asg_user asg,
870: FND_DOCUMENT_DATATYPES doctype
871: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
872: AND acc.debrief_header_id = dbfhdr.debrief_header_id
873: AND acc.user_id = b_user_id
874: AND asg.user_id = b_user_id

Line 907: FND_DOCUMENT_DATATYPES doctype

903: fnd_document_categories_tl fnddoccat_tl,
904: fnd_attached_documents fndattdoc,
905: -- fnd_lobs lobs,
906: csm_incidents_all_acc acc,asg_user asg,
907: FND_DOCUMENT_DATATYPES doctype
908: WHERE jta.task_assignment_id = b_task_assignment_id
909: AND jta.task_id = jt.task_id
910: AND jt.source_object_id = acc.incident_id
911: AND jt.source_object_type_code = 'SR'

Line 946: FND_DOCUMENT_DATATYPES doctype

942: fnd_document_categories_tl fnddoccat_tl,
943: fnd_attached_documents fndattdoc,
944: -- fnd_lobs lobs,
945: csm_tasks_acc acc,asg_user asg,
946: FND_DOCUMENT_DATATYPES doctype
947: WHERE jta.task_assignment_id = b_task_assignment_id
948: AND acc.task_id = jta.task_id
949: AND fndattdoc.document_id = fnddoc_tl.document_id
950: AND fnddoc_tl.language = b_lang

Line 1489: FND_DOCUMENT_DATATYPES doctype

1485: fnd_document_categories_tl fnddoccat_tl,
1486: fnd_attached_documents fndattdoc,
1487: csm_incidents_all_acc acc,
1488: asg_user asg,
1489: FND_DOCUMENT_DATATYPES doctype
1490: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1491: AND fnddoc_tl.language = asg.language
1492: AND fnddoc_tl.document_id = fnddoc.document_id
1493: AND fnddoccat_tl.category_id = fnddoc.category_id

Line 1525: FND_DOCUMENT_DATATYPES doctype

1521: fnd_document_categories_tl fnddoccat_tl,
1522: fnd_attached_documents fndattdoc,
1523: csm_tasks_acc acc,
1524: asg_user asg,
1525: FND_DOCUMENT_DATATYPES doctype
1526: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1527: AND fnddoc_tl.language = asg.language
1528: AND fnddoc_tl.document_id = fnddoc.document_id
1529: AND fnddoccat_tl.category_id = fnddoc.category_id

Line 1559: FND_DOCUMENT_DATATYPES doctype

1555: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
1556: fnd_document_categories_tl fnddoccat_tl,
1557: fnd_attached_documents fndattdoc,
1558: csm_debrief_headers_acc acc, asg_user asg,
1559: FND_DOCUMENT_DATATYPES doctype
1560: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1561: AND fnddoc_tl.language = asg.language
1562: AND fnddoc_tl.document_id = fnddoc.document_id
1563: AND fnddoccat_tl.category_id = fnddoc.category_id