[Home] [Help]
8220: NULL asset_line_id,
8221: NULL ship_to_siteuseid,
8222: NULL inventory_item_id
8223: FROM okl_strm_type_b typ,
8224: okl_streams strm,
8225: okl_strm_elements selm,
8226: okc_k_lines_b lines,
8227: okc_line_styles_b lse
8228: WHERE strm.sty_id = typ.id
8256: cnsld.customer_trx_id,
8257: cnsld.customer_trx_line_id,
8258: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8259: FROM okl_strm_type_b typ,
8260: okl_streams strm,
8261: okl_strm_elements selm,
8262: okc_k_lines_b lines,
8263: okc_line_styles_b lse,
8264: okl_bpd_tld_ar_lines_v cnsld
8290: -- get all the financial asset lines for the contract
8291: CURSOR l_finassets_csr(CP_KHR_ID IN NUMBER) IS
8292: SELECT DISTINCT strm.kle_id fin_asset_id -- is DISTINCT req ? can an asset line have more than one stream types ?
8293: FROM okl_strm_type_b typ,
8294: okl_streams strm,
8295: okc_k_lines_b lines,
8296: okc_line_styles_b sty
8297: WHERE strm.sty_id = typ.id
8298: AND typ.billable_yn = 'Y'
8317: strm.kle_id line_id,
8318: strm.sty_id stream_type_id,
8319: sty.lty_code
8320: FROM okl_strm_type_b typ,
8321: okl_streams strm,
8322: okc_k_lines_b lines,
8323: okc_line_styles_b sty
8324: WHERE strm.sty_id = typ.id
8325: AND typ.billable_yn = 'Y'
10474: -- SECHAWLA 17-MAR-06 5022404 : For Billing adjustment quote line, get stream type from quote lines table
10475: IF l_txlquotelines_tbl(k).qlt_code = 'BILL_ADJST' THEN
10476: lx_sty_id := l_txlquotelines_tbl(k).sty_id;
10477: ELSE
10478: OKL_STREAMS_UTIL.get_primary_stream_type( p_khr_id => l_qte_khr_id,
10479: p_primary_sty_purpose => l_txlquotelines_tbl(k).qlt_code,
10480: x_return_status => x_return_status,
10481: x_primary_sty_id => lx_sty_id);
10482:
11000: strm.id stream_id,
11001: strm.kle_id line_id,
11002: strm.sty_id stream_type_id
11003: FROM okl_strm_type_b typ,
11004: okl_streams strm
11005: WHERE strm.sty_id = typ.id
11006: AND typ.billable_yn = 'Y'
11007: AND strm.say_code ='CURR'
11008: AND strm.active_yn = 'Y'
11063:
11064: CURSOR c_get_streams_count(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
11065: SELECT count(*)
11066: FROM okl_strm_type_b typ,
11067: okl_streams strm
11068: WHERE strm.sty_id = typ.id
11069: AND typ.billable_yn = 'Y'
11070: AND strm.say_code ='CURR'
11071: AND strm.active_yn = 'Y'