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_AM_CALC_QUOTE_STREAM_PVT dependencies on OKC_K_ITEMS

Line 223: FROM okc_k_items ite,

219: cp_quote_eff_date DATE) IS
220: SELECT stm.kle_id contract_line_id,
221: stm.sty_id stream_type_id,
222: kle.capital_amount line_payment
223: FROM okc_k_items ite,
224: okc_k_lines_b cle,
225: okl_k_lines_v kle,
226: okc_line_styles_b lse,
227: okl_streams stm,

Line 540: FROM okc_k_items ite,

536: cp_quote_eff_date DATE) IS
537: SELECT stm.kle_id contract_line_id,
538: stm.sty_id stream_type_id,
539: SUM (ste.amount) amount_due
540: FROM okc_k_items ite,
541: okc_k_lines_b kle,
542: okc_line_styles_b lse,
543: okl_streams stm,
544: okl_strm_type_b sty,

Line 844: FROM okc_k_items i,

840: CURSOR l_subline_outst_bal_csr (cp_chr_id NUMBER,cp_cle_id NUMBER) IS
841: SELECT l.contract_line_id contract_line_id,
842: l.stream_type_id stream_type_id,
843: SUM (l.amount_due_remaining) amount_due
844: FROM okc_k_items i,
845: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
846: -- okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
847: WHERE i.object1_id1 = cp_cle_id
848: AND l.CONTRACT_ID = cp_chr_id

Line 860: FROM okc_k_items i,

856: cp_cle_id NUMBER) IS
857: SELECT l.contract_line_id contract_line_id,
858: l.stream_type_id stream_type_id,
859: SUM (l.amount_due_remaining) amount_due
860: FROM okc_k_items i,
861: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
862: , OKC_K_HEADERS_B CHR
863: WHERE i.object1_id1 = cp_cle_id
864: AND l.contract_id = cp_chr_id