[Home] [Help]
115: select ulvb.id id1,
116: '#' id2,
117: ulv.name,
118: ulv.item_description description
119: from okc_k_lines_b ulvb,
120: okc_k_lines_tl ulv
121: where ulv.name = p_name
122: and ulvb.id = nvl(p_id1,ulvb.id)
123: and '#' = nvl(p_id2,'#')
2389: CURSOR get_lty_code_csr(p_chr_id NUMBER,
2390: p_cle_id NUMBER) IS
2391: SELECT lty_code
2392: FROM okc_line_styles_b lse,
2393: okc_k_lines_b cle
2394: WHERE lse.lse_parent_id = cle.lse_id
2395: AND cle.id = p_cle_id
2396: AND cle.chr_id = p_chr_id;
2397:
3472:
3473: select count(1)
3474:
3475: from okc_k_items cim
3476: , okc_k_lines_b cle
3477: , okc_line_style_sources lss
3478: , okc_line_styles_b lse
3479: where nvl(lss.start_date,sysdate) <= sysdate
3480: and nvl(lss.end_date,sysdate + 1) > sysdate
3491:
3492: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
3493: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3494: from okc_k_items cim
3495: , okc_k_lines_b cle
3496: , okc_line_style_sources lss
3497: , okc_line_styles_b lse
3498: where nvl(lss.start_date,sysdate) <= sysdate
3499: and nvl(lss.end_date,sysdate + 1) > sysdate
5045:
5046: select count(1)
5047:
5048: from okc_k_items cim
5049: , okc_k_lines_b cle
5050: , okc_line_style_sources lss
5051: , okc_line_styles_b lse
5052: where nvl(lss.start_date,sysdate) <= sysdate
5053: and nvl(lss.end_date,sysdate + 1) > sysdate
5065: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
5066:
5067: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5068: from okc_k_items cim
5069: , okc_k_lines_b cle
5070: , okc_line_style_sources lss
5071: , okc_line_styles_b lse
5072: where nvl(lss.start_date,sysdate) <= sysdate
5073: and nvl(lss.end_date,sysdate + 1) > sysdate
7287:
7288: l_rollover_yn varchar2(1) := null;
7289: cursor l_rollover_fee_csr is
7290: select 'Y'
7291: from okc_k_lines_b cle,
7292: okl_k_lines kle
7293: where cle.id = kle.id
7294: and cle.dnz_chr_id = p_chr_id
7295: and cle.chr_id = p_chr_id