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 AR_PAYMENT_SCHEDULES_ALL

Line 39: ar_payment_schedules_all aps,

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
42: AND (cp_kle_id IS NULL OR (cp_kle_id IS NOT NULL AND lpt.contract_line_id = cp_kle_id))
43: AND lpt.contract_number = khr.contract_number

Line 129: ar_payment_schedules_all aps,

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
132: AND lpt1.contract_id = khr.id
133: AND lpt1.sty_id = sty.id

Line 715: ar_payment_schedules_all aps,

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
718: AND lpt1.contract_id = khr.id
719: AND lpt1.sty_id = sty.id

Line 760: ar_payment_schedules_all aps,

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
763: lpt.contract_id = lpt1.contract_id
764: AND lpt.contract_number = khr.contract_number

Line 799: --ar_payment_schedules_all sch,

795: -- SELECT NVL(SUM(app.amount_applied),0) principal_paid_amount
796: --SELECT NVL(SUM(app.line_applied),0) principal_paid_amount --End bug# 5767426
797: --FROM ar_receivable_applications_all app,
798: --ar_cash_receipts_all cra,
799: --ar_payment_schedules_all sch,
800: --okl_bpd_tld_ar_lines_v tld,
801: --okl_strm_type_v sty,
802: --okl_k_headers_full_v khr
803: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))

Line 1211: ar_payment_schedules_all aps,

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
1214: -- dcshanmu bug 6734738 start
1215: lpt.contract_id = cp_khr_id

Line 1234: --ar_payment_schedules_all aps,

1230: -- SELECT NVL(SUM(aps.amount_due_original), 0) principal_billed_amount
1231: --SELECT NVL(sum(aps.amount_line_items_original), 0) principal_billed_amount --End bug#5767426
1232: --FROM okl_bpd_tld_ar_lines_v tld,
1233: --okl_strm_type_b sty,
1234: --ar_payment_schedules_all aps,
1235: --okl_k_headers_full_v khr
1236: --WHERE tld.khr_id = cp_khr_id
1237: --AND tld.kle_id = NVL(cp_kle_id, tld.kle_id)
1238: --AND tld.khr_id = khr.id

Line 1325: ar_payment_schedules_all aps,

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
1328: AND lpt.contract_number = khr.contract_number
1329: AND lpt.sty_id = sty.id

Line 1338: --ar_payment_schedules_all aps,

1334:
1335: --SELECT NVL(SUM(aps.amount_due_original), 0) interest_billed_amount
1336: --FROM okl_bpd_tld_ar_lines_v tld,
1337: --okl_strm_type_b sty,
1338: --ar_payment_schedules_all aps,
1339: --okc_k_headers_b khr
1340: --WHERE tld.khr_id = cp_khr_id
1341: --AND tld.khr_id = khr.id
1342: --AND tld.sty_id = sty.id

Line 1426: ar_payment_schedules_all aps,

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
1429: AND lpt.contract_number = khr.contract_number
1430: AND lpt.sty_id = sty.id

Line 1439: --ar_payment_schedules_all aps,

1435:
1436: --SELECT NVL(SUM(aps.amount_due_original), 0) loan_billed_amount
1437: --FROM okl_bpd_tld_ar_lines_v tld,
1438: --okl_strm_type_b sty,
1439: --ar_payment_schedules_all aps,
1440: --okl_k_headers_full_v khr
1441: --WHERE tld.khr_id = cp_khr_id
1442: --AND tld.khr_id = khr.id
1443: --AND tld.sty_id = sty.id

Line 1529: ar_payment_schedules_all aps,

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
1532: AND lpt.contract_number = khr.contract_number
1533: AND lpt.sty_id = sty.id

Line 1542: --ar_payment_schedules_all sch,

1538: );
1539:
1540: --SELECT NVL(SUM(app.amount_applied),0) loan_paid_amount
1541: --FROM ar_receivable_applications_all app,
1542: --ar_payment_schedules_all sch,
1543: --okl_bpd_tld_ar_lines_v tld,
1544: --okl_strm_type_v sty,
1545: --okl_k_headers_full_v khr
1546: --WHERE TRUNC(app.apply_date) <= cp_effective_date

Line 2126: ar_payment_schedules_all aps,

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
2129: lpt.CONTRACT_ID = cp_khr_id
2130: AND lpt.contract_number = khr.contract_number

Line 2146: --ar_payment_schedules_all sch,

2142: --tld.TLD_id tld_id,
2143: -- lsm.receivables_invoice_id
2144: --sch.customer_trx_id receivables_invoice_id
2145: --FROM okl_bpd_tld_ar_lines_v tld,
2146: --ar_payment_schedules_all sch,
2147: --okl_strm_type_b sty
2148: --WHERE sch.customer_trx_id = tld.customer_trx_id
2149: --AND sch.status = 'OP'
2150: --AND sch.class = 'INV'