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_K_HEADERS_FULL_V

Line 40: okl_k_headers_full_v khr

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
44: AND lpt.sty_id = sty.id

Line 761: okl_k_headers_full_v khr

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
765: AND lpt.sty_id = sty.id

Line 802: --okl_k_headers_full_v khr

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))
804: --AND app.cash_receipt_id = cra.cash_receipt_id
805: --AND app.status = 'APP'
806: --AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 981: FROM okl_k_headers_full_v khr,

977: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
978: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
979: SELECT ppm.quality_val interest_calculation_basis
980: , end_date
981: FROM okl_k_headers_full_v khr,
982: okl_prod_qlty_val_uv ppm
983: WHERE khr.pdt_id = ppm.pdt_id
984: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS'
985: AND khr.id = cp_khr_id;

Line 996: l_end_date okl_k_headers_full_v.end_date%TYPE;

992:
993: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
994: l_effective_int_rate NUMBER;
995: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
996: l_end_date okl_k_headers_full_v.end_date%TYPE;
997: l_effective_date DATE := NULL;
998:
999: BEGIN
1000: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 1212: okl_k_headers_full_v khr

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
1216: -- dcshanmu bug 6734738 end

Line 1235: --okl_k_headers_full_v khr

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
1239: --AND tld.sty_id = sty.id

Line 1326: okl_k_headers_full_v khr

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
1330: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1427: okl_k_headers_full_v khr

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
1431: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1440: --okl_k_headers_full_v khr

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
1444: --AND sty.stream_type_purpose IN ('LOAN_PAYMENT', 'VARIABLE_LOAN_PAYMENT', 'UNSCHEDULED_LOAN_PAYMENT')

Line 1530: okl_k_headers_full_v khr

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
1534: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1545: --okl_k_headers_full_v khr

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
1547: --AND app.status = 'APP'
1548: --AND app.applied_payment_schedule_id = sch.payment_schedule_id
1549: --AND sch.class = 'INV'

Line 2127: okl_k_headers_full_v khr

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
2131: AND lpt.sty_id = sty.id