APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_ARTICLES_ALL

Line 1972: from okc_articles_all aa, okc_review_upld_terms rev

1968:
1969: cursor get_clause_type_csr(p_review_upld_terms_id NUMBER) is
1970: SELECT
1971: aa.article_type
1972: from okc_articles_all aa, okc_review_upld_terms rev
1973: where
1974: rev.article_id = aa.article_id
1975: and rev.review_upld_terms_id = p_review_upld_terms_id;
1976:

Line 1994: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

1990: l_parent_id NUMBER;
1991: l_doc_num_scheme NUMBER;
1992: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
1993: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1994: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
1995: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1996: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
1997:
1998:

Line 3430: OKC_ARTICLES_ALL ART,

3426: SYSDATE,
3427: FND_GLOBAL.USER_ID,
3428: SYSDATE
3429: FROM OKC_K_ARTICLES_B KART,
3430: OKC_ARTICLES_ALL ART,
3431: OKC_ARTICLE_VERSIONS VER
3432: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3433: AND ART.ARTICLE_ID = VER.ARTICLE_ID
3434: AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID

Line 3538: OKC_ARTICLES_ALL ART,

3534: AND EXISTS
3535: (
3536: SELECT 1
3537: FROM OKC_K_ARTICLES_B KART,
3538: OKC_ARTICLES_ALL ART,
3539: OKC_ARTICLE_VERSIONS VER
3540: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3541: AND ART.ARTICLE_ID = VER.ARTICLE_ID
3542: AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID

Line 3600: OKC_ARTICLES_ALL ART

3596: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3597: AND OBJECT_TYPE = 'ARTICLE'
3598: AND EXISTS (SELECT 1
3599: FROM OKC_K_ARTICLES_B KART,
3600: OKC_ARTICLES_ALL ART
3601: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3602: AND KART.ID = UT.OBJECT_ID
3603: AND KART.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3604: AND KART.DOCUMENT_ID = UT.DOCUMENT_ID

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

3885:
3886: update okc_review_upld_terms rev
3887: set action = 'DELETED',
3888: object_title = (select nvl(ver.display_name,art. article_title)
3889: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
3890: where kart.id = rev.object_id
3891: and kart.sav_sae_id = art.article_id
3892: and kart.article_version_id = ver.article_version_id
3893: and art.article_id = ver.article_id)