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

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

Line 452: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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

Line 481: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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

Line 801: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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

Line 837: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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

Line 876: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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

Line 1418: FROM fnd_documents_tl fnddoc_tl,

1414: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1415: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1416: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
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,

Line 1454: FROM fnd_documents_tl fnddoc_tl,

1450: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1451: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1452: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
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,

Line 1490: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,

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