DBA Data[Home] [Help]

APPS.CSM_LOBS_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC

Line 67: csm_incidents_all_acc acc, asg_user asg,

63: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 492: csm_incidents_all_acc acc, asg_user asg,

488: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 906: csm_incidents_all_acc acc,asg_user asg,

902: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 1487: csm_incidents_all_acc acc,

1483: FROM fnd_documents_tl fnddoc_tl,
1484: fnd_documents fnddoc,
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