APPS.OKC_TERMS_QA_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 2917: FROM OKC_ARTICLE_ADOPTIONS ADP,

2913: AND
2914: (
2915: ( art.org_id <> tmpl.org_id
2916: AND NOT EXISTS ( SELECT 'X'
2917: FROM OKC_ARTICLE_ADOPTIONS ADP,
2918: OKC_ARTICLE_VERSIONS VER
2919: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2920: AND VER.article_id = KART.SAV_SAE_ID
2921: AND ADP.LOCAL_ORG_ID = tmpl.org_id

Line 2960: FROM OKC_ARTICLE_ADOPTIONS ADP,

2956: AND
2957: (
2958: ( art.org_id <> tmpl.org_id
2959: AND NOT EXISTS ( SELECT 'X'
2960: FROM OKC_ARTICLE_ADOPTIONS ADP,
2961: OKC_ARTICLE_VERSIONS VER
2962: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2963: AND VER.article_id = rule.clause_id
2964: AND ADP.LOCAL_ORG_ID = tmpl.org_id

Line 3036: FROM OKC_ARTICLE_ADOPTIONS ADP

3032: AND trunc(NVL(USG.ARTICLE_EFFECTIVE_DATE,SYSDATE)) BETWEEN trunc(VERS.START_DATE) AND NVL(VERS.END_DATE,SYSDATE)
3033: AND VERS.ARTICLE_STATUS = 'APPROVED'
3034: AND (EXISTS
3035: (SELECT 1
3036: FROM OKC_ARTICLE_ADOPTIONS ADP
3037: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
3038: AND ADP.ADOPTION_TYPE = 'ADOPTED'
3039: AND ADP.ADOPTION_STATUS = 'APPROVED'
3040: AND ADP.LOCAL_ORG_ID = TMPL.ORG_ID)

Line 3044: FROM OKC_ARTICLE_ADOPTIONS ADP

3040: AND ADP.LOCAL_ORG_ID = TMPL.ORG_ID)
3041: OR
3042: NOT EXISTS
3043: (SELECT 1
3044: FROM OKC_ARTICLE_ADOPTIONS ADP
3045: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS1.ARTICLE_VERSION_ID
3046: AND ADP.ADOPTION_TYPE = 'ADOPTED'
3047: AND ADP.LOCAL_ORG_ID = TMPL.ORG_ID)
3048: ) ;