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_K_PARTY_ROLES_V

Line 6556: FROM okc_k_party_roles_v

6552: -- stored on the contract header.
6553: -- If no value is returned then check the related customers
6554: CURSOR cust_exist_csr(cust_id NUMBER) IS
6555: SELECT object1_id1 party_id
6556: FROM okc_k_party_roles_v
6557: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6558: AND object1_id1 = cust_id
6559: AND dnz_chr_id = p_chr_id
6560: AND chr_id = p_chr_id;

Line 6569: FROM okc_k_party_roles_v

6565: WHERE id = p_chr_id;
6566:
6567: CURSOR get_contr_cust IS
6568: SELECT object1_id1 party_id
6569: FROM okc_k_party_roles_v
6570: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6571: AND dnz_chr_id = p_chr_id
6572: AND chr_id = p_chr_id;
6573:

Line 6723: FROM okc_k_party_roles_v

6719: AND status = 'A';
6720:
6721: CURSOR get_contr_cust IS
6722: SELECT object1_id1 party_id, rle_code
6723: FROM okc_k_party_roles_v
6724: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6725: AND dnz_chr_id = p_chr_id
6726: AND chr_id = p_chr_id;
6727: