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 3023: from okc_k_art_variables art_var, okc_k_articles_b kart

3019:
3020: cursor current_variable_values is
3021: select art_var.cat_id, art_var.variable_code, art_var.variable_type, art_var.external_yn,
3022: art_var.attribute_value_set_id,art_var.variable_value_id, art_var.variable_value
3023: from okc_k_art_variables art_var, okc_k_articles_b kart
3024: where art_var.cat_id = kart.id
3025: and kart.document_type = p_document_type and kart.document_id = p_document_id;
3026:
3027: cursor variable_values_changed is

Line 3033: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,

3029: rev_var.variable_name variable_name,
3030: kart_var.variable_value kart_variable_value, rev_var.variable_value rev_variable_value,
3031: kart_var.variable_type, rev_var.variable_value_id
3032:
3033: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,
3034: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av
3035: WHERE rev.object_id = kart_var.cat_id
3036: AND rev.REVIEW_UPLD_TERMS_id = rev_var.REVIEW_UPLD_TERMS_id
3037: AND kart_var.variable_code = rev_var.variable_code

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

3050: and nvl(av.insert_by_reference,'N') <> 'Y';
3051:
3052: cursor variables_removed is
3053: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
3054: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
3055: where rev.object_id = kart_var.cat_id
3056: and rev.document_type = p_document_type and rev.document_id = p_document_id
3057: and rev.article_version_id = av.article_version_id
3058: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var

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

3071: where rev.document_type = p_document_type and rev.document_id = p_document_id
3072: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3073: and av.article_version_id = rev.article_version_id
3074: and not exists(
3075: select 'x' from okc_k_art_variables kart_var, okc_review_upld_Terms rev_upld where
3076: rev_upld.review_upld_Terms_id = rev_var.review_upld_terms_id
3077: and rev_upld.object_id = kart_var.cat_id
3078: and rev_var.variable_code = kart_var.variable_code
3079: and (