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_AUTH_UTIL_PVT dependencies on OKS_BILL_UTIL_PUB

Line 7762: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, p_intent), end_date - 1);

7758: WHERE dnz_chr_id = p_contract_hdr_id
7759: AND id = p_contract_line_id
7760: AND(date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
7761: AND date_cancelled IS NULL
7762: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, p_intent), end_date - 1);
7763:
7764:
7765: CURSOR get_lines_id IS
7766: SELECT ID, LSE_ID FROM OKC_K_LINES_B

Line 7771: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, 'T'), end_date - 1);

7767: WHERE dnz_chr_id = p_contract_hdr_id
7768: AND cle_id IS NULL
7769: AND(date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
7770: AND date_cancelled IS NULL
7771: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, 'T'), end_date - 1);
7772:
7773: CURSOR get_lines_details (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
7774: SELECT locked_price_list_id,
7775: locked_price_list_line_id