[Home] [Help]
8189: NULL asset_line_id,
8190: NULL ship_to_siteuseid,
8191: NULL inventory_item_id
8192: FROM okl_strm_type_b typ,
8193: okl_streams strm,
8194: okl_strm_elements selm,
8195: okc_k_lines_b lines,
8196: okc_line_styles_b lse
8197: WHERE strm.sty_id = typ.id
8225: cnsld.customer_trx_id,
8226: cnsld.customer_trx_line_id,
8227: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8228: FROM okl_strm_type_b typ,
8229: okl_streams strm,
8230: okl_strm_elements selm,
8231: okc_k_lines_b lines,
8232: okc_line_styles_b lse,
8233: okl_bpd_tld_ar_lines_v cnsld
8259: -- get all the financial asset lines for the contract
8260: CURSOR l_finassets_csr(CP_KHR_ID IN NUMBER) IS
8261: SELECT DISTINCT strm.kle_id fin_asset_id -- is DISTINCT req ? can an asset line have more than one stream types ?
8262: FROM okl_strm_type_b typ,
8263: okl_streams strm,
8264: okc_k_lines_b lines,
8265: okc_line_styles_b sty
8266: WHERE strm.sty_id = typ.id
8267: AND typ.billable_yn = 'Y'
8286: strm.kle_id line_id,
8287: strm.sty_id stream_type_id,
8288: sty.lty_code
8289: FROM okl_strm_type_b typ,
8290: okl_streams strm,
8291: okc_k_lines_b lines,
8292: okc_line_styles_b sty
8293: WHERE strm.sty_id = typ.id
8294: AND typ.billable_yn = 'Y'
10441: -- SECHAWLA 17-MAR-06 5022404 : For Billing adjustment quote line, get stream type from quote lines table
10442: IF l_txlquotelines_tbl(k).qlt_code = 'BILL_ADJST' THEN
10443: lx_sty_id := l_txlquotelines_tbl(k).sty_id;
10444: ELSE
10445: OKL_STREAMS_UTIL.get_primary_stream_type( p_khr_id => l_qte_khr_id,
10446: p_primary_sty_purpose => l_txlquotelines_tbl(k).qlt_code,
10447: x_return_status => x_return_status,
10448: x_primary_sty_id => lx_sty_id);
10449:
10965: strm.id stream_id,
10966: strm.kle_id line_id,
10967: strm.sty_id stream_type_id
10968: FROM okl_strm_type_b typ,
10969: okl_streams strm
10970: WHERE strm.sty_id = typ.id
10971: AND typ.billable_yn = 'Y'
10972: AND strm.say_code ='CURR'
10973: AND strm.active_yn = 'Y'
11028:
11029: CURSOR c_get_streams_count(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
11030: SELECT count(*)
11031: FROM okl_strm_type_b typ,
11032: okl_streams strm
11033: WHERE strm.sty_id = typ.id
11034: AND typ.billable_yn = 'Y'
11035: AND strm.say_code ='CURR'
11036: AND strm.active_yn = 'Y'