DBA Data[Home] [Help]

APPS.CSM_LOBS_EVENT_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 65: fnd_attached_documents fndattdoc,

61: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
62: fnddoc.document_id,fnddoc_tl.title
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

Line 98: fnd_attached_documents fndattdoc,

94: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
95: fnddoc.document_id,fnddoc_tl.title
96: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 131: fnd_attached_documents fndattdoc,

127: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
128: fnddoc.document_id,fnddoc_tl.title
129: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 425: fnd_attached_documents fndattdoc,

421: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
422: fnddoc.document_id,fnddoc_tl.title
423: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 454: fnd_attached_documents fndattdoc,

450: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
451: fnddoc.document_id,fnddoc_tl.title
452: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 483: fnd_attached_documents fndattdoc,

479: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
480: fnddoc.document_id,fnddoc_tl.title
481: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 800: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,

796: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
797: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
798: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
799: fnddoc.document_id,fnddoc_tl.title
800: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,
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,

Line 839: fnd_attached_documents fndattdoc,

835: fnddoc.document_id,fnddoc_tl.title
836: FROM jtf_task_assignments jta, jtf_tasks_b jt,
837: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 878: fnd_attached_documents fndattdoc,

874: fnddoc.document_id,fnddoc_tl.title
875: FROM jtf_task_assignments jta,
876: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 1421: fnd_attached_documents fndattdoc,

1417: fnddoc.document_id, fnddoc_tl.title
1418: FROM fnd_documents_tl fnddoc_tl,
1419: fnd_documents fnddoc,
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

Line 1457: fnd_attached_documents fndattdoc,

1453: fnddoc.document_id, fnddoc_tl.title
1454: FROM fnd_documents_tl fnddoc_tl,
1455: fnd_documents fnddoc,
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

Line 1492: fnd_attached_documents fndattdoc,

1488: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
1489: fnddoc.document_id,fnddoc_tl.title
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