[Home] [Help]
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
45: WHERE lpt.contract_id = cp_khr_id
62: -- (
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
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
181: lpt.contract_id = lpt1.contract_id
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
812: lpt.contract_id = lpt1.contract_id
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
1261: -- dcshanmu bug 6734738 start
1276:
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)
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
1375: AND lpt.contract_number = khr.contract_number
1380: );
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
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
1476: AND lpt.contract_number = khr.contract_number
1481: );
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
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
1579: AND lpt.contract_number = khr.contract_number
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
2053: lpt.CONTRACT_ID = cp_khr_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'
2075: --AND tld.khr_id = cp_khr_id