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.OKS_QA_DATA_INTEGRITY dependencies on OKC_CLASS_OPERATIONS

Line 7850: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e

7846: l_dummy_msg VARCHAR2(200);
7847:
7848: CURSOR cur_renewal_source_lines (p_chr_id NUMBER) IS
7849: SELECT 1
7850: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7851: WHERE a.subject_chr_id = p_chr_id
7852: AND c.id = b.cop_id
7853: AND c.opn_code IN('RENEWAL', 'REN_CON')
7854: AND a.oie_id = b.id

Line 7934: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e

7930:
7931:
7932: CURSOR cur_is_K_renewed IS
7933: SELECT d.id target_contract_id
7934: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7935: WHERE a.object_chr_id = p_chr_id
7936: AND c.id = b.cop_id
7937: AND c.opn_code IN('RENEWAL', 'REN_CON')
7938: AND a.oie_id = b.id

Line 7968: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_lines_b d

7964:
7965:
7966: CURSOR cur_is_topline_renewed (p_cle_id NUMBER) IS
7967: SELECT subject_cle_id
7968: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_lines_b d
7969: WHERE a.object_cle_id = d.id
7970: AND a.object_chr_id = d.dnz_chr_id
7971: AND d.cle_id = p_cle_id -- should be a top line id
7972: AND a.object_chr_id = p_chr_id