eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_LOBS_EVENT_PKG dependencies on ASG_USER

Line 60: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

56: IS
57: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
58: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 67: csm_incidents_all_acc acc, asg_user asg,

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
69: WHERE fndattdoc.document_id = fnddoc_tl.document_id
70: AND fnddoc_tl.language = asg.language
71: AND asg.user_id=asg.owner_id

Line 71: AND asg.user_id=asg.owner_id

67: csm_incidents_all_acc acc, asg_user asg,
68: FND_DOCUMENT_DATATYPES doctype
69: WHERE fndattdoc.document_id = fnddoc_tl.document_id
70: AND fnddoc_tl.language = asg.language
71: AND asg.user_id=asg.owner_id
72: AND fnddoc_tl.document_id = fnddoc.document_id
73: --AND fnddoc.media_id = lobs.file_id(+)
74: AND fnddoccat_tl.category_id = fnddoc.category_id
75: AND fnddoccat_tl.language = asg.language

Line 77: AND asg.user_id = acc.user_id

73: --AND fnddoc.media_id = lobs.file_id(+)
74: AND fnddoccat_tl.category_id = fnddoc.category_id
75: AND fnddoccat_tl.language = asg.language
76: AND fndattdoc.pk1_value = to_char(acc.incident_id)
77: AND asg.user_id = acc.user_id
78: AND fnddoccat_tl.name = 'MISC'
79: AND fndattdoc.entity_name = 'CS_INCIDENTS'
80: AND fnddoc.datatype_id in(1,5,6)
81: AND doctype.datatype_id = fnddoc.datatype_id

Line 93: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

89: IS
90: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
91: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 100: csm_tasks_acc acc, asg_user asg,

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

Line 109: AND asg.user_id = acc.user_id

105: --AND fnddoc.media_id = lobs.file_id(+)
106: AND fnddoccat_tl.category_id = fnddoc.category_id
107: AND fnddoccat_tl.language = asg.language
108: AND fndattdoc.pk1_value = to_char(acc.task_id)
109: AND asg.user_id = acc.user_id
110: AND asg.user_id=asg.owner_id
111: AND fnddoccat_tl.name = 'MISC'
112: AND fndattdoc.entity_name = 'JTF_TASKS_B'
113: AND fnddoc.datatype_id in(1,5,6)

Line 110: AND asg.user_id=asg.owner_id

106: AND fnddoccat_tl.category_id = fnddoc.category_id
107: AND fnddoccat_tl.language = asg.language
108: AND fndattdoc.pk1_value = to_char(acc.task_id)
109: AND asg.user_id = acc.user_id
110: AND asg.user_id=asg.owner_id
111: AND fnddoccat_tl.name = 'MISC'
112: AND fndattdoc.entity_name = 'JTF_TASKS_B'
113: AND fnddoc.datatype_id in(1,5,6)
114: AND doctype.datatype_id = fnddoc.datatype_id

Line 126: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

122: CURSOR c_Signature IS
123: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
124: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 133: csm_debrief_headers_acc acc, asg_user asg,

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
135: WHERE fndattdoc.document_id = fnddoc_tl.document_id
136: AND fnddoc_tl.language = asg.language
137: AND fnddoc_tl.document_id = fnddoc.document_id

Line 147: AND acc.user_id = asg.user_id

143: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
144: AND fnddoc.datatype_id =6
145: AND doctype.datatype_id = fnddoc.datatype_id
146: AND doctype.language = asg.language
147: AND acc.user_id = asg.user_id
148: AND asg.user_id=asg.owner_id
149: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc
150: WHERE cflacc.document_id = fnddoc.document_id
151: AND cflacc.user_id = acc.user_id);

Line 148: AND asg.user_id=asg.owner_id

144: AND fnddoc.datatype_id =6
145: AND doctype.datatype_id = fnddoc.datatype_id
146: AND doctype.language = asg.language
147: AND acc.user_id = asg.user_id
148: AND asg.user_id=asg.owner_id
149: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc
150: WHERE cflacc.document_id = fnddoc.document_id
151: AND cflacc.user_id = acc.user_id);
152:

Line 420: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

416: CURSOR c_SRAtt (b_user_id NUMBER) IS
417: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
418: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 427: csm_incidents_all_acc acc, asg_user asg,

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
429: WHERE fndattdoc.document_id = fnddoc_tl.document_id
430: AND fnddoc_tl.language = asg.language
431: AND fnddoc_tl.document_id = fnddoc.document_id

Line 436: AND asg.user_id = acc.user_id

432: -- AND fnddoc.media_id = lobs.file_id (+)
433: AND fnddoccat_tl.category_id = fnddoc.category_id
434: AND fnddoccat_tl.language = asg.language
435: AND fndattdoc.pk1_value = to_char(acc.incident_id)
436: AND asg.user_id = acc.user_id
437: AND fnddoccat_tl.name = 'MISC'
438: AND fndattdoc.entity_name = 'CS_INCIDENTS'
439: AND fnddoc.datatype_id in (1,5,6)
440: AND doctype.datatype_id = fnddoc.datatype_id

Line 449: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

445: CURSOR c_TaskAtt (b_user_id NUMBER) IS
446: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
447: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 456: csm_tasks_acc acc, asg_user asg,

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
458: WHERE fndattdoc.document_id = fnddoc_tl.document_id
459: AND fnddoc_tl.language = asg.language
460: AND fnddoc_tl.document_id = fnddoc.document_id

Line 465: AND asg.user_id = acc.user_id

461: -- AND fnddoc.media_id = lobs.file_id (+)
462: AND fnddoccat_tl.category_id = fnddoc.category_id
463: AND fnddoccat_tl.language = asg.language
464: AND fndattdoc.pk1_value = to_char(acc.task_id)
465: AND asg.user_id = acc.user_id
466: AND fnddoccat_tl.name = 'MISC'
467: AND fndattdoc.entity_name = 'JTF_TASKS_B'
468: AND fnddoc.datatype_id in (1,5,6)
469: AND doctype.datatype_id = fnddoc.datatype_id

Line 478: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

474: CURSOR c_Signature (b_user_id NUMBER) IS
475: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
476: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 485: csm_debrief_headers_acc acc, asg_user asg,

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
487: WHERE fndattdoc.document_id = fnddoc_tl.document_id
488: AND fnddoc_tl.language = asg.language
489: AND fnddoc_tl.document_id = fnddoc.document_id

Line 494: AND asg.user_id = b_user_id

490: -- AND fnddoc.media_id = lobs.file_id
491: AND fnddoccat_tl.category_id = fnddoc.category_id
492: AND fnddoccat_tl.language = asg.language
493: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
494: AND asg.user_id = b_user_id
495: AND fnddoccat_tl.name = 'SIGNATURE'
496: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
497: AND fnddoc.datatype_id =6
498: AND doctype.datatype_id = fnddoc.datatype_id

Line 500: AND acc.user_id = asg.user_id;

496: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
497: AND fnddoc.datatype_id =6
498: AND doctype.datatype_id = fnddoc.datatype_id
499: AND doctype.language = asg.language
500: AND acc.user_id = asg.user_id;
501:
502: l_dummy BOOLEAN;
503: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
504: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 797: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,

793: IS
794: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
795: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
796: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
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,

Line 804: csm_debrief_headers_acc acc,asg_user asg,

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
808: AND acc.user_id = b_user_id

Line 809: AND asg.user_id = b_user_id

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
808: AND acc.user_id = b_user_id
809: AND asg.user_id = b_user_id
810: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'
811: AND fndatt.pk1_value = dbfhdr.debrief_header_id
812: AND fndatt.document_id = fnddoc_tl.document_id
813: AND fnddoc_tl.document_id = fnddoc.document_id

Line 833: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

829: IS
830: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
831: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
832: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
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,

Line 841: csm_incidents_all_acc acc,asg_user asg,

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
843: WHERE jta.task_assignment_id = b_task_assignment_id
844: AND jta.task_id = jt.task_id
845: AND jt.source_object_id = acc.incident_id

Line 855: AND asg.user_id = b_user_id

851: AND fnddoccat_tl.category_id = fnddoc.category_id
852: AND fnddoccat_tl.language = b_lang
853: AND fndattdoc.pk1_value = to_char(acc.incident_id)
854: AND acc.user_id = b_user_id
855: AND asg.user_id = b_user_id
856: AND fnddoccat_tl.name = 'MISC'
857: AND fndattdoc.entity_name = 'CS_INCIDENTS'
858: AND fnddoc.datatype_id in (1,5,6)
859: AND doctype.datatype_id = fnddoc.datatype_id

Line 872: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

868: IS
869: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
870: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
871: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
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,

Line 880: csm_tasks_acc acc,asg_user asg,

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
882: WHERE jta.task_assignment_id = b_task_assignment_id
883: AND acc.task_id = jta.task_id
884: AND fndattdoc.document_id = fnddoc_tl.document_id

Line 892: AND asg.user_id = b_user_id

888: AND fnddoccat_tl.category_id = fnddoc.category_id
889: AND fnddoccat_tl.language = b_lang
890: AND fndattdoc.pk1_value = to_char(acc.task_id)
891: AND acc.user_id = b_user_id
892: AND asg.user_id = b_user_id
893: AND fnddoccat_tl.name = 'MISC'
894: AND fndattdoc.entity_name = 'JTF_TASKS_B'
895: AND fnddoc.datatype_id in (1,5,6)
896: AND doctype.datatype_id = fnddoc.datatype_id

Line 905: FROM asg_user

901:
902: CURSOR l_user_csr(b_user_id IN NUMBER)
903: IS
904: SELECT LANGUAGE
905: FROM asg_user
906: WHERE user_id=b_user_id;
907:
908: l_sqlerrno VARCHAR2(20);
909: l_sqlerrmsg VARCHAR2(4000);

Line 1229: FROM asg_user

1225: --CURSOR to get userid
1226: CURSOR l_userid_csr (b_resource_id IN NUMBER)
1227: IS
1228: SELECT user_id
1229: FROM asg_user
1230: WHERE resource_id=b_resource_id;
1231:
1232: l_sqlerrno VARCHAR2(20);
1233: l_sqlerrmsg VARCHAR2(4000);

Line 1415: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,

1411: IS
1412: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1413: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 1423: asg_user asg,

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
1425: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1426: AND fnddoc_tl.language = asg.language
1427: AND fnddoc_tl.document_id = fnddoc.document_id

Line 1432: AND asg.user_id = acc.user_id

1428: AND fnddoccat_tl.category_id = fnddoc.category_id
1429: AND fnddoccat_tl.language = asg.language
1430: AND fndattdoc.pk1_value = to_char(acc.incident_id)
1431: AND fndattdoc.pk1_value = to_char(b_incident_id)
1432: AND asg.user_id = acc.user_id
1433: AND fnddoccat_tl.name = 'MISC'
1434: AND fndattdoc.entity_name = 'CS_INCIDENTS'
1435: AND fnddoc.datatype_id = b_data_typeid
1436: AND doctype.datatype_id = fnddoc.datatype_id

Line 1451: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,

1447: IS
1448: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1449: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 1459: asg_user asg,

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
1461: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1462: AND fnddoc_tl.language = asg.language
1463: AND fnddoc_tl.document_id = fnddoc.document_id

Line 1468: AND asg.user_id = acc.user_id

1464: AND fnddoccat_tl.category_id = fnddoc.category_id
1465: AND fnddoccat_tl.language = asg.language
1466: AND fndattdoc.pk1_value = to_char(acc.task_id)
1467: AND fndattdoc.pk1_value = to_char(b_task_id)
1468: AND asg.user_id = acc.user_id
1469: AND fnddoccat_tl.name = 'MISC'
1470: AND fndattdoc.entity_name = 'JTF_TASKS_B'
1471: AND fnddoc.datatype_id = b_data_typeid
1472: AND doctype.datatype_id = fnddoc.datatype_id

Line 1487: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

1483: b_data_typeid IN NUMBER) IS
1484: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1485: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
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,

Line 1493: csm_debrief_headers_acc acc, asg_user asg,

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
1496: AND fnddoc_tl.language = asg.language
1497: AND fnddoc_tl.document_id = fnddoc.document_id

Line 1507: AND acc.user_id = asg.user_id

1503: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
1504: AND fnddoc.datatype_id =b_data_typeid
1505: AND doctype.datatype_id = fnddoc.datatype_id
1506: AND doctype.language = asg.language
1507: AND acc.user_id = asg.user_id
1508: AND acc.user_id=b_user_id
1509: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc
1510: WHERE cflacc.document_id = fnddoc.document_id
1511: AND cflacc.user_id = acc.user_id);