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_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 1342: OKC_K_ARTICLES_B kart

1338: Rule.clause_id xprt_article_id,
1339: Rule.rule_id rule_id,
1340: Rule.rule_name rule_name
1341: FROM OKC_XPRT_CLAUSES_V rule,
1342: OKC_K_ARTICLES_B kart
1343: WHERE rule.template_id = p_doc_id
1344: AND kart.document_type = p_doc_type
1345: AND kart.document_id = p_doc_id
1346: AND rule.clause_id =kart.sav_sae_id;

Line 1532: FROM okc_k_articles_b kart,

1528: kart.scn_id scn_id,
1529: var.variable_code variable_code,
1530: busvar.variable_name variable_name,
1531: busdoc.name doc_type
1532: FROM okc_k_articles_b kart,
1533: okc_k_art_variables var,
1534: okc_bus_variables_vl busvar,
1535: okc_bus_doc_types_v busdoc
1536: WHERE kart.document_type=p_doc_type

Line 1557: FROM okc_k_articles_b kart,

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

Line 1603: FROM okc_k_articles_b kart,

1599: kart.scn_id scn_id,
1600: var.variable_code variable_code,
1601: busvar.variable_name variable_name,
1602: busdoc.name doc_type
1603: FROM okc_k_articles_b kart,
1604: okc_k_art_variables var,
1605: okc_bus_variables_vl busvar,
1606: okc_bus_doc_types_v busdoc
1607: WHERE kart.document_type=p_doc_type

Line 1633: FROM okc_k_articles_b kart,

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

Line 1899: FROM okc_k_articles_b KA,

1895: KA.id,
1896: KA.sav_sae_id article_id,
1897: KA.scn_id,
1898: VT.variable_name
1899: FROM okc_k_articles_b KA,
1900: okc_k_art_variables KV,
1901: okc_bus_variables_b VB,
1902: okc_bus_variables_tl VT
1903: WHERE VB.variable_code = KV.variable_code

Line 2057: FROM okc_k_articles_b kart,

2053: var.variable_value variable_value,
2054: var.variable_type,
2055: var.external_yn,
2056: var.variable_value_id
2057: FROM okc_k_articles_b kart,
2058: okc_k_art_variables var,
2059: okc_bus_variables_vl busvar
2060: WHERE kart.document_type=p_doc_type
2061: and kart.document_id=p_doc_id

Line 2284: FROM OKC_K_ARTICLES_B KART,

2280: SELECT
2281: kart.id id,
2282: kart.sav_sae_id article_id,
2283: kart.scn_id scn_id
2284: FROM OKC_K_ARTICLES_B KART,
2285: OKC_SECTIONS_B SCN
2286: WHERE kart.document_type=p_doc_type
2287: AND kart.document_id =p_doc_id
2288: AND scn.id = kart.scn_id

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

2393: WHERE document_type=p_doc_type
2394: AND document_id =p_doc_id
2395: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2396: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED
2397: AND not exists ( SELECT 'x' FROM OKC_K_ARTICLES_B WHERE scn_id=scn.id
2398: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED
2399: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED)
2400: AND not exists ( SELECT 'x' FROM OKC_SECTIONS_B SCN1 WHERE SCN1.scn_id = scn.id
2401: AND nvl(amendment_operation_code,'?') <> G_AMEND_CODE_DELETED

Line 2885: FROM OKC_K_ARTICLES_B KART

2881: kart.sav_sae_id article_id,
2882: kart.scn_id scn_id,
2883: kart.amendment_operation_code amendment_operation_code,
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

Line 2906: FROM OKC_K_ARTICLES_B KART,

2902: kart.sav_sae_id article_id,
2903: kart.scn_id scn_id,
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

Line 2994: FROM OKC_K_ARTICLES_B KART,

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

Line 3017: FROM OKC_K_ARTICLES_B KART,

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

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

3842: DRA.article_id = ART.article_id and
3843: VER.article_version_id = DRA.article_version_id
3844: -- additional check to ensure that we are not checking some
3845: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
3846: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
3847: KART.document_type = p_doc_type AND
3848: KART.document_id = p_doc_id AND
3849: KART.sav_sae_id = DRA.article_id);
3850:

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

4262: DRA.article_id = ART.article_id and
4263: VER.article_version_id = DRA.article_version_id
4264: -- additional check to ensure that we are not checking some
4265: -- orphaned records in the OKC_TMPL_DRAFT_CLAUSES table
4266: AND EXISTS (SELECT '1' FROM OKC_K_ARTICLES_B KART WHERE
4267: KART.document_type = p_doc_type AND
4268: KART.document_id = p_doc_id AND
4269: KART.sav_sae_id = DRA.article_id)
4270: AND VER.article_status='REJECTED';

Line 4417: FROM OKC_K_ARTICLES_B KART,

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

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