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_OPERATION_INSTANCES

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

7697: l_dummy_msg VARCHAR2(200);
7698:
7699: CURSOR cur_renewal_source_lines (p_chr_id NUMBER) IS
7700: SELECT 1
7701: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7702: WHERE a.subject_chr_id = p_chr_id
7703: AND c.id = b.cop_id
7704: AND c.opn_code IN('RENEWAL', 'REN_CON')
7705: AND a.oie_id = b.id

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

7781:
7782:
7783: CURSOR cur_is_K_renewed IS
7784: SELECT d.id target_contract_id
7785: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7786: WHERE a.object_chr_id = p_chr_id
7787: AND c.id = b.cop_id
7788: AND c.opn_code IN('RENEWAL', 'REN_CON')
7789: AND a.oie_id = b.id

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

7815:
7816:
7817: CURSOR cur_is_topline_renewed (p_cle_id NUMBER) IS
7818: SELECT subject_cle_id
7819: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_lines_b d
7820: WHERE a.object_cle_id = d.id
7821: AND a.object_chr_id = d.dnz_chr_id
7822: AND d.cle_id = p_cle_id -- should be a top line id
7823: AND a.object_chr_id = p_chr_id