DBA Data[Home] [Help]

APPS.OKC_CLS_UTIL dependencies on OKC_ARTICLE_ADOPTIONS

Line 312: FROM okc_article_ADOPTIONS ADP

308: AND ver.ARTICLE_STATUS = 'APPROVED'
309:
310: AND (art.ORG_ID = FND_GLOBAL.ORG_ID
311: OR (exists ( SELECT 1
312: FROM okc_article_ADOPTIONS ADP
313: WHERE adp.global_article_version_id = ver.article_version_id
314: AND adp.adoption_type = 'ADOPTED'
315: AND adp.local_org_id = FND_GLOBAL.ORG_ID
316: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 336: FROM okc_article_ADOPTIONS ADP

332: AND SYSDATE BETWEEN Nvl(ver.start_date,SYSDATE-1) AND Nvl(ver.end_date, SYSDATE+1)
333: AND ver.ARTICLE_STATUS = 'APPROVED'
334: AND (art.ORG_ID = FND_GLOBAL.ORG_ID
335: OR (exists ( SELECT 1
336: FROM okc_article_ADOPTIONS ADP
337: WHERE adp.global_article_version_id = ver.article_version_id
338: AND adp.adoption_type = 'ADOPTED'
339: AND adp.local_org_id = FND_GLOBAL.ORG_ID
340: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')