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 795: FROM okc_k_items i,

791: CURSOR l_subline_outst_bal_csr (cp_chr_id NUMBER,cp_cle_id NUMBER) IS
792: SELECT l.contract_line_id contract_line_id,
793: l.stream_type_id stream_type_id,
794: SUM (l.amount_due_remaining) amount_due
795: FROM okc_k_items i,
796: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
797: -- okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
798: WHERE i.object1_id1 = cp_cle_id
799: AND l.CONTRACT_ID = cp_chr_id

Line 811: FROM okc_k_items i,

807: cp_cle_id NUMBER) IS
808: SELECT l.contract_line_id contract_line_id,
809: l.stream_type_id stream_type_id,
810: SUM (l.amount_due_remaining) amount_due
811: FROM okc_k_items i,
812: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
813: , OKC_K_HEADERS_B CHR
814: WHERE i.object1_id1 = cp_cle_id
815: AND l.contract_id = cp_chr_id