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 485: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,

481: CURSOR c_SRAtt (b_user_id NUMBER) IS
482: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
483: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
484: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
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,

Line 492: csm_incidents_all_acc acc, asg_user asg,

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
494: WHERE fndattdoc.document_id = fnddoc_tl.document_id
495: AND fnddoc_tl.language = asg.language
496: AND fnddoc_tl.document_id = fnddoc.document_id

Line 501: AND asg.user_id = acc.user_id

497: -- AND fnddoc.media_id = lobs.file_id (+)
498: AND fnddoccat_tl.category_id = fnddoc.category_id
499: AND fnddoccat_tl.language = asg.language
500: AND fndattdoc.pk1_value = to_char(acc.incident_id)
501: AND asg.user_id = acc.user_id
502: AND fnddoccat_tl.name = 'MISC'
503: AND fndattdoc.entity_name = 'CS_INCIDENTS'
504: AND fnddoc.datatype_id in (1,5,6)
505: AND doctype.datatype_id = fnddoc.datatype_id

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

510: CURSOR c_TaskAtt (b_user_id NUMBER) IS
511: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
512: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
513: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
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,

Line 521: csm_tasks_acc acc, asg_user asg,

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

Line 530: AND asg.user_id = acc.user_id

526: -- AND fnddoc.media_id = lobs.file_id (+)
527: AND fnddoccat_tl.category_id = fnddoc.category_id
528: AND fnddoccat_tl.language = asg.language
529: AND fndattdoc.pk1_value = to_char(acc.task_id)
530: AND asg.user_id = acc.user_id
531: AND fnddoccat_tl.name = 'MISC'
532: AND fndattdoc.entity_name = 'JTF_TASKS_B'
533: AND fnddoc.datatype_id in (1,5,6)
534: AND doctype.datatype_id = fnddoc.datatype_id

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

539: CURSOR c_Signature (b_user_id NUMBER) IS
540: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
541: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
542: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
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,

Line 550: csm_debrief_headers_acc acc, asg_user asg,

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
552: WHERE fndattdoc.document_id = fnddoc_tl.document_id
553: AND fnddoc_tl.language = asg.language
554: AND fnddoc_tl.document_id = fnddoc.document_id

Line 559: AND asg.user_id = b_user_id

555: -- AND fnddoc.media_id = lobs.file_id
556: AND fnddoccat_tl.category_id = fnddoc.category_id
557: AND fnddoccat_tl.language = asg.language
558: AND fndattdoc.pk1_value = to_char(acc.debrief_header_id)
559: AND asg.user_id = b_user_id
560: AND fnddoccat_tl.name = 'SIGNATURE'
561: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
562: AND fnddoc.datatype_id =6
563: AND doctype.datatype_id = fnddoc.datatype_id

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

561: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
562: AND fnddoc.datatype_id =6
563: AND doctype.datatype_id = fnddoc.datatype_id
564: AND doctype.language = asg.language
565: AND acc.user_id = asg.user_id;
566:
567: l_dummy BOOLEAN;
568: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
569: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

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

858: IS
859: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
860: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
861: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
862: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
863: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
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,

Line 869: csm_debrief_headers_acc acc,asg_user asg,

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

Line 874: AND asg.user_id = b_user_id

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
873: AND acc.user_id = b_user_id
874: AND asg.user_id = b_user_id
875: AND fndatt.entity_name = 'CSF_DEBRIEF_HEADERS'
876: AND fndatt.pk1_value = dbfhdr.debrief_header_id
877: AND fndatt.document_id = fnddoc_tl.document_id
878: AND fnddoc_tl.document_id = fnddoc.document_id

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

894: IS
895: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
896: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
897: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
898: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 906: csm_incidents_all_acc acc,asg_user asg,

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
908: WHERE jta.task_assignment_id = b_task_assignment_id
909: AND jta.task_id = jt.task_id
910: AND jt.source_object_id = acc.incident_id

Line 920: AND asg.user_id = b_user_id

916: AND fnddoccat_tl.category_id = fnddoc.category_id
917: AND fnddoccat_tl.language = b_lang
918: AND fndattdoc.pk1_value = to_char(acc.incident_id)
919: AND acc.user_id = b_user_id
920: AND asg.user_id = b_user_id
921: AND fnddoccat_tl.name = 'MISC'
922: AND fndattdoc.entity_name = 'CS_INCIDENTS'
923: AND fnddoc.datatype_id in (1,5,6)
924: AND doctype.datatype_id = fnddoc.datatype_id

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

933: IS
934: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
935: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
936: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
937: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
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,

Line 945: csm_tasks_acc acc,asg_user asg,

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

Line 957: AND asg.user_id = b_user_id

953: AND fnddoccat_tl.category_id = fnddoc.category_id
954: AND fnddoccat_tl.language = b_lang
955: AND fndattdoc.pk1_value = to_char(acc.task_id)
956: AND acc.user_id = b_user_id
957: AND asg.user_id = b_user_id
958: AND fnddoccat_tl.name = 'MISC'
959: AND fndattdoc.entity_name = 'JTF_TASKS_B'
960: AND fnddoc.datatype_id in (1,5,6)
961: AND doctype.datatype_id = fnddoc.datatype_id

Line 970: FROM asg_user

966:
967: CURSOR l_user_csr(b_user_id IN NUMBER)
968: IS
969: SELECT LANGUAGE
970: FROM asg_user
971: WHERE user_id=b_user_id;
972:
973: l_sqlerrno VARCHAR2(20);
974: l_sqlerrmsg VARCHAR2(4000);

Line 1294: FROM asg_user

1290: --CURSOR to get userid
1291: CURSOR l_userid_csr (b_resource_id IN NUMBER)
1292: IS
1293: SELECT user_id
1294: FROM asg_user
1295: WHERE resource_id=b_resource_id;
1296:
1297: l_sqlerrno VARCHAR2(20);
1298: l_sqlerrmsg VARCHAR2(4000);

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

1476: IS
1477: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1478: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1479: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1480: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
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,

Line 1488: asg_user asg,

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
1490: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1491: AND fnddoc_tl.language = asg.language
1492: AND fnddoc_tl.document_id = fnddoc.document_id

Line 1497: AND asg.user_id = acc.user_id

1493: AND fnddoccat_tl.category_id = fnddoc.category_id
1494: AND fnddoccat_tl.language = asg.language
1495: AND fndattdoc.pk1_value = to_char(acc.incident_id)
1496: AND fndattdoc.pk1_value = to_char(b_incident_id)
1497: AND asg.user_id = acc.user_id
1498: AND fnddoccat_tl.name = 'MISC'
1499: AND fndattdoc.entity_name = 'CS_INCIDENTS'
1500: AND fnddoc.datatype_id = b_data_typeid
1501: AND doctype.datatype_id = fnddoc.datatype_id

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

1512: IS
1513: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1514: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1515: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1516: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
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,

Line 1524: asg_user asg,

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
1528: AND fnddoc_tl.document_id = fnddoc.document_id

Line 1533: AND asg.user_id = acc.user_id

1529: AND fnddoccat_tl.category_id = fnddoc.category_id
1530: AND fnddoccat_tl.language = asg.language
1531: AND fndattdoc.pk1_value = to_char(acc.task_id)
1532: AND fndattdoc.pk1_value = to_char(b_task_id)
1533: AND asg.user_id = acc.user_id
1534: AND fnddoccat_tl.name = 'MISC'
1535: AND fndattdoc.entity_name = 'JTF_TASKS_B'
1536: AND fnddoc.datatype_id = b_data_typeid
1537: AND doctype.datatype_id = fnddoc.datatype_id

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

1548: b_data_typeid IN NUMBER) IS
1549: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1550: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1551: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
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,

Line 1558: csm_debrief_headers_acc acc, asg_user asg,

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

Line 1572: AND acc.user_id = asg.user_id

1568: AND fndattdoc.entity_name = 'CSF_DEBRIEF_HEADERS'
1569: AND fnddoc.datatype_id =b_data_typeid
1570: AND doctype.datatype_id = fnddoc.datatype_id
1571: AND doctype.language = asg.language
1572: AND acc.user_id = asg.user_id
1573: AND acc.user_id=b_user_id
1574: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc
1575: WHERE cflacc.document_id = fnddoc.document_id
1576: AND cflacc.user_id = acc.user_id);