APPS.OKC_CLS_UTIL dependencies on OKC_ARTICLES_ALL

Line 299: OKC_ARTICLES_ALL ART

295: SELECT buf.buffer_seq_id buffer_seq_id,
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'

Line 327: OKC_ARTICLES_ALL ART

323: SELECT buf.buffer_seq_id buffer_seq_id,
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

Line 552: FROM okc_articles_all

548: IF l_cls_lib_in_sync = 'Y' THEN
549: -- the clauses may be in sync but not for this OU. This case should be checked
550: SELECT Count(1)
551: INTO l_cls_clauses_in_ou_count
552: FROM okc_articles_all
553: WHERE ORIG_SYSTEM_REFERENCE_CODE = 'CLS'
554: AND ORG_ID = FND_GLOBAL.ORG_ID;
555:
556: IF l_cls_clauses_in_ou_count <= 0 THEN