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_EXTWARPRGM_PVT dependencies on OKS_BILL_SUB_LINES_V

Line 6679: FROM oks_bill_sub_lines_v

6675: IS
6676: CURSOR l_bill_csr (p_cle_id NUMBER)
6677: IS
6678: SELECT NVL (SUM (amount), 0)
6679: FROM oks_bill_sub_lines_v
6680: WHERE cle_id = p_cle_id;
6681:
6682: CURSOR l_rule_csr (p_cle_id NUMBER)
6683: IS

Line 7543: FROM oks_bill_sub_lines_v

7539: --total billed amount
7540: CURSOR l_billed_amount_csr (p_cle_id NUMBER)
7541: IS
7542: SELECT NVL (SUM (amount), 0)
7543: FROM oks_bill_sub_lines_v
7544: WHERE cle_id = p_cle_id;
7545:
7546: --credit amount
7547: CURSOR l_credit_csr (p_cle_id NUMBER)

Line 15507: FROM oks_bill_sub_lines_v

15503:
15504: CURSOR l_bill_csr (p_cle_id NUMBER)
15505: IS
15506: SELECT SUM (amount)
15507: FROM oks_bill_sub_lines_v
15508: WHERE cle_id = p_cle_id;
15509:
15510: CURSOR l_serv_csr (p_serv_id NUMBER)
15511: IS