eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OC_INT_KTQ_PVT dependencies on OKC_K_LINES_V

Line 540: line_id okc_k_lines_v.id%TYPE

536: --
537: -- global type declarations
538: --
539: TYPE line_info_rec_typ IS RECORD (
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

Line 541: ,cle_id okc_k_lines_v.cle_id%TYPE

537: -- global type declarations
538: --
539: TYPE line_info_rec_typ IS RECORD (
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: --

Line 542: ,lse_id okc_k_lines_v.lse_id%TYPE

538: --
539: TYPE line_info_rec_typ IS RECORD (
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

Line 543: ,line_number okc_k_lines_v.line_number%TYPE

539: TYPE line_info_rec_typ IS RECORD (
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

Line 549: ,item_name okc_k_lines_v.name%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
552: ,price_unit okc_k_lines_v.price_unit%TYPE
553: ,price_negotiated okc_k_lines_v.price_negotiated%TYPE

Line 552: ,price_unit okc_k_lines_v.price_unit%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
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE

Line 553: ,price_negotiated okc_k_lines_v.price_negotiated%TYPE

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
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE

Line 554: ,line_list_price okc_k_lines_v.line_list_price%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
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --

Line 555: ,price_list_id okc_k_lines_v.price_list_id%TYPE

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
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE

Line 556: ,price_list_line_id okc_k_lines_v.price_list_line_id%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
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE

Line 557: ,currency_code okc_k_lines_v.currency_code%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
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE

Line 559: ,config_header_id okc_k_lines_v.config_header_id%TYPE

555: ,price_list_id okc_k_lines_v.price_list_id%TYPE
556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE
562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE
563: ,config_item_id okc_k_lines_v.config_item_id%TYPE

Line 560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE

556: ,price_list_line_id okc_k_lines_v.price_list_line_id%TYPE
557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE
562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE
563: ,config_item_id okc_k_lines_v.config_item_id%TYPE
564: ,config_item_type okc_k_lines_v.config_item_type%TYPE

Line 561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE

557: ,currency_code okc_k_lines_v.currency_code%TYPE
558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE
562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE
563: ,config_item_id okc_k_lines_v.config_item_id%TYPE
564: ,config_item_type okc_k_lines_v.config_item_type%TYPE
565: ,component_code okx_config_items_v.component_code%TYPE

Line 562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE

558: --
559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE
562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE
563: ,config_item_id okc_k_lines_v.config_item_id%TYPE
564: ,config_item_type okc_k_lines_v.config_item_type%TYPE
565: ,component_code okx_config_items_v.component_code%TYPE
566: --

Line 563: ,config_item_id okc_k_lines_v.config_item_id%TYPE

559: ,config_header_id okc_k_lines_v.config_header_id%TYPE
560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE
562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE
563: ,config_item_id okc_k_lines_v.config_item_id%TYPE
564: ,config_item_type okc_k_lines_v.config_item_type%TYPE
565: ,component_code okx_config_items_v.component_code%TYPE
566: --
567: ,start_date okc_k_lines_v.start_date%TYPE

Line 564: ,config_item_type okc_k_lines_v.config_item_type%TYPE

560: ,config_revision_number okc_k_lines_v.config_revision_number%TYPE
561: ,config_complete_yn okc_k_lines_v.config_complete_yn%TYPE
562: ,config_valid_yn okc_k_lines_v.config_valid_yn%TYPE
563: ,config_item_id okc_k_lines_v.config_item_id%TYPE
564: ,config_item_type okc_k_lines_v.config_item_type%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

Line 567: ,start_date okc_k_lines_v.start_date%TYPE

563: ,config_item_id okc_k_lines_v.config_item_id%TYPE
564: ,config_item_type okc_k_lines_v.config_item_type%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

Line 568: ,end_date okc_k_lines_v.end_date%TYPE

564: ,config_item_type okc_k_lines_v.config_item_type%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: --

Line 793: p_cle_id IN okc_k_lines_v.id%TYPE,

789: -- x_bto_data_tab Table of billto rule info
790: -- x_sto_data_tab Table of shipto rule info
791: --
792: PROCEDURE build_k_rules( p_chr_id IN okc_k_headers_b.ID%TYPE,
793: p_cle_id IN okc_k_lines_v.id%TYPE,
794: x_rule_tab OUT NOCOPY rule_tbl_typ,
795: x_bto_data_rec OUT NOCOPY bto_sto_rec_typ,
796: x_sto_data_rec OUT NOCOPY bto_sto_rec_typ,
797: x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 1569: okc_k_lines_v cle,

1565: --
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,