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_BUS_VARIABLES_B

Line 3081: and exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code

3077: and rev_upld.object_id = kart_var.cat_id
3078: and rev_var.variable_code = kart_var.variable_code
3079: and (
3080: (rev_var.variable_type = 'U'
3081: and exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code
3082: and busb.variable_intent = p_intent)
3083: )
3084: OR
3085: (rev_var.variable_type <> 'U'

Line 3102: OR (rev_var.variable_type = 'U' and not exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code

3098: where document_type = p_document_type and rev.document_id = p_document_id
3099: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3100: and ((rev_var.variable_type in ('S','D') and not exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
3101: and var_doc.doc_type = p_document_type))
3102: OR (rev_var.variable_type = 'U' and not exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code
3103: and busb.variable_intent = p_intent))
3104: )
3105: and rev.action not in ('DELETED','MERGED') ;
3106:

Line 3116: and exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code

3112: where rev.document_type = p_document_type and rev.document_id = p_document_id
3113: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3114: and (
3115: (rev_var.variable_type = 'U'
3116: and exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code
3117: and busb.variable_intent = p_intent)
3118: )
3119: OR
3120: (rev_var.variable_type <> 'U'

Line 3138: and exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code

3134: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3135: and av.article_version_id = rev.article_version_id
3136: and (
3137: (rev_var.variable_type = 'U'
3138: and exists (select 'x' from okc_bus_variables_b busb where busb.variable_code = rev_var.variable_code
3139: and busb.variable_intent = p_intent)
3140: )
3141: OR
3142: (rev_var.variable_type <> 'U'