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 490: fnd_attached_documents fndattdoc,

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

Line 519: fnd_attached_documents fndattdoc,

515: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
516: fnddoc.document_id,fnddoc_tl.title
517: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 548: fnd_attached_documents fndattdoc,

544: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
545: fnddoc.document_id,fnddoc_tl.title
546: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 865: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,

861: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
862: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
863: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
864: fnddoc.document_id,fnddoc_tl.title
865: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,
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,

Line 904: fnd_attached_documents fndattdoc,

900: fnddoc.document_id,fnddoc_tl.title
901: FROM jtf_task_assignments jta, jtf_tasks_b jt,
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

Line 943: fnd_attached_documents fndattdoc,

939: fnddoc.document_id,fnddoc_tl.title
940: FROM jtf_task_assignments jta,
941: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
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

Line 1486: fnd_attached_documents fndattdoc,

1482: fnddoc.document_id, fnddoc_tl.title
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

Line 1522: fnd_attached_documents fndattdoc,

1518: fnddoc.document_id, fnddoc_tl.title
1519: FROM fnd_documents_tl fnddoc_tl,
1520: fnd_documents fnddoc,
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

Line 1557: fnd_attached_documents fndattdoc,

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