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_VARIABLE_DOC_TYPES

Line 2936: (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code

2932: and (rev_var.variable_value is not null and rev_var.variable_value <> '_________' )
2933: and exists(select 'x' from okc_bus_variables_tl bustl where bustl.variable_code = rev_var.variable_code)) OR
2934: (kart_var.variable_value is not null and rev_var.variable_value <> kart_var.variable_value))
2935: OR (kart_var.variable_type<>'U' and exists
2936: (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
2937: and var_doc.doc_Type = p_document_type))
2938: )
2939: and rev.document_type = p_document_type and rev.document_id = p_document_id
2940: and nvl(rev.action,'NOCHANGE') not in ('DELETED','MERGED')

Line 2977: and exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code

2973: and busb.variable_intent = p_intent)
2974: )
2975: OR
2976: (rev_var.variable_type <> 'U'
2977: and exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
2978: and var_doc.doc_type = p_document_type)
2979: )
2980: )
2981:

Line 2991: 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

2987: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type
2988: from okc_review_upld_terms rev, okc_review_var_values rev_var
2989: where document_type = p_document_type and rev.document_id = p_document_id
2990: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
2991: 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
2992: and var_doc.doc_type = p_document_type))
2993: 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
2994: and busb.variable_intent = p_intent))
2995: )

Line 3012: and exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code

3008: and busb.variable_intent = p_intent)
3009: )
3010: OR
3011: (rev_var.variable_type <> 'U'
3012: and exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
3013: and var_doc.doc_type = p_document_type)
3014: )
3015: )
3016: and rev.action = 'ADDED' ;

Line 3034: and exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code

3030: and busb.variable_intent = p_intent)
3031: )
3032: OR
3033: (rev_var.variable_type <> 'U'
3034: and exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
3035: and var_doc.doc_type = p_document_type)
3036: )
3037: )
3038: