DBA Data[Home] [Help]

APPS.CSM_LOBS_EVENT_PKG dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 64: fnd_document_categories_tl fnddoccat_tl,

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

Line 97: fnd_document_categories_tl fnddoccat_tl,

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

Line 130: fnd_document_categories_tl fnddoccat_tl,

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

Line 424: fnd_document_categories_tl fnddoccat_tl,

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

Line 453: fnd_document_categories_tl fnddoccat_tl,

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

Line 482: fnd_document_categories_tl fnddoccat_tl,

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

Line 803: fnd_document_categories_tl fnddoccat_tl,

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
806: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
807: AND acc.debrief_header_id = dbfhdr.debrief_header_id

Line 838: fnd_document_categories_tl fnddoccat_tl,

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

Line 877: fnd_document_categories_tl fnddoccat_tl,

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

Line 1420: fnd_document_categories_tl fnddoccat_tl,

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,
1423: asg_user asg,
1424: FND_DOCUMENT_DATATYPES doctype

Line 1456: fnd_document_categories_tl fnddoccat_tl,

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,
1459: asg_user asg,
1460: FND_DOCUMENT_DATATYPES doctype

Line 1491: fnd_document_categories_tl fnddoccat_tl,

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
1495: WHERE fndattdoc.document_id = fnddoc_tl.document_id