[Home] [Help]
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
45: WHERE lpt.contract_id = cp_khr_id
46: --dcshanmu bug 6734738 end
63: -- SELECT NVL(SUM(aps.amount_due_original), 0) interest_billed_amount
64: -- SELECT NVL(SUM(aps.amount_line_items_original),0) interest_billed_amount --End bug# 5767426
65: -- FROM okl_bpd_tld_ar_lines_v tld,
66: -- okl_strm_type_b sty,
67: -- ar_payment_schedules_all aps,
68: -- okl_k_headers_full_v khr
69: -- WHERE tld.khr_id = cp_khr_id
70: -- AND tld.khr_id = khr.id
71: -- AND tld.sty_id = sty.id
82: SELECT sum(aps.amount_due_original) interest_billed_amount
83: FROM okl_cnsld_ar_strms_b lsm,
84: okl_strm_type_v sty,
85: okl_strm_elements sel,
86: ar_payment_schedules_all aps,
87: okl_k_headers_full_v khr
88: WHERE lsm.khr_id = cp_khr_id
89: AND lsm.khr_id = khr.id
90: AND lsm.sty_id = sty.id
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
181: lpt.contract_id = lpt1.contract_id
182: AND lpt.contract_number = khr.contract_number
208: --SELECT SUM(interest_paid_amount) FROM
209: --(SELECT NVL(SUM(app.line_applied),0) interest_paid_amount
210: --FROM ar_receivable_applications_all app,
211: --ar_cash_receipts_all cra,
212: --ar_payment_schedules_all sch,
213: --okl_bpd_tld_ar_lines_v tld,
214: --okl_strm_type_v sty,
215: --okl_k_headers_full_v khr
216: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
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
812: lpt.contract_id = lpt1.contract_id
813: AND lpt.contract_number = khr.contract_number
842: -- SELECT NVL(SUM(app.amount_applied),0) principal_paid_amount
843: --SELECT NVL(SUM(app.line_applied),0) principal_paid_amount --End bug# 5767426
844: --FROM ar_receivable_applications_all app,
845: --ar_cash_receipts_all cra,
846: --ar_payment_schedules_all sch,
847: --okl_bpd_tld_ar_lines_v tld,
848: --okl_strm_type_v sty,
849: --okl_k_headers_full_v khr
850: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
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
1261: -- dcshanmu bug 6734738 start
1262: lpt.contract_id = cp_khr_id
1277: -- SELECT NVL(SUM(aps.amount_due_original), 0) principal_billed_amount
1278: --SELECT NVL(sum(aps.amount_line_items_original), 0) principal_billed_amount --End bug#5767426
1279: --FROM okl_bpd_tld_ar_lines_v tld,
1280: --okl_strm_type_b sty,
1281: --ar_payment_schedules_all aps,
1282: --okl_k_headers_full_v khr
1283: --WHERE tld.khr_id = cp_khr_id
1284: --AND tld.kle_id = NVL(cp_kle_id, tld.kle_id)
1285: --AND tld.khr_id = khr.id
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
1375: AND lpt.contract_number = khr.contract_number
1376: AND lpt.sty_id = sty.id
1381:
1382: --SELECT NVL(SUM(aps.amount_due_original), 0) interest_billed_amount
1383: --FROM okl_bpd_tld_ar_lines_v tld,
1384: --okl_strm_type_b sty,
1385: --ar_payment_schedules_all aps,
1386: --okc_k_headers_b khr
1387: --WHERE tld.khr_id = cp_khr_id
1388: --AND tld.khr_id = khr.id
1389: --AND tld.sty_id = sty.id
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
1476: AND lpt.contract_number = khr.contract_number
1477: AND lpt.sty_id = sty.id
1482:
1483: --SELECT NVL(SUM(aps.amount_due_original), 0) loan_billed_amount
1484: --FROM okl_bpd_tld_ar_lines_v tld,
1485: --okl_strm_type_b sty,
1486: --ar_payment_schedules_all aps,
1487: --okl_k_headers_full_v khr
1488: --WHERE tld.khr_id = cp_khr_id
1489: --AND tld.khr_id = khr.id
1490: --AND tld.sty_id = sty.id
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
1579: AND lpt.contract_number = khr.contract_number
1580: AND lpt.sty_id = sty.id
1585: );
1586:
1587: --SELECT NVL(SUM(app.amount_applied),0) loan_paid_amount
1588: --FROM ar_receivable_applications_all app,
1589: --ar_payment_schedules_all sch,
1590: --okl_bpd_tld_ar_lines_v tld,
1591: --okl_strm_type_v sty,
1592: --okl_k_headers_full_v khr
1593: --WHERE TRUNC(app.apply_date) <= cp_effective_date
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
2053: lpt.CONTRACT_ID = cp_khr_id
2054: AND lpt.contract_number = khr.contract_number
2066: --tld.TLD_id tld_id,
2067: -- lsm.receivables_invoice_id
2068: --sch.customer_trx_id receivables_invoice_id
2069: --FROM okl_bpd_tld_ar_lines_v tld,
2070: --ar_payment_schedules_all sch,
2071: --okl_strm_type_b sty
2072: --WHERE sch.customer_trx_id = tld.customer_trx_id
2073: --AND sch.status = 'OP'
2074: --AND sch.class = 'INV'