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.

[Home] [Help]

APPS.OKC_TERMS_QA_PVT dependencies on OKC_K_ARTICLES_B

Line 212: id OKC_K_ARTICLES_B.ID%TYPE,

208: ---------------------------------------------------------------------------
209: -- GLOBAL VARIABLES
210: ------------------------------------------------------------------------------
211: TYPE article_rec_type IS RECORD (
212: id OKC_K_ARTICLES_B.ID%TYPE,
213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,
214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,

Line 213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,

209: -- GLOBAL VARIABLES
210: ------------------------------------------------------------------------------
211: TYPE article_rec_type IS RECORD (
212: id OKC_K_ARTICLES_B.ID%TYPE,
213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,
214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,

Line 214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,

210: ------------------------------------------------------------------------------
211: TYPE article_rec_type IS RECORD (
212: id OKC_K_ARTICLES_B.ID%TYPE,
213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,
214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,
218: title OKC_QA_ERRORS_T.title%TYPE,

Line 215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,

211: TYPE article_rec_type IS RECORD (
212: id OKC_K_ARTICLES_B.ID%TYPE,
213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,
214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,
218: title OKC_QA_ERRORS_T.title%TYPE,
219: std_art_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE

Line 216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,

212: id OKC_K_ARTICLES_B.ID%TYPE,
213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,
214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,
218: title OKC_QA_ERRORS_T.title%TYPE,
219: std_art_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE
220: );

Line 217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,

213: article_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE,
214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,
218: title OKC_QA_ERRORS_T.title%TYPE,
219: std_art_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE
220: );
221:

Line 219: std_art_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE

215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,
218: title OKC_QA_ERRORS_T.title%TYPE,
219: std_art_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE
220: );
221:
222: /* expert commented out
223: -- new type to store xprt clause details

Line 706: FROM OKC_K_ARTICLES_B kart1,

702: rel.TARGET_ARTICLE_ID target_article_id,
703: kart2.label target_label,
704: kart1.AMENDMENT_OPERATION_CODE amendment_operation_code,
705: rel.RELATIONSHIP_TYPE relationship_type
706: FROM OKC_K_ARTICLES_B kart1,
707: OKC_ARTICLE_RELATNS_ALL rel,
708: OKC_K_ARTICLES_B kart2
709: WHERE kart1.document_type = p_doc_type
710: AND kart1.document_id=p_doc_id

Line 708: OKC_K_ARTICLES_B kart2

704: kart1.AMENDMENT_OPERATION_CODE amendment_operation_code,
705: rel.RELATIONSHIP_TYPE relationship_type
706: FROM OKC_K_ARTICLES_B kart1,
707: OKC_ARTICLE_RELATNS_ALL rel,
708: OKC_K_ARTICLES_B kart2
709: WHERE kart1.document_type = p_doc_type
710: AND kart1.document_id=p_doc_id
711: AND kart1.sav_sae_id=rel.source_article_id
712: AND kart2.document_type = p_doc_type

Line 732: OKC_K_ARTICLES_B kart,

728: Rule.rule_name rule_name,
729: Kart.sav_sae_id target_article_id,
730: Rel.relationship_type relationship_type
731: FROM OKC_XPRT_CLAUSES_V rule,
732: OKC_K_ARTICLES_B kart,
733: OKC_ARTICLE_RELATNS_ALL rel
734: WHERE rule.template_id = p_doc_id
735: AND kart.document_type = p_doc_type
736: AND kart.document_id = p_doc_id

Line 1361: OKC_K_ARTICLES_B kart

1357: Rule.clause_id xprt_article_id,
1358: Rule.rule_id rule_id,
1359: Rule.rule_name rule_name
1360: FROM OKC_XPRT_CLAUSES_V rule,
1361: OKC_K_ARTICLES_B kart
1362: WHERE rule.template_id = p_doc_id
1363: AND kart.document_type = p_doc_type
1364: AND kart.document_id = p_doc_id
1365: AND rule.clause_id =kart.sav_sae_id;

Line 1551: FROM okc_k_articles_b kart,

1547: kart.scn_id scn_id,
1548: var.variable_code variable_code,
1549: busvar.variable_name variable_name,
1550: busdoc.name doc_type
1551: FROM okc_k_articles_b kart,
1552: okc_k_art_variables var,
1553: okc_bus_variables_vl busvar,
1554: okc_bus_doc_types_v busdoc
1555: WHERE kart.document_type=p_doc_type

Line 1576: FROM okc_k_articles_b kart,

1572: kart.scn_id scn_id,
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 ,

Line 1622: FROM okc_k_articles_b kart,

1618: kart.scn_id scn_id,
1619: var.variable_code variable_code,
1620: busvar.variable_name variable_name,
1621: busdoc.name doc_type
1622: FROM okc_k_articles_b kart,
1623: okc_k_art_variables var,
1624: okc_bus_variables_vl busvar,
1625: okc_bus_doc_types_v busdoc
1626: WHERE kart.document_type=p_doc_type

Line 1652: FROM okc_k_articles_b kart,

1648: kart.scn_id scn_id,
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 ,

Line 1918: FROM okc_k_articles_b KA,

1914: KA.id,
1915: KA.sav_sae_id article_id,
1916: KA.scn_id,
1917: VT.variable_name
1918: FROM okc_k_articles_b KA,
1919: okc_k_art_variables KV,
1920: okc_bus_variables_b VB,
1921: okc_bus_variables_tl VT
1922: WHERE VB.variable_code = KV.variable_code

Line 2079: FROM okc_k_articles_b kart,

2075: var.variable_value_id,
2076: busvar.mrv_flag,
2077: var.mr_variable_html,
2078: var.mr_variable_xml
2079: FROM okc_k_articles_b kart,
2080: okc_k_art_variables var,
2081: okc_bus_variables_vl busvar
2082: WHERE kart.document_type=p_doc_type
2083: and kart.document_id=p_doc_id

Line 2318: FROM OKC_K_ARTICLES_B KART,

2314: SELECT
2315: kart.id id,
2316: kart.sav_sae_id article_id,
2317: kart.scn_id scn_id
2318: FROM OKC_K_ARTICLES_B KART,
2319: OKC_SECTIONS_B SCN
2320: WHERE kart.document_type=p_doc_type
2321: AND kart.document_id =p_doc_id
2322: AND scn.id = kart.scn_id

Line 2431: AND not exists ( SELECT 'x' FROM OKC_K_ARTICLES_B WHERE scn_id=scn.id

2427: WHERE document_type=p_doc_type
2428: AND document_id =p_doc_id
2429: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2430: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED
2431: AND not exists ( SELECT 'x' FROM OKC_K_ARTICLES_B WHERE scn_id=scn.id
2432: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2433: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED)
2434: AND not exists ( SELECT 'x' FROM OKC_SECTIONS_B SCN1 WHERE SCN1.scn_id = scn.id
2435: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED

Line 2919: FROM OKC_K_ARTICLES_B KART

2915: kart.sav_sae_id article_id,
2916: kart.scn_id scn_id,
2917: kart.amendment_operation_code amendment_operation_code,
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

Line 2940: FROM OKC_K_ARTICLES_B KART,

2936: kart.sav_sae_id article_id,
2937: kart.scn_id scn_id,
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

Line 3028: FROM OKC_K_ARTICLES_B KART,

3024: kart.scn_id scn_id,
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

Line 3051: FROM OKC_K_ARTICLES_B KART,

3047: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
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

Line 3880: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE

3876: DRA.article_id = ART.article_id and
3877: VER.article_version_id = DRA.article_version_id
3878: -- additional check to ensure that we are not checking some
3879: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
3880: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
3881: KART.document_type = p_doc_type AND
3882: KART.document_id = p_doc_id AND
3883: KART.sav_sae_id = DRA.article_id);
3884:

Line 4300: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE

4296: DRA.article_id = ART.article_id and
4297: VER.article_version_id = DRA.article_version_id
4298: -- additional check to ensure that we are not checking some
4299: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
4300: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
4301: KART.document_type = p_doc_type AND
4302: KART.document_id = p_doc_id AND
4303: KART.sav_sae_id = DRA.article_id)
4304: AND VER.article_status='REJECTED';

Line 4451: FROM OKC_K_ARTICLES_B KART,

4447: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
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

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 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