DBA Data[Home] [Help]

APPS.CS_KB_CTX_PKG dependencies on FND_DOCUMENTS_TL

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 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 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