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
103: AND fnddoc_tl.language = asg.language
104: AND fnddoc_tl.document_id = fnddoc.document_id
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
524: AND fnddoc_tl.language = asg.language
525: AND fnddoc_tl.document_id = fnddoc.document_id
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
948: AND acc.task_id = jta.task_id
949: AND fndattdoc.document_id = fnddoc_tl.document_id
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
1527: AND fnddoc_tl.language = asg.language