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 1577: okc_article_versions vers,

1573: var.variable_code variable_code,
1574: busvar.variable_name variable_name,
1575: busdoc.name doc_type
1576: FROM okc_k_articles_b kart,
1577: okc_article_versions vers,
1578: okc_allowed_tmpl_usages allwd ,
1579: okc_article_variables var,
1580: okc_bus_variables_vl busvar ,
1581: okc_bus_doc_types_v busdoc

Line 1588: FROM OKC_ARTICLE_VERSIONS

1584: and allwd.template_id=kart.document_id
1585: and kart.sav_sae_id=vers.article_id
1586: and vers.article_status='APPROVED'
1587: AND vers.start_date = (SELECT max(start_date)
1588: FROM OKC_ARTICLE_VERSIONS
1589: WHERE article_id= kart.sav_sae_id
1590: AND article_status='APPROVED')
1591: and vers.article_version_id=var.article_version_id
1592: and busvar.variable_code=var.variable_code

Line 1653: okc_article_versions vers,

1649: var.variable_code variable_code,
1650: busvar.variable_name variable_name,
1651: busdoc.name doc_type
1652: FROM okc_k_articles_b kart,
1653: okc_article_versions vers,
1654: okc_allowed_tmpl_usages allwd ,
1655: okc_article_variables var,
1656: okc_bus_variables_vl busvar ,
1657: okc_bus_doc_types_v busdoc

Line 1673: FROM OKC_ARTICLE_VERSIONS

1669: p_doc_id)
1670: /* existing logic of determining clause version
1671: and vers.article_status='APPROVED'
1672: AND vers.start_date = (select max(start_date)
1673: FROM OKC_ARTICLE_VERSIONS
1674: WHERE article_id= kart.sav_sae_id
1675: AND article_status='APPROVED')
1676: */
1677: and vers.article_version_id=var.article_version_id

Line 1711: okc_article_versions vers,

1707: busvar.variable_name variable_name,
1708: busdoc.name doc_type
1709: FROM okc_xprt_clauses_v rule,
1710: okc_allowed_tmpl_usages allwd ,
1711: okc_article_versions vers,
1712: okc_article_variables var,
1713: okc_bus_variables_vl busvar ,
1714: okc_bus_doc_types_v busdoc
1715: WHERE rule.template_id = p_doc_id

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

2918: kart.amendment_description amendment_description
2919: FROM OKC_K_ARTICLES_B KART
2920: WHERE DOCUMENT_TYPE=p_doc_type
2921: AND DOCUMENT_ID =p_doc_id
2922: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS
2923: WHERE VERS.ARTICLE_ID=KART.SAV_SAE_ID
2924: AND VERS.ARTICLE_STATUS='APPROVED'
2925: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2926: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 2952: OKC_ARTICLE_VERSIONS VER

2948: (
2949: ( art.org_id <> tmpl.org_id
2950: AND NOT EXISTS ( SELECT 'X'
2951: FROM OKC_ARTICLE_ADOPTIONS ADP,
2952: OKC_ARTICLE_VERSIONS VER
2953: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2954: AND VER.article_id = KART.SAV_SAE_ID
2955: AND ADP.LOCAL_ORG_ID = tmpl.org_id
2956: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')

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

2961: <= nvl(VER.end_date, nvl(p_article_effective_date,sysdate) +1)
2962: )
2963: ) OR
2964: ( art.org_id = tmpl.org_id
2965: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS
2966: WHERE VERS.ARTICLE_ID=KART.SAV_SAE_ID
2967: -- modified to include DRAFT and REJECTED statuses also
2968: --AND VERS.ARTICLE_STATUS='APPROVED'
2969: AND VERS.ARTICLE_STATUS in ('APPROVED', 'DRAFT' , 'REJECTED')

Line 2995: OKC_ARTICLE_VERSIONS VER

2991: (
2992: ( art.org_id <> tmpl.org_id
2993: AND NOT EXISTS ( SELECT 'X'
2994: FROM OKC_ARTICLE_ADOPTIONS ADP,
2995: OKC_ARTICLE_VERSIONS VER
2996: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
2997: AND VER.article_id = rule.clause_id
2998: AND ADP.LOCAL_ORG_ID = tmpl.org_id
2999: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')

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

3005: )
3006: )
3007: OR
3008: ( art.org_id = tmpl.org_id
3009: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VERSIONS VERS
3010: WHERE VERS.ARTICLE_ID=rule.clause_id
3011: AND VERS.ARTICLE_STATUS in ('APPROVED', 'DRAFT' , 'REJECTED')
3012: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
3013: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date,

Line 3029: OKC_ARTICLE_VERSIONS VERS,

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

Line 3052: OKC_ARTICLE_VERSIONS VERS,

3048: KART.SCN_ID SCN_ID,
3049: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
3050: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
3051: FROM OKC_K_ARTICLES_B KART,
3052: OKC_ARTICLE_VERSIONS VERS,
3053: OKC_ARTICLE_VERSIONS VERS1,
3054: OKC_TEMPLATE_USAGES USG,
3055: OKC_TERMS_TEMPLATES_ALL TMPL
3056: WHERE KART.DOCUMENT_TYPE=p_doc_type

Line 3053: OKC_ARTICLE_VERSIONS VERS1,

3049: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
3050: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
3051: FROM OKC_K_ARTICLES_B KART,
3052: OKC_ARTICLE_VERSIONS VERS,
3053: OKC_ARTICLE_VERSIONS VERS1,
3054: OKC_TEMPLATE_USAGES USG,
3055: OKC_TERMS_TEMPLATES_ALL TMPL
3056: WHERE KART.DOCUMENT_TYPE=p_doc_type
3057: AND KART.DOCUMENT_ID =p_doc_id

Line 3820: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

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

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

3826: */
3827:
3828: TYPE art_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
3829: TYPE ver_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
3830: TYPE title_tbl_type IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER;
3831: TYPE sec_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER;
3832:
3833: l_api_name CONSTANT VARCHAR2(30) := 'check_validate_draft_articles';
3834: l_indx NUMBER;

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

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

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

4465: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4466: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4467: KART.SCN_ID SCN_ID,
4468: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4469: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4470: WHERE KART.DOCUMENT_TYPE = p_doc_type
4471: AND KART.DOCUMENT_ID = p_doc_id
4472: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4473: AND KART.SAV_SAE_ID = VERS.ARTICLE_ID

Line 4475: FROM OKC_ARTICLE_VERSIONS

4471: AND KART.DOCUMENT_ID = p_doc_id
4472: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4473: AND KART.SAV_SAE_ID = VERS.ARTICLE_ID
4474: AND nvl(VERS.START_DATE,sysdate) = ( SELECT nvl(MAX(START_DATE),sysdate)
4475: FROM OKC_ARTICLE_VERSIONS
4476: WHERE ARTICLE_ID=VERS.ARTICLE_ID);
4477: */
4478:
4479: -- 11.5.10+ modified cursor to get the version from OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id

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

4485: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4486: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4487: KART.SCN_ID SCN_ID,
4488: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4489: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4490: WHERE KART.DOCUMENT_TYPE = p_doc_type
4491: AND KART.DOCUMENT_ID = p_doc_id
4492: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4493: AND KART.SAV_SAE_ID = VERS.ARTICLE_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(