APPS.OKC_ARTICLE_KEYWORD_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 68: from okc_articles_all a, okc_article_versions v

64: as
65: l_art_title okc_articles_all.article_title%type;
66: begin
67: select article_title into l_art_title
68: from okc_articles_all a, okc_article_versions v
69: where a.article_id = v.article_id
70: and article_version_id = p_article_version_id;
71: return l_art_title;
72: exception when others then

Line 88: okc_article_versions v,

84: org_id,
85: v.article_language lang
86: from
87: ctxsys.ctx_pending p,
88: okc_article_versions v,
89: okc_articles_all a
90: where pnd_index_name = 'OKC_ARTICLES_CTX'
91: and a.article_id = v.article_id
92: and v.rowid = pnd_rowid;

Line 597: 'create index '||okc||'.okc_articles_ctx on okc_article_versions(article_text)

593: max_memory := round(max_memory/2);
594: cpu_count := round(cpu_count/2);
595: if db_version < 10 then sync := ' '; end if;
596: cmd :=
597: 'create index '||okc||'.okc_articles_ctx on okc_article_versions(article_text)
598: indextype is ctxsys.context
599: parameters ('''||sync||'
600: memory '||max_memory||'
601: datastore '||apps||'.okc_articles_datastore