DBA Data[Home] [Help]

APPS.IEM_KNOWLEDGEBASE_PUB dependencies on IEM_DOC_USAGE_STATS

Line 424: SELECT a.DOCUMENT_ID,(select count(*) from iem_doc_usage_stats where kb_doc_id=a.document_id) rank,

420: l_doc_count number;
421: l_rule_id number;
422: l_cat_counter number;
423: cursor kb_results_csr is
424: SELECT a.DOCUMENT_ID,(select count(*) from iem_doc_usage_stats where kb_doc_id=a.document_id) rank,
425: a.SCORE,
426: a.KB_REPOSITORY_NAME,
427: a.KB_CATEGORY_NAME,
428: a.DOCUMENT_TITLE,