APPS.OKC_TERMS_QA_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 2951: FROM OKC_ARTICLE_ADOPTIONS ADP,

2947: AND
2948: (
2949: ( art.org_id <> tmpl.org_id
2950: AND NOT EXISTS ( SELECT 'X'
2951: FROM OKC_ARTICLE_ADOPTIONS ADP,
2952: OKC_ARTICLE_VERSIONS VER
2953: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2954: AND VER.article_id = KART.SAV_SAE_ID
2955: AND ADP.LOCAL_ORG_ID = tmpl.org_id

Line 2994: FROM OKC_ARTICLE_ADOPTIONS ADP,

2990: AND
2991: (
2992: ( art.org_id <> tmpl.org_id
2993: AND NOT EXISTS ( SELECT 'X'
2994: FROM OKC_ARTICLE_ADOPTIONS ADP,
2995: OKC_ARTICLE_VERSIONS VER
2996: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2997: AND VER.article_id = rule.clause_id
2998: AND ADP.LOCAL_ORG_ID = tmpl.org_id

Line 3070: FROM OKC_ARTICLE_ADOPTIONS ADP

3066: AND trunc(NVL(USG.ARTICLE_EFFECTIVE_DATE,SYSDATE)) BETWEEN trunc(VERS.START_DATE) AND NVL(VERS.END_DATE,SYSDATE)
3067: AND VERS.ARTICLE_STATUS = 'APPROVED'
3068: AND (EXISTS
3069: (SELECT 1
3070: FROM OKC_ARTICLE_ADOPTIONS ADP
3071: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
3072: AND ADP.ADOPTION_TYPE = 'ADOPTED'
3073: AND ADP.ADOPTION_STATUS = 'APPROVED'
3074: AND ADP.LOCAL_ORG_ID = TMPL.ORG_ID)

Line 3078: FROM OKC_ARTICLE_ADOPTIONS ADP

3074: AND ADP.LOCAL_ORG_ID = TMPL.ORG_ID)
3075: OR
3076: NOT EXISTS
3077: (SELECT 1
3078: FROM OKC_ARTICLE_ADOPTIONS ADP
3079: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS1.ARTICLE_VERSION_ID
3080: AND ADP.ADOPTION_TYPE = 'ADOPTED'
3081: AND ADP.LOCAL_ORG_ID = TMPL.ORG_ID)
3082: ) ;