DBA Data[Home] [Help]

APPS.OKC_CLS_UTIL dependencies on OKC_ARTICLE_VERSIONS

Line 300: ,OKC_ARTICLE_VERSIONS ver

296: art.ARTICLE_ID art_id,
297: ver.ARTICLE_VERSION_ID ver_id
298: FROM OKC_CLS_CLAUSE_BUFFER_T buf,
299: OKC_ARTICLES_ALL ART
300: ,OKC_ARTICLE_VERSIONS ver
301: WHERE buf.token = param_token
302: AND art.article_number = buf.CLAUSE_NUMBER
303: AND art.ORIG_SYSTEM_REFERENCE_CODE = 'CLS'
304: AND art.ORIG_SYSTEM_REFERENCE_ID1 = buf.CLAUSE_CLS_ID

Line 328: ,OKC_ARTICLE_VERSIONS ver

324: art.ARTICLE_ID art_id,
325: ver.ARTICLE_VERSION_ID ver_id
326: FROM OKC_CLS_CLAUSE_BUFFER_T buf,
327: OKC_ARTICLES_ALL ART
328: ,OKC_ARTICLE_VERSIONS ver
329: WHERE buf.token = '96aebdf2d5525841ddcf5bb9097714e0'
330: AND art.article_number = buf.CLAUSE_NUMBER
331: AND art.article_id = ver.article_id
332: AND SYSDATE BETWEEN Nvl(ver.start_date,SYSDATE-1) AND Nvl(ver.end_date, SYSDATE+1)