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.CS_KB_CTX_PKG dependencies on FND_DOCUMENTS

Line 576: fnd_documents fd,

572: -- Changed the cursor to fix 11739796
573: CURSOR c8(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
574: SELECT fdtl.title, fdtl.description, fl.file_name, fad.document_id
575: FROM fnd_attached_documents fad,
576: fnd_documents fd,
577: fnd_documents_tl fdtl,
578: fnd_lobs fl
579: WHERE fad.document_id = fd.document_id
580: AND fd.document_id = fdtl.document_id

Line 577: fnd_documents_tl fdtl,

573: CURSOR c8(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
574: SELECT fdtl.title, fdtl.description, fl.file_name, fad.document_id
575: FROM fnd_attached_documents fad,
576: fnd_documents fd,
577: fnd_documents_tl fdtl,
578: fnd_lobs fl
579: WHERE fad.document_id = fd.document_id
580: AND fd.document_id = fdtl.document_id
581: AND fl.file_id = fd.media_id

Line 1062: fnd_documents fd,

1058: IS
1059: /* CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1060: SELECT fdtl.title, fdtl.description, fl.file_name, fl.file_data
1061: FROM fnd_attached_documents fad,
1062: fnd_documents fd,
1063: fnd_documents_tl fdtl,
1064: fnd_lobs fl
1065: WHERE fad.document_id = fd.document_id
1066: AND fd.document_id = fdtl.document_id

Line 1063: fnd_documents_tl fdtl,

1059: /* CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1060: SELECT fdtl.title, fdtl.description, fl.file_name, fl.file_data
1061: FROM fnd_attached_documents fad,
1062: fnd_documents fd,
1063: fnd_documents_tl fdtl,
1064: fnd_lobs fl
1065: WHERE fad.document_id = fd.document_id
1066: AND fd.document_id = fdtl.document_id
1067: AND fl.file_id = fd.media_id

Line 1075: fnd_documents fd,

1071: -- Changed the cursor for bug 8815880,11739796
1072: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1073: SELECT fdtl.title, fdtl.description, fl.file_name, fd.url, fst.short_text
1074: FROM fnd_attached_documents fad,
1075: fnd_documents fd,
1076: fnd_documents_tl fdtl,
1077: fnd_lobs fl,
1078: fnd_documents_short_text fst
1079: WHERE fad.document_id = fd.document_id

Line 1076: fnd_documents_tl fdtl,

1072: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1073: SELECT fdtl.title, fdtl.description, fl.file_name, fd.url, fst.short_text
1074: FROM fnd_attached_documents fad,
1075: fnd_documents fd,
1076: fnd_documents_tl fdtl,
1077: fnd_lobs fl,
1078: fnd_documents_short_text fst
1079: WHERE fad.document_id = fd.document_id
1080: AND fd.document_id = fdtl.document_id

Line 1078: fnd_documents_short_text fst

1074: FROM fnd_attached_documents fad,
1075: fnd_documents fd,
1076: fnd_documents_tl fdtl,
1077: fnd_lobs fl,
1078: fnd_documents_short_text fst
1079: WHERE fad.document_id = fd.document_id
1080: AND fd.document_id = fdtl.document_id
1081: AND fl.file_id(+) = fd.media_id
1082: AND fst.media_id(+) = fd.media_id

Line 1172: fnd_documents fd

1168: where se.set_id = c_setid;
1169: */
1170: SELECT fad.document_id
1171: FROM fnd_attached_documents fad,
1172: fnd_documents fd
1173: WHERE fad.document_id = fd.document_id
1174: AND fad.entity_name = 'CS_KB_SETS_B'
1175: AND fad.pk1_value = c_setid;
1176: l_data VARCHAR2(32000);