APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_K_ITEMS

Line 297: ,okc_k_items cim

293: ,jot.from_table item_source_table
294: FROM
295: jtf_objects_b jot
296: ,okc_k_lines_b cle
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

Line 355: ,okc_k_items cim

351: ,cim.jtot_object1_code
352: ,jot.from_table
353: FROM jtf_objects_b jot
354: ,okc_k_lines_b cle
355: ,okc_k_items cim
356: ,okc_line_styles_b lse
357: ,okc_line_style_sources lss
358: ,okx_product_lines_v cpt
359: ,okx_system_items_v sit

Line 546: ,qty okc_k_items.number_of_items%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)
549: ,item_name okc_k_lines_v.name%TYPE
550: --,item_name VARCHAR2(150)

Line 547: ,uom_code okc_k_items.uom_code%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)
549: ,item_name okc_k_lines_v.name%TYPE
550: --,item_name VARCHAR2(150)
551: ,priced_item_yn okc_k_items.priced_item_yn%TYPE

Line 551: ,priced_item_yn okc_k_items.priced_item_yn%TYPE

547: ,uom_code okc_k_items.uom_code%TYPE
548: ,customer_order_enabled_flag VARCHAR2(1)
549: ,item_name okc_k_lines_v.name%TYPE
550: --,item_name VARCHAR2(150)
551: ,priced_item_yn okc_k_items.priced_item_yn%TYPE
552: ,price_unit okc_k_lines_v.price_unit%TYPE
553: ,price_negotiated okc_k_lines_v.price_negotiated%TYPE
554: ,line_list_price okc_k_lines_v.line_list_price%TYPE
555: ,price_list_id okc_k_lines_v.price_list_id%TYPE

Line 569: ,k_item_id okc_k_items.id%TYPE

565: ,component_code okx_config_items_v.component_code%TYPE
566: --
567: ,start_date okc_k_lines_v.start_date%TYPE
568: ,end_date okc_k_lines_v.end_date%TYPE
569: ,k_item_id okc_k_items.id%TYPE
570: ,object_id1 okc_k_items.object1_id1%TYPE
571: ,object_id2 okc_k_items.object1_id2%TYPE
572: --
573: ,line_style okc_line_styles_b.lse_type%TYPE

Line 570: ,object_id1 okc_k_items.object1_id1%TYPE

566: --
567: ,start_date okc_k_lines_v.start_date%TYPE
568: ,end_date okc_k_lines_v.end_date%TYPE
569: ,k_item_id okc_k_items.id%TYPE
570: ,object_id1 okc_k_items.object1_id1%TYPE
571: ,object_id2 okc_k_items.object1_id2%TYPE
572: --
573: ,line_style okc_line_styles_b.lse_type%TYPE
574: ,line_type okc_line_styles_b.lty_code%TYPE

Line 571: ,object_id2 okc_k_items.object1_id2%TYPE

567: ,start_date okc_k_lines_v.start_date%TYPE
568: ,end_date okc_k_lines_v.end_date%TYPE
569: ,k_item_id okc_k_items.id%TYPE
570: ,object_id1 okc_k_items.object1_id1%TYPE
571: ,object_id2 okc_k_items.object1_id2%TYPE
572: --
573: ,line_style okc_line_styles_b.lse_type%TYPE
574: ,line_type okc_line_styles_b.lty_code%TYPE
575: ,line_source_code okc_line_style_sources.jtot_object_code%TYPE

Line 578: ,item_source_code okc_k_items.jtot_object1_code%TYPE

574: ,line_type okc_line_styles_b.lty_code%TYPE
575: ,line_source_code okc_line_style_sources.jtot_object_code%TYPE
576: ,line_source_table jtf_objects_b.from_table%TYPE
577: --
578: ,item_source_code okc_k_items.jtot_object1_code%TYPE
579: ,item_source_table jtf_objects_b.from_table%TYPE
580: );
581:
582: TYPE line_info_tab_typ IS TABLE OF line_info_rec_typ INDEX BY BINARY_INTEGER;

Line 592: ,qty okc_k_items.number_of_items%TYPE

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
595: ,price_unit okc_k_lines_b.price_unit%TYPE
596: ,price_negotiated okc_k_lines_b.price_negotiated%TYPE

Line 593: ,uom_code okc_k_items.uom_code%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
595: ,price_unit okc_k_lines_b.price_unit%TYPE
596: ,price_negotiated okc_k_lines_b.price_negotiated%TYPE
597: ,currency_code okc_k_lines_b.currency_code%TYPE

Line 594: ,priced_item_yn okc_k_items.priced_item_yn%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
595: ,price_unit okc_k_lines_b.price_unit%TYPE
596: ,price_negotiated okc_k_lines_b.price_negotiated%TYPE
597: ,currency_code okc_k_lines_b.currency_code%TYPE
598: --

Line 607: ,id1 okc_k_items.object1_id1%TYPE

603: ,line_type okc_line_styles_b.lty_code%TYPE
604: ,line_source_code jtf_objects_b.object_code%TYPE
605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --
607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE
609: ,prod_name okx_system_items_v.name%TYPE
610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE

Line 608: ,id2 okc_k_items.object1_id2%TYPE

604: ,line_source_code jtf_objects_b.object_code%TYPE
605: ,line_source_table jtf_objects_b.from_table%TYPE
606: --
607: ,id1 okc_k_items.object1_id1%TYPE
608: ,id2 okc_k_items.object1_id2%TYPE
609: ,prod_name okx_system_items_v.name%TYPE
610: ,item_source_code jtf_objects_b.object_code%TYPE
611: ,item_source_table jtf_objects_b.from_table%TYPE
612: --

Line 1570: okc_k_items cim,

1566: ,cim.jtot_object1_code item_source_code
1567: ,jot.from_table item_source_table
1568: FROM
1569: okc_k_lines_v cle,
1570: okc_k_items cim,
1571: okc_line_styles_b lse,
1572: okc_line_style_sources lss,
1573: jtf_objects_b jot,
1574: jtf_objects_b jot2,