APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_ARTICLES_ALL

Line 2008: from okc_articles_all aa, okc_review_upld_terms rev

2004:
2005: cursor get_clause_type_csr(p_review_upld_terms_id NUMBER) is
2006: SELECT
2007: aa.article_type
2008: from okc_articles_all aa, okc_review_upld_terms rev
2009: where
2010: rev.article_id = aa.article_id
2011: and rev.review_upld_terms_id = p_review_upld_terms_id;
2012:

Line 2030: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

2026: l_parent_id NUMBER;
2027: l_doc_num_scheme NUMBER;
2028: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
2029: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
2030: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2031: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
2032: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
2033: -- 2 way word sync with clause edit
2034: l_prof_value VARCHAR2(1);

Line 3542: OKC_ARTICLES_ALL ART,

3538: SYSDATE,
3539: FND_GLOBAL.USER_ID,
3540: SYSDATE
3541: FROM OKC_K_ARTICLES_B KART,
3542: OKC_ARTICLES_ALL ART,
3543: OKC_ARTICLE_VERSIONS VER
3544: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3545: AND ART.ARTICLE_ID = VER.ARTICLE_ID
3546: AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID

Line 3654: OKC_ARTICLES_ALL ART,

3650: AND EXISTS
3651: (
3652: SELECT 1
3653: FROM OKC_K_ARTICLES_B KART,
3654: OKC_ARTICLES_ALL ART,
3655: OKC_ARTICLE_VERSIONS VER
3656: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3657: AND ART.ARTICLE_ID = VER.ARTICLE_ID
3658: AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID

Line 3684: OKC_ARTICLES_ALL ART,

3680: AND EXISTS
3681: (
3682: SELECT 1
3683: FROM OKC_K_ARTICLES_B KART,
3684: OKC_ARTICLES_ALL ART,
3685: OKC_ARTICLE_VERSIONS VER
3686: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3687: AND ART.ARTICLE_ID = VER.ARTICLE_ID
3688: AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID

Line 3753: OKC_ARTICLES_ALL ART

3749: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3750: AND OBJECT_TYPE = 'ARTICLE'
3751: AND EXISTS (SELECT 1
3752: FROM OKC_K_ARTICLES_B KART,
3753: OKC_ARTICLES_ALL ART
3754: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3755: AND KART.ID = UT.OBJECT_ID
3756: AND KART.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3757: AND KART.DOCUMENT_ID = UT.DOCUMENT_ID

Line 4050: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

4046:
4047: update okc_review_upld_terms rev
4048: set action = 'DELETED',
4049: object_title = (select nvl(ver.display_name,art. article_title)
4050: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4051: where kart.id = rev.object_id
4052: and kart.sav_sae_id = art.article_id
4053: and kart.article_version_id = ver.article_version_id
4054: and art.article_id = ver.article_id)