APPS.OKC_ARTICLE_KEYWORD_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 70: from okc_articles_all a, okc_article_versions v

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

Line 90: okc_article_versions v,

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

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

603: end if;
604:
605: if db_version < 10 then sync := ' '; end if;
606: cmd :=
607: 'create index '||okc||'.okc_articles_ctx on '||okc||'.okc_article_versions(article_text)
608: indextype is ctxsys.context
609: parameters ('''||sync||'
610: memory '||max_memory||'
611: datastore '||apps||'.okc_articles_datastore