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 6847: FROM oks_bill_sub_lines_v

6843: IS
6844: CURSOR l_bill_csr (p_cle_id NUMBER)
6845: IS
6846: SELECT NVL (SUM (amount), 0)
6847: FROM oks_bill_sub_lines_v
6848: WHERE cle_id = p_cle_id;
6849:
6850: CURSOR l_rule_csr (p_cle_id NUMBER)
6851: IS

Line 7724: FROM oks_bill_sub_lines_v

7720: --total billed amount
7721: CURSOR l_billed_amount_csr (p_cle_id NUMBER)
7722: IS
7723: SELECT NVL (SUM (amount), 0)
7724: FROM oks_bill_sub_lines_v
7725: WHERE cle_id = p_cle_id;
7726:
7727: --credit amount
7728: CURSOR l_credit_csr (p_cle_id NUMBER)

Line 15792: FROM oks_bill_sub_lines_v

15788:
15789: CURSOR l_bill_csr (p_cle_id NUMBER)
15790: IS
15791: SELECT SUM (amount)
15792: FROM oks_bill_sub_lines_v
15793: WHERE cle_id = p_cle_id;
15794:
15795: /* Added for Bug#14325727 */
15796: CURSOR l_serv_csr (p_serv_id NUMBER)