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.OKL_STREAM_BILLING_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 402: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle

398: CURSOR l_bankrupt_csr(cp_khr_id NUMBER) IS
399: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status
400: , disposition_code
401: FROM iex_bankruptcies ban
402: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle
403: WHERE rle.dnz_chr_id = cp_khr_id
404: AND rle.rle_code = 'LESSEE'
405: AND TO_NUMBER(rle.object1_id1) = ban.party_id);
406:

Line 1609: , okc_k_party_roles_b cpl

1605: FROM okc_k_headers_b khr
1606: , okx_cust_site_uses_v cs
1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
1610: , okc_k_party_roles_b cpl_inv
1611: , hz_parties hz
1612: WHERE khr.id = p_khr_id
1613: AND cle.dnz_chr_id = khr.id

Line 1610: , okc_k_party_roles_b cpl_inv

1606: , okx_cust_site_uses_v cs
1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
1610: , okc_k_party_roles_b cpl_inv
1611: , hz_parties hz
1612: WHERE khr.id = p_khr_id
1613: AND cle.dnz_chr_id = khr.id
1614: AND cle_inv.dnz_chr_id = khr.id