APPS.OKC_TERMS_QA_PVT dependencies on OKC_ARTICLES_ALL

Line 225: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,

221:
222: /* expert commented out
223: -- new type to store xprt clause details
224: TYPE xprt_article_rec_type IS RECORD (
225: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
226: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
227: title OKC_QA_ERRORS_T.title%TYPE,
228: rule_id OKC_XPRT_CLAUSES_V.rule_id%TYPE,
229: rule_name OKC_XPRT_CLAUSES_V.rule_name%TYPE

Line 2908: okc_articles_all art

2904: kart.amendment_operation_code amendment_operation_code,
2905: kart.amendment_description amendment_description
2906: FROM OKC_K_ARTICLES_B KART,
2907: okc_terms_templates_all tmpl,
2908: okc_articles_all art
2909: WHERE kart.document_id = tmpl.template_id
2910: AND kart.sav_sae_id = art.article_id
2911: AND DOCUMENT_TYPE=p_doc_type
2912: AND DOCUMENT_ID =p_doc_id

Line 2952: okc_articles_all art

2948: Rule.rule_id rule_id,
2949: Rule.rule_name rule_name
2950: FROM okc_xprt_clauses_v rule,
2951: okc_terms_templates_all tmpl,
2952: okc_articles_all art
2953: WHERE rule.template_id = tmpl.template_id
2954: AND tmpl.template_id = p_doc_id
2955: AND art.article_id = rule.clause_id
2956: AND

Line 2996: OKC_ARTICLES_ALL ART

2992: kart.amendment_operation_code amendment_operation_code,
2993: kart.amendment_description amendment_description
2994: FROM OKC_K_ARTICLES_B KART,
2995: OKC_ARTICLE_VERSIONS VERS,
2996: OKC_ARTICLES_ALL ART
2997: WHERE DOCUMENT_TYPE=p_doc_type
2998: AND DOCUMENT_ID =p_doc_id
2999: AND VERS.ARTICLE_VERSION_ID=KART.ARTICLE_VERSION_ID
3000: AND ART.ARTICLE_ID = KART.SAV_SAE_ID

Line 3785: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,

3781: IS
3782:
3783: /*
3784: TYPE draft_art_rec_type IS RECORD (
3785: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
3786: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
3787: title OKC_QA_ERRORS_T.title%TYPE,
3788: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE
3789: );

Line 3839: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

3835: SELECT DRA.article_id, DRA.article_version_id,
3836: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
3837: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
3838: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
3839: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
3840: WHERE DRA.template_id = p_doc_id and
3841: DRA.selected_yn = 'Y' and
3842: DRA.article_id = ART.article_id and
3843: VER.article_version_id = DRA.article_version_id

Line 4259: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

4255: SELECT DRA.article_id article_id, DRA.article_version_id,
4256: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
4257: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
4258: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
4259: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4260: WHERE DRA.template_id = p_doc_id and
4261: DRA.selected_yn = 'Y' and
4262: DRA.article_id = ART.article_id and
4263: VER.article_version_id = DRA.article_version_id

Line 4418: OKC_ARTICLES_ALL ART,

4414: KART.SCN_ID SCN_ID,
4415: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,KART.ARTICLE_VERSION_ID) TITLE,
4416: Decode(ART.standard_yn,'N',KART.ref_article_id,NULL) STD_ART_ID
4417: FROM OKC_K_ARTICLES_B KART,
4418: OKC_ARTICLES_ALL ART,
4419: OKC_ARTICLE_VERSIONS VERS
4420: WHERE KART.DOCUMENT_TYPE = p_doc_type
4421: AND KART.DOCUMENT_ID = p_doc_id
4422: AND KART.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID

Line 4478: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

4474: Nvl(ver.display_name, art.article_title) title,
4475: xprt.rule_id rule_id,
4476: xprt.rule_name rule_name
4477: FROM OKC_XPRT_CLAUSES_V XPRT,
4478: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4479: WHERE XPRT.template_id = p_doc_id
4480: AND ART.article_id = XPRT.clause_id
4481: AND VER.article_id = ART.article_id
4482: AND VER.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(