eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_QA_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 226: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

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
230: );

Line 1558: okc_article_versions vers,

1554: var.variable_code variable_code,
1555: busvar.variable_name variable_name,
1556: busdoc.name doc_type
1557: FROM okc_k_articles_b kart,
1558: okc_article_versions vers,
1559: okc_allowed_tmpl_usages allwd ,
1560: okc_article_variables var,
1561: okc_bus_variables_vl busvar ,
1562: okc_bus_doc_types_v busdoc

Line 1569: FROM OKC_ARTICLE_VERSIONS

1565: and allwd.template_id=kart.document_id
1566: and kart.sav_sae_id=vers.article_id
1567: and vers.article_status='APPROVED'
1568: AND vers.start_date = (SELECT max(start_date)
1569: FROM OKC_ARTICLE_VERSIONS
1570: WHERE article_id= kart.sav_sae_id
1571: AND article_status='APPROVED')
1572: and vers.article_version_id=var.article_version_id
1573: and busvar.variable_code=var.variable_code

Line 1634: okc_article_versions vers,

1630: var.variable_code variable_code,
1631: busvar.variable_name variable_name,
1632: busdoc.name doc_type
1633: FROM okc_k_articles_b kart,
1634: okc_article_versions vers,
1635: okc_allowed_tmpl_usages allwd ,
1636: okc_article_variables var,
1637: okc_bus_variables_vl busvar ,
1638: okc_bus_doc_types_v busdoc

Line 1654: FROM OKC_ARTICLE_VERSIONS

1650: p_doc_id)
1651: /* existing logic of determining clause version
1652: and vers.article_status='APPROVED'
1653: AND vers.start_date = (select max(start_date)
1654: FROM OKC_ARTICLE_VERSIONS
1655: WHERE article_id= kart.sav_sae_id
1656: AND article_status='APPROVED')
1657: */
1658: and vers.article_version_id=var.article_version_id

Line 1692: okc_article_versions vers,

1688: busvar.variable_name variable_name,
1689: busdoc.name doc_type
1690: FROM okc_xprt_clauses_v rule,
1691: okc_allowed_tmpl_usages allwd ,
1692: okc_article_versions vers,
1693: okc_article_variables var,
1694: okc_bus_variables_vl busvar ,
1695: okc_bus_doc_types_v busdoc
1696: WHERE rule.template_id = p_doc_id

Line 2888: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS

2884: kart.amendment_description amendment_description
2885: FROM OKC_K_ARTICLES_B KART
2886: WHERE DOCUMENT_TYPE=p_doc_type
2887: AND DOCUMENT_ID =p_doc_id
2888: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS
2889: WHERE VERS.ARTICLE_ID=KART.SAV_SAE_ID
2890: AND VERS.ARTICLE_STATUS='APPROVED'
2891: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2892: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 2918: OKC_ARTICLE_VERSIONS VER

2914: (
2915: ( art.org_id <> tmpl.org_id
2916: AND NOT EXISTS ( SELECT 'X'
2917: FROM OKC_ARTICLE_ADOPTIONS ADP,
2918: OKC_ARTICLE_VERSIONS VER
2919: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2920: AND VER.article_id = KART.SAV_SAE_ID
2921: AND ADP.LOCAL_ORG_ID = tmpl.org_id
2922: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 2931: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS

2927: <= nvl(VER.end_date, nvl(p_article_effective_date,sysdate) +1)
2928: )
2929: ) OR
2930: ( art.org_id = tmpl.org_id
2931: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS
2932: WHERE VERS.ARTICLE_ID=KART.SAV_SAE_ID
2933: -- modified to include DRAFT and REJECTED statuses also
2934: --AND VERS.ARTICLE_STATUS='APPROVED'
2935: AND VERS.ARTICLE_STATUS in ('APPROVED', 'DRAFT' , 'REJECTED')

Line 2961: OKC_ARTICLE_VERSIONS VER

2957: (
2958: ( art.org_id <> tmpl.org_id
2959: AND NOT EXISTS ( SELECT 'X'
2960: FROM OKC_ARTICLE_ADOPTIONS ADP,
2961: OKC_ARTICLE_VERSIONS VER
2962: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2963: AND VER.article_id = rule.clause_id
2964: AND ADP.LOCAL_ORG_ID = tmpl.org_id
2965: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 2975: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS

2971: )
2972: )
2973: OR
2974: ( art.org_id = tmpl.org_id
2975: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS
2976: WHERE VERS.ARTICLE_ID=rule.clause_id
2977: AND VERS.ARTICLE_STATUS in ('APPROVED', 'DRAFT' , 'REJECTED')
2978: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2979: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date,

Line 2995: OKC_ARTICLE_VERSIONS VERS,

2991: vers.start_date start_date,
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

Line 3018: OKC_ARTICLE_VERSIONS VERS,

3014: KART.SCN_ID SCN_ID,
3015: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
3016: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
3017: FROM OKC_K_ARTICLES_B KART,
3018: OKC_ARTICLE_VERSIONS VERS,
3019: OKC_ARTICLE_VERSIONS VERS1,
3020: OKC_TEMPLATE_USAGES USG,
3021: OKC_TERMS_TEMPLATES_ALL TMPL
3022: WHERE KART.DOCUMENT_TYPE=p_doc_type

Line 3019: OKC_ARTICLE_VERSIONS VERS1,

3015: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
3016: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
3017: FROM OKC_K_ARTICLES_B KART,
3018: OKC_ARTICLE_VERSIONS VERS,
3019: OKC_ARTICLE_VERSIONS VERS1,
3020: OKC_TEMPLATE_USAGES USG,
3021: OKC_TERMS_TEMPLATES_ALL TMPL
3022: WHERE KART.DOCUMENT_TYPE=p_doc_type
3023: AND KART.DOCUMENT_ID =p_doc_id

Line 3786: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

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: );
3790:

Line 3796: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;

3792: */
3793:
3794: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3795: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3796: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3797: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3798:
3799: l_api_name CONSTANT VARCHAR2(30) := 'check_validate_draft_articles';
3800: l_indx NUMBER;

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 4419: OKC_ARTICLE_VERSIONS VERS

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
4423: AND KART.SAV_SAE_ID = ART.ARTICLE_ID;

Line 4435: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD

4431: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4432: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4433: KART.SCN_ID SCN_ID,
4434: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4435: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4436: WHERE KART.DOCUMENT_TYPE = p_doc_type
4437: AND KART.DOCUMENT_ID = p_doc_id
4438: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4439: AND KART.SAV_SAE_ID = VERS.ARTICLE_ID

Line 4441: FROM OKC_ARTICLE_VERSIONS

4437: AND KART.DOCUMENT_ID = p_doc_id
4438: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4439: AND KART.SAV_SAE_ID = VERS.ARTICLE_ID
4440: AND nvl(VERS.START_DATE,sysdate) = ( SELECT nvl(MAX(START_DATE),sysdate)
4441: FROM OKC_ARTICLE_VERSIONS
4442: WHERE ARTICLE_ID=VERS.ARTICLE_ID);
4443: */
4444:
4445: -- 11.5.10+ modified cursor to get the version from OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id

Line 4455: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD

4451: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4452: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4453: KART.SCN_ID SCN_ID,
4454: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4455: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4456: WHERE KART.DOCUMENT_TYPE = p_doc_type
4457: AND KART.DOCUMENT_ID = p_doc_id
4458: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4459: AND KART.SAV_SAE_ID = VERS.ARTICLE_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(