[Home] [Help]
243: kh.ESTIMATED_AMOUNT ,
244: ks.cls_code ,
245: ks.meaning ,
246: kst.ste_code
247: FROM okc_statuses_b kst,
248: okc_k_headers_b kh,
249: okc_k_headers_b kh2,
250: okc_subclasses_v ks
251: WHERE kh.id = b_chr_id
297: ,okc_k_items cim
298: ,okc_line_styles_b lse
299: ,okc_line_style_sources lss
300: ,okx_customer_products_v cpt
301: ,okc_statuses_b sts
302: WHERE
303: cim.cle_id = cle.id
304: AND cpt.id1 = cim.object1_id1
305: AND cpt.id2 = cim.object1_id2
356: ,okc_line_styles_b lse
357: ,okc_line_style_sources lss
358: ,okx_product_lines_v cpt
359: ,okx_system_items_v sit
360: ,okc_statuses_b sts
361: WHERE cim.cle_id = cle.id
362: AND cpt.id1 = cim.object1_id1
363: AND cpt.id2 = cim.object1_id2
364: AND cpt.dnz_chr_id = cle.dnz_chr_id
540: line_id okc_k_lines_v.id%TYPE
541: ,cle_id okc_k_lines_v.cle_id%TYPE
542: ,lse_id okc_k_lines_v.lse_id%TYPE
543: ,line_number okc_k_lines_v.line_number%TYPE
544: ,status_code okc_statuses_b.ste_code%TYPE
545: --
546: ,qty okc_k_items.number_of_items%TYPE
547: ,uom_code okc_k_items.uom_code%TYPE
548: ,customer_order_enabled_flag VARCHAR2(1)
586: TYPE covlvl_info_rec_typ IS RECORD (
587: line_tab_idx binary_integer
588: ,line_id okc_k_lines_b.id%TYPE
589: ,line_number okc_k_lines_b.line_number%TYPE
590: ,status_code okc_statuses_b.ste_code%TYPE
591: --
592: ,qty okc_k_items.number_of_items%TYPE
593: ,uom_code okc_k_items.uom_code%TYPE
594: ,priced_item_yn okc_k_items.priced_item_yn%TYPE
1507: ,cle.line_number line_number
1508: FROM
1509: okc_k_lines_b cle
1510: WHERE EXISTS ( SELECT 1
1511: FROM okc_statuses_b sts
1512: WHERE sts.code = cle.sts_code
1513: AND sts.ste_code <> g_sts_terminated )
1514: AND (
1515: (cle.cle_id IS NULL AND cle.config_item_type NOT IN (g_okc_model_item,g_okc_base_item,g_okc_config_item))
1571: okc_line_styles_b lse,
1572: okc_line_style_sources lss,
1573: jtf_objects_b jot,
1574: jtf_objects_b jot2,
1575: okc_statuses_b sts,
1576: -- okx_system_items_v sit,
1577: okx_config_items_v cfg
1578: WHERE
1579: cim.cle_id = cle.id