DBA Data[Home] [Help]

APPS.CSM_LOBS_EVENT_PKG dependencies on FND_DOCUMENTS_TL

Line 63: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

59: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
60: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 96: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

92: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
93: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 129: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

125: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
126: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 488: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

484: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
485: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 517: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

513: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
514: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 546: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

542: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
543: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 866: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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,
870: FND_DOCUMENT_DATATYPES doctype

Line 902: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

898: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
899: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
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,

Line 941: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

937: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
938: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
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,

Line 1483: FROM fnd_documents_tl fnddoc_tl,

1479: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1480: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1481: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
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,

Line 1519: FROM fnd_documents_tl fnddoc_tl,

1515: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1516: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1517: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
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,

Line 1555: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

1551: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1552: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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