126: ,end_date okc_k_lines_v.end_date%TYPE
127: ,k_item_id okc_k_items.id%TYPE
128: ,object_id1 okc_k_items.object1_id1%TYPE
129: ,object_id2 okc_k_items.object1_id2%TYPE
130: ,line_style okc_line_styles_b.lse_type%TYPE
131: ,line_type okc_line_styles_b.lty_code%TYPE
132: );
133:
134: TYPE line_info_tab_typ IS TABLE OF line_info_rec_typ INDEX BY BINARY_INTEGER;
127: ,k_item_id okc_k_items.id%TYPE
128: ,object_id1 okc_k_items.object1_id1%TYPE
129: ,object_id2 okc_k_items.object1_id2%TYPE
130: ,line_style okc_line_styles_b.lse_type%TYPE
131: ,line_type okc_line_styles_b.lty_code%TYPE
132: );
133:
134: TYPE line_info_tab_typ IS TABLE OF line_info_rec_typ INDEX BY BINARY_INTEGER;
135:
631: ,lse.lty_code line_type
632: FROM
633: okc_k_lines_v cle,
634: okc_k_items cim,
635: okc_line_styles_b lse,
636: okc_statuses_b sts
637: WHERE
638: cim.cle_id = cle.id
639: AND lse.id = cle.lse_id