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_REVIEW_UPLD_TERMS_PVT dependencies on OKC_K_ART_VARIABLES

Line 2914: from okc_k_art_variables art_var, okc_k_articles_b kart

2910:
2911: cursor current_variable_values is
2912: select art_var.cat_id, art_var.variable_code, art_var.variable_type, art_var.external_yn,
2913: art_var.attribute_value_set_id,art_var.variable_value_id, art_var.variable_value
2914: from okc_k_art_variables art_var, okc_k_articles_b kart
2915: where art_var.cat_id = kart.id
2916: and kart.document_type = p_document_type and kart.document_id = p_document_id;
2917:
2918: cursor variable_values_changed is

Line 2924: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,

2920: rev_var.variable_name variable_name,
2921: kart_var.variable_value kart_variable_value, rev_var.variable_value rev_variable_value,
2922: kart_var.variable_type, rev_var.variable_value_id
2923:
2924: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,
2925: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av
2926: WHERE rev.object_id = kart_var.cat_id
2927: AND rev.REVIEW_UPLD_TERMS_id = rev_var.REVIEW_UPLD_TERMS_id
2928: AND kart_var.variable_code = rev_var.variable_code

Line 2945: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av

2941: and nvl(av.insert_by_reference,'N') <> 'Y';
2942:
2943: cursor variables_removed is
2944: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
2945: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
2946: where rev.object_id = kart_var.cat_id
2947: and rev.document_type = p_document_type and rev.document_id = p_document_id
2948: and rev.article_version_id = av.article_version_id
2949: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var

Line 2966: select 'x' from okc_k_art_variables kart_var, okc_review_upld_Terms rev_upld where

2962: where rev.document_type = p_document_type and rev.document_id = p_document_id
2963: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
2964: and av.article_version_id = rev.article_version_id
2965: and not exists(
2966: select 'x' from okc_k_art_variables kart_var, okc_review_upld_Terms rev_upld where
2967: rev_upld.review_upld_Terms_id = rev_var.review_upld_terms_id
2968: and rev_upld.object_id = kart_var.cat_id
2969: and rev_var.variable_code = kart_var.variable_code
2970: and (