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 8426: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, p_intent), end_date - 1);

8422: WHERE dnz_chr_id = p_contract_hdr_id
8423: AND id = p_contract_line_id
8424: AND(date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
8425: AND date_cancelled IS NULL
8426: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, p_intent), end_date - 1);
8427:
8428:
8429: CURSOR get_lines_id IS
8430: SELECT ID, LSE_ID FROM OKC_K_LINES_B

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

8431: WHERE dnz_chr_id = p_contract_hdr_id
8432: AND cle_id IS NULL
8433: AND(date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
8434: AND date_cancelled IS NULL
8435: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, 'T'), end_date - 1);
8436:
8437: CURSOR get_lines_details (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
8438: SELECT locked_price_list_id,
8439: locked_price_list_line_id