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 34: --FROM okl_bpd_ar_inv_lines_v lpt1

30: CURSOR l_interest_billed_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
31: -- Begin bug 6456733
32: -- dcshanmu bug 6734738 start
33: --SELECT NVL(SUM(AMOUNT),0) interest_billed_amount
34: --FROM okl_bpd_ar_inv_lines_v lpt1
35: --where contract_id=cp_khr_id
36: --and RECEIVABLES_INVOICE_ID in
37: --(
38: SELECT NVL(SUM(AMOUNT),0) interest_billed_amount -- lpt.RECEIVABLES_INVOICE_ID

Line 40: FROM okl_bpd_ar_inv_lines_v lpt,

36: --and RECEIVABLES_INVOICE_ID in
37: --(
38: SELECT NVL(SUM(AMOUNT),0) interest_billed_amount -- lpt.RECEIVABLES_INVOICE_ID
39: --dcshanmu bug 6734738 end
40: FROM okl_bpd_ar_inv_lines_v lpt,
41: okl_strm_type_b sty,
42: ar_payment_schedules_all aps,
43: okl_k_headers_full_v khr
44: --dcshanmu bug 6734738 start

Line 170: FROM okl_bpd_ar_inv_lines_v lpt1

166: SELECT NVL(SUM(interest_paid_amount),0) interest_paid_amount
167: FROM
168: (
169: SELECT NVL(SUM(AMOUNT),0)- NVL(SUM(AMOUNT_LINE_ITEMS_REMAINING),0) interest_paid_amount
170: FROM okl_bpd_ar_inv_lines_v lpt1
171: where contract_id=cp_khr_id
172: and RECEIVABLES_INVOICE_ID in
173: (
174: SELECT RECEIVABLES_INVOICE_ID

Line 176: okl_bpd_ar_inv_lines_v lpt,

172: and RECEIVABLES_INVOICE_ID in
173: (
174: SELECT RECEIVABLES_INVOICE_ID
175: FROM
176: okl_bpd_ar_inv_lines_v lpt,
177: okl_strm_type_b sty,
178: ar_payment_schedules_all aps,
179: okl_k_headers_full_v khr
180: WHERE

Line 801: FROM okl_bpd_ar_inv_lines_v lpt1

797: SELECT SUM(principal_paid_amount) principal_paid_amount
798: FROM
799: (
800: SELECT SUM(AMOUNT)- SUM(AMOUNT_LINE_ITEMS_REMAINING) principal_paid_amount
801: FROM okl_bpd_ar_inv_lines_v lpt1
802: where contract_id=cp_khr_id
803: and RECEIVABLES_INVOICE_ID in
804: (
805: SELECT RECEIVABLES_INVOICE_ID

Line 807: okl_bpd_ar_inv_lines_v lpt,

803: and RECEIVABLES_INVOICE_ID in
804: (
805: SELECT RECEIVABLES_INVOICE_ID
806: FROM
807: okl_bpd_ar_inv_lines_v lpt,
808: okl_strm_type_b sty,
809: ar_payment_schedules_all aps,
810: okl_k_headers_full_v khr
811: WHERE

Line 1250: --FROM okl_bpd_ar_inv_lines_v lpt1

1246: --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
1247: CURSOR l_principal_billed_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
1248: -- dcshanmu bug 6734738 start
1249: --SELECT NVL(SUM(AMOUNT),0) principal_billed_amount
1250: --FROM okl_bpd_ar_inv_lines_v lpt1
1251: --where contract_id=cp_khr_id
1252: --and RECEIVABLES_INVOICE_ID in
1253: --(
1254: SELECT NVL(SUM(AMOUNT),0) principal_billed_amount --RECEIVABLES_INVOICE_ID

Line 1256: FROM okl_bpd_ar_inv_lines_v lpt,

1252: --and RECEIVABLES_INVOICE_ID in
1253: --(
1254: SELECT NVL(SUM(AMOUNT),0) principal_billed_amount --RECEIVABLES_INVOICE_ID
1255: -- dcshanmu bug 6734738 end
1256: FROM okl_bpd_ar_inv_lines_v lpt,
1257: okl_strm_type_b sty,
1258: ar_payment_schedules_all aps,
1259: okl_k_headers_full_v khr
1260: WHERE

Line 1365: FROM okl_bpd_ar_inv_lines_v lpt1

1361: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1362: CURSOR l_float_billed_csr(cp_khr_id IN NUMBER, cp_effective_date IN DATE) IS
1363: -- Begin bug 6456733
1364: SELECT NVL(SUM(AMOUNT_DUE_ORIGINAL),0) interest_billed_amount
1365: FROM okl_bpd_ar_inv_lines_v lpt1
1366: where contract_id=cp_khr_id
1367: and RECEIVABLES_INVOICE_ID in
1368: (
1369: SELECT lpt.RECEIVABLES_INVOICE_ID

Line 1370: FROM okl_bpd_ar_inv_lines_v lpt,

1366: where contract_id=cp_khr_id
1367: and RECEIVABLES_INVOICE_ID in
1368: (
1369: SELECT lpt.RECEIVABLES_INVOICE_ID
1370: FROM okl_bpd_ar_inv_lines_v lpt,
1371: okl_strm_type_b sty,
1372: ar_payment_schedules_all aps,
1373: okl_k_headers_full_v khr
1374: WHERE lpt.contract_id = lpt1.contract_id

Line 1466: FROM okl_bpd_ar_inv_lines_v lpt1

1462: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1463: CURSOR l_loan_payment_billed_csr(cp_khr_id IN NUMBER, cp_effective_date IN DATE) IS
1464: --Begin bug 6456733
1465: SELECT NVL(SUM(lpt1.AMOUNT_DUE_ORIGINAL),0) loan_billed_amount
1466: FROM okl_bpd_ar_inv_lines_v lpt1
1467: where contract_id=cp_khr_id
1468: and RECEIVABLES_INVOICE_ID in
1469: (
1470: SELECT lpt.RECEIVABLES_INVOICE_ID

Line 1471: FROM okl_bpd_ar_inv_lines_v lpt,

1467: where contract_id=cp_khr_id
1468: and RECEIVABLES_INVOICE_ID in
1469: (
1470: SELECT lpt.RECEIVABLES_INVOICE_ID
1471: FROM okl_bpd_ar_inv_lines_v lpt,
1472: okl_strm_type_b sty,
1473: ar_payment_schedules_all aps,
1474: okl_k_headers_full_v khr
1475: WHERE lpt.contract_id = lpt1.contract_id

Line 1569: FROM okl_bpd_ar_inv_lines_v lpt1

1565: CURSOR l_laon_payment_csr(cp_khr_id IN NUMBER, cp_effective_date IN DATE) IS
1566: -- Begin Bug 6456733
1567: SELECT
1568: (NVL(SUM(AMOUNT_DUE_ORIGINAL),0)- NVL(SUM(AMOUNT_LINE_ITEMS_REMAINING),0)) loan_paid_amount
1569: FROM okl_bpd_ar_inv_lines_v lpt1
1570: where contract_id=cp_khr_id
1571: and RECEIVABLES_INVOICE_ID in
1572: (
1573: SELECT lpt.RECEIVABLES_INVOICE_ID

Line 1574: FROM okl_bpd_ar_inv_lines_v lpt,

1570: where contract_id=cp_khr_id
1571: and RECEIVABLES_INVOICE_ID in
1572: (
1573: SELECT lpt.RECEIVABLES_INVOICE_ID
1574: FROM okl_bpd_ar_inv_lines_v lpt,
1575: okl_strm_type_b sty,
1576: ar_payment_schedules_all aps,
1577: okl_k_headers_full_v khr
1578: WHERE lpt.contract_id = lpt1.contract_id

Line 2048: okl_bpd_ar_inv_lines_v lpt,

2044: lpt.TXD_ID LSM_ID,
2045: lpt.TXD_ID tld_id,
2046: aps.customer_trx_id receivables_invoice_id
2047: FROM
2048: okl_bpd_ar_inv_lines_v lpt,
2049: okl_strm_type_b sty,
2050: ar_payment_schedules_all aps,
2051: okl_k_headers_full_v khr
2052: WHERE