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 2942: okc_articles_all art

2938: kart.amendment_operation_code amendment_operation_code,
2939: kart.amendment_description amendment_description
2940: FROM OKC_K_ARTICLES_B KART,
2941: okc_terms_templates_all tmpl,
2942: okc_articles_all art
2943: WHERE kart.document_id = tmpl.template_id
2944: AND kart.sav_sae_id = art.article_id
2945: AND DOCUMENT_TYPE=p_doc_type
2946: AND DOCUMENT_ID =p_doc_id

Line 2986: okc_articles_all art

2982: Rule.rule_id rule_id,
2983: Rule.rule_name rule_name
2984: FROM okc_xprt_clauses_v rule,
2985: okc_terms_templates_all tmpl,
2986: okc_articles_all art
2987: WHERE rule.template_id = tmpl.template_id
2988: AND tmpl.template_id = p_doc_id
2989: AND art.article_id = rule.clause_id
2990: AND

Line 3030: OKC_ARTICLES_ALL ART

3026: kart.amendment_operation_code amendment_operation_code,
3027: kart.amendment_description amendment_description
3028: FROM OKC_K_ARTICLES_B KART,
3029: OKC_ARTICLE_VERSIONS VERS,
3030: OKC_ARTICLES_ALL ART
3031: WHERE DOCUMENT_TYPE=p_doc_type
3032: AND DOCUMENT_ID =p_doc_id
3033: AND VERS.ARTICLE_VERSION_ID=KART.ARTICLE_VERSION_ID
3034: AND ART.ARTICLE_ID = KART.SAV_SAE_ID

Line 3819: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,

3815: IS
3816:
3817: /*
3818: TYPE draft_art_rec_type IS RECORD (
3819: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
3820: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
3821: title OKC_QA_ERRORS_T.title%TYPE,
3822: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE
3823: );

Line 3873: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

3869: SELECT DRA.article_id, DRA.article_version_id,
3870: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
3871: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
3872: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
3873: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
3874: WHERE DRA.template_id = p_doc_id and
3875: DRA.selected_yn = 'Y' and
3876: DRA.article_id = ART.article_id and
3877: VER.article_version_id = DRA.article_version_id

Line 4293: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

4289: SELECT DRA.article_id article_id, DRA.article_version_id,
4290: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section
4291: NVL(VER.display_name, ART.article_title) title,NVL(DRA.section_name, '*') section
4292: FROM OKC_TMPL_DRAFT_CLAUSES DRA,
4293: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4294: WHERE DRA.template_id = p_doc_id and
4295: DRA.selected_yn = 'Y' and
4296: DRA.article_id = ART.article_id and
4297: VER.article_version_id = DRA.article_version_id

Line 4452: OKC_ARTICLES_ALL ART,

4448: KART.SCN_ID SCN_ID,
4449: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,KART.ARTICLE_VERSION_ID) TITLE,
4450: Decode(ART.standard_yn,'N',KART.ref_article_id,NULL) STD_ART_ID
4451: FROM OKC_K_ARTICLES_B KART,
4452: OKC_ARTICLES_ALL ART,
4453: OKC_ARTICLE_VERSIONS VERS
4454: WHERE KART.DOCUMENT_TYPE = p_doc_type
4455: AND KART.DOCUMENT_ID = p_doc_id
4456: AND KART.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID

Line 4512: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

4508: Nvl(ver.display_name, art.article_title) title,
4509: xprt.rule_id rule_id,
4510: xprt.rule_name rule_name
4511: FROM OKC_XPRT_CLAUSES_V XPRT,
4512: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4513: WHERE XPRT.template_id = p_doc_id
4514: AND ART.article_id = XPRT.clause_id
4515: AND VER.article_id = ART.article_id
4516: AND VER.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(