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_VARIABLE_INT_UTIL_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 37: FROM okl_bpd_ar_inv_lines_v lpt,

33: CURSOR l_interest_billed_csr(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
34: -- Begin bug 6456733
35: -- dcshanmu bug 6734738 start
36: SELECT NVL(SUM(AMOUNT),0) interest_billed_amount
37: FROM okl_bpd_ar_inv_lines_v lpt,
38: okl_strm_type_b sty,
39: ar_payment_schedules_all aps,
40: okl_k_headers_full_v khr
41: WHERE lpt.contract_id = cp_khr_id

Line 127: FROM okl_bpd_ar_inv_lines_v lpt1,

123: SELECT NVL(SUM(interest_paid_amount),0) interest_paid_amount
124: FROM
125: (
126: SELECT NVL(SUM(AMOUNT),0)- NVL(SUM(LINE_AMOUNT_REMAINING_WOTAX),0) interest_paid_amount
127: FROM okl_bpd_ar_inv_lines_v lpt1,
128: okl_strm_type_b sty,
129: ar_payment_schedules_all aps,
130: okc_k_headers_b khr
131: WHERE contract_id=cp_khr_id

Line 713: FROM okl_bpd_ar_inv_lines_v lpt1,

709: SELECT SUM(principal_paid_amount) principal_paid_amount
710: FROM
711: (
712: SELECT SUM(AMOUNT)- SUM(LINE_AMOUNT_REMAINING_WOTAX) principal_paid_amount
713: FROM okl_bpd_ar_inv_lines_v lpt1,
714: okl_strm_type_b sty,
715: ar_payment_schedules_all aps,
716: okc_k_headers_b khr
717: WHERE contract_id=cp_khr_id

Line 752: FROM okl_bpd_ar_inv_lines_v lpt1

748: SELECT SUM(principal_paid_amount) principal_paid_amount
749: FROM
750: (
751: SELECT SUM(AMOUNT)- SUM(AMOUNT_LINE_ITEMS_REMAINING) principal_paid_amount
752: FROM okl_bpd_ar_inv_lines_v lpt1
753: where contract_id=cp_khr_id
754: and RECEIVABLES_INVOICE_ID in
755: (
756: SELECT RECEIVABLES_INVOICE_ID

Line 758: okl_bpd_ar_inv_lines_v lpt,

754: and RECEIVABLES_INVOICE_ID in
755: (
756: SELECT RECEIVABLES_INVOICE_ID
757: FROM
758: okl_bpd_ar_inv_lines_v lpt,
759: okl_strm_type_b sty,
760: ar_payment_schedules_all aps,
761: okl_k_headers_full_v khr
762: WHERE

Line 1203: --FROM okl_bpd_ar_inv_lines_v lpt1

1199: --CURSOR l_principal_billed_csr(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
1200: CURSOR l_principal_billed_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
1201: -- dcshanmu bug 6734738 start
1202: --SELECT NVL(SUM(AMOUNT),0) principal_billed_amount
1203: --FROM okl_bpd_ar_inv_lines_v lpt1
1204: --where contract_id=cp_khr_id
1205: --and RECEIVABLES_INVOICE_ID in
1206: --(
1207: SELECT NVL(SUM(AMOUNT),0) principal_billed_amount --RECEIVABLES_INVOICE_ID

Line 1209: FROM okl_bpd_ar_inv_lines_v lpt,

1205: --and RECEIVABLES_INVOICE_ID in
1206: --(
1207: SELECT NVL(SUM(AMOUNT),0) principal_billed_amount --RECEIVABLES_INVOICE_ID
1208: -- dcshanmu bug 6734738 end
1209: FROM okl_bpd_ar_inv_lines_v lpt,
1210: okl_strm_type_b sty,
1211: ar_payment_schedules_all aps,
1212: okl_k_headers_full_v khr
1213: WHERE

Line 1318: FROM okl_bpd_ar_inv_lines_v lpt1

1314: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1315: CURSOR l_float_billed_csr(cp_khr_id IN NUMBER, cp_effective_date IN DATE) IS
1316: -- Begin bug 6456733
1317: SELECT NVL(SUM(AMOUNT_DUE_ORIGINAL),0) interest_billed_amount
1318: FROM okl_bpd_ar_inv_lines_v lpt1
1319: where contract_id=cp_khr_id
1320: and RECEIVABLES_INVOICE_ID in
1321: (
1322: SELECT lpt.RECEIVABLES_INVOICE_ID

Line 1323: FROM okl_bpd_ar_inv_lines_v lpt,

1319: where contract_id=cp_khr_id
1320: and RECEIVABLES_INVOICE_ID in
1321: (
1322: SELECT lpt.RECEIVABLES_INVOICE_ID
1323: FROM okl_bpd_ar_inv_lines_v lpt,
1324: okl_strm_type_b sty,
1325: ar_payment_schedules_all aps,
1326: okl_k_headers_full_v khr
1327: WHERE lpt.contract_id = lpt1.contract_id

Line 1419: FROM okl_bpd_ar_inv_lines_v lpt1

1415: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1416: CURSOR l_loan_payment_billed_csr(cp_khr_id IN NUMBER, cp_effective_date IN DATE) IS
1417: --Begin bug 6456733
1418: SELECT NVL(SUM(lpt1.AMOUNT_DUE_ORIGINAL),0) loan_billed_amount
1419: FROM okl_bpd_ar_inv_lines_v lpt1
1420: where contract_id=cp_khr_id
1421: and RECEIVABLES_INVOICE_ID in
1422: (
1423: SELECT lpt.RECEIVABLES_INVOICE_ID

Line 1424: FROM okl_bpd_ar_inv_lines_v lpt,

1420: where contract_id=cp_khr_id
1421: and RECEIVABLES_INVOICE_ID in
1422: (
1423: SELECT lpt.RECEIVABLES_INVOICE_ID
1424: FROM okl_bpd_ar_inv_lines_v lpt,
1425: okl_strm_type_b sty,
1426: ar_payment_schedules_all aps,
1427: okl_k_headers_full_v khr
1428: WHERE lpt.contract_id = lpt1.contract_id

Line 1522: FROM okl_bpd_ar_inv_lines_v lpt1

1518: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER, cp_effective_date IN DATE) IS
1519: -- Begin Bug 6456733
1520: SELECT
1521: (NVL(SUM(AMOUNT_DUE_ORIGINAL),0)- NVL(SUM(AMOUNT_LINE_ITEMS_REMAINING),0)) loan_paid_amount
1522: FROM okl_bpd_ar_inv_lines_v lpt1
1523: where contract_id=cp_khr_id
1524: and RECEIVABLES_INVOICE_ID in
1525: (
1526: SELECT lpt.RECEIVABLES_INVOICE_ID

Line 1527: FROM okl_bpd_ar_inv_lines_v lpt,

1523: where contract_id=cp_khr_id
1524: and RECEIVABLES_INVOICE_ID in
1525: (
1526: SELECT lpt.RECEIVABLES_INVOICE_ID
1527: FROM okl_bpd_ar_inv_lines_v lpt,
1528: okl_strm_type_b sty,
1529: ar_payment_schedules_all aps,
1530: okl_k_headers_full_v khr
1531: WHERE lpt.contract_id = lpt1.contract_id

Line 2124: okl_bpd_ar_inv_lines_v lpt,

2120: lpt.TXD_ID LSM_ID,
2121: lpt.TXD_ID tld_id,
2122: aps.customer_trx_id receivables_invoice_id
2123: FROM
2124: okl_bpd_ar_inv_lines_v lpt,
2125: okl_strm_type_b sty,
2126: ar_payment_schedules_all aps,
2127: okl_k_headers_full_v khr
2128: WHERE