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 489: fnd_document_categories_tl fnddoccat_tl,

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

Line 518: fnd_document_categories_tl fnddoccat_tl,

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

Line 547: fnd_document_categories_tl fnddoccat_tl,

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

Line 868: fnd_document_categories_tl fnddoccat_tl,

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

Line 903: fnd_document_categories_tl fnddoccat_tl,

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

Line 942: fnd_document_categories_tl fnddoccat_tl,

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

Line 1485: fnd_document_categories_tl fnddoccat_tl,

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,
1488: asg_user asg,
1489: FND_DOCUMENT_DATATYPES doctype

Line 1521: fnd_document_categories_tl fnddoccat_tl,

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,
1524: asg_user asg,
1525: FND_DOCUMENT_DATATYPES doctype

Line 1556: fnd_document_categories_tl fnddoccat_tl,

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