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_B

Line 296: ,okc_k_lines_b cle

292: ,cim.jtot_object1_code item_source_code
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

Line 354: ,okc_k_lines_b cle

350: ,sit.name prod_name
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

Line 583: TYPE line_info_ren_typ_dnr IS TABLE OF okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;

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;
583: TYPE line_info_ren_typ_dnr IS TABLE OF okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
584:
585:
586: TYPE covlvl_info_rec_typ IS RECORD (
587: line_tab_idx binary_integer

Line 588: ,line_id okc_k_lines_b.id%TYPE

584:
585:
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

Line 589: ,line_number okc_k_lines_b.line_number%TYPE

585:
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

Line 595: ,price_unit okc_k_lines_b.price_unit%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: --
599: ,start_date okc_k_lines_b.start_date%TYPE

Line 596: ,price_negotiated okc_k_lines_b.price_negotiated%TYPE

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: --
599: ,start_date okc_k_lines_b.start_date%TYPE
600: ,end_date okc_k_lines_b.end_date%TYPE

Line 597: ,currency_code okc_k_lines_b.currency_code%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: --
599: ,start_date okc_k_lines_b.start_date%TYPE
600: ,end_date okc_k_lines_b.end_date%TYPE
601: --

Line 599: ,start_date okc_k_lines_b.start_date%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: --
599: ,start_date okc_k_lines_b.start_date%TYPE
600: ,end_date okc_k_lines_b.end_date%TYPE
601: --
602: ,line_style okc_line_styles_b.lse_type%TYPE
603: ,line_type okc_line_styles_b.lty_code%TYPE

Line 600: ,end_date okc_k_lines_b.end_date%TYPE

596: ,price_negotiated okc_k_lines_b.price_negotiated%TYPE
597: ,currency_code okc_k_lines_b.currency_code%TYPE
598: --
599: ,start_date okc_k_lines_b.start_date%TYPE
600: ,end_date okc_k_lines_b.end_date%TYPE
601: --
602: ,line_style okc_line_styles_b.lse_type%TYPE
603: ,line_type okc_line_styles_b.lty_code%TYPE
604: ,line_source_code jtf_objects_b.object_code%TYPE

Line 631: cle_id okc_k_lines_b.id%TYPE,

627: --
628: TYPE rule_rec_typ IS RECORD
629: (
630: chr_id okc_k_headers_b.id%TYPE,
631: cle_id okc_k_lines_b.id%TYPE,
632: object1_id1 okc_rules_b.object1_id1%TYPE
633: ,object1_id2 okc_rules_b.object1_id2%TYPE
634: ,jtot_object1_code okc_rules_b.jtot_object1_code%TYPE
635: ,object2_id1 okc_rules_b.object2_id1%TYPE

Line 653: cle_id okc_k_lines_b.id%TYPE,

649:
650: TYPE bto_sto_rec_typ IS RECORD
651: (
652: chr_id okc_k_headers_b.id%TYPE,
653: cle_id okc_k_lines_b.id%TYPE,
654: --
655: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
656: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
657: party_id okx_cust_site_uses_v.party_id%TYPE,

Line 1285: p_cle_id IN okc_k_lines_b.id%TYPE,

1281: -- p_rlt_type
1282: --
1283: --
1284: FUNCTION is_kl_linked_to_ql(p_chr_id IN NUMBER,
1285: p_cle_id IN okc_k_lines_b.id%TYPE,
1286: p_qh_id IN okx_quote_headers_v.id1%TYPE,
1287: p_rlt_code IN VARCHAR2,
1288: p_rlt_type IN VARCHAR2
1289: ) RETURN VARCHAR2 IS

Line 1509: okc_k_lines_b cle

1505: CURSOR c_top_cle_init(b_chr_id NUMBER) IS
1506: SELECT cle.id line_id
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 )

Line 2811: l_top_line_unit_price okc_k_lines_b.price_unit%TYPE;

2807: l_line_skipped BOOLEAN;
2808: l_continue BOOLEAN;
2809: l_nb_qte_line_dtl NUMBER;
2810: --
2811: l_top_line_unit_price okc_k_lines_b.price_unit%TYPE;
2812: l_topln_unit_prc_assgnd VARCHAR2(1);
2813: l_unit_price_assigned okc_k_lines_b.price_unit%TYPE;
2814: --
2815: l_previous_line_id okc_k_lines_b.id%TYPE;

Line 2813: l_unit_price_assigned okc_k_lines_b.price_unit%TYPE;

2809: l_nb_qte_line_dtl NUMBER;
2810: --
2811: l_top_line_unit_price okc_k_lines_b.price_unit%TYPE;
2812: l_topln_unit_prc_assgnd VARCHAR2(1);
2813: l_unit_price_assigned okc_k_lines_b.price_unit%TYPE;
2814: --
2815: l_previous_line_id okc_k_lines_b.id%TYPE;
2816: l_cur_tl NUMBER;
2817: l_cur_cl NUMBER;

Line 2815: l_previous_line_id okc_k_lines_b.id%TYPE;

2811: l_top_line_unit_price okc_k_lines_b.price_unit%TYPE;
2812: l_topln_unit_prc_assgnd VARCHAR2(1);
2813: l_unit_price_assigned okc_k_lines_b.price_unit%TYPE;
2814: --
2815: l_previous_line_id okc_k_lines_b.id%TYPE;
2816: l_cur_tl NUMBER;
2817: l_cur_cl NUMBER;
2818: l_id1 okx_quote_line_detail_v.id1%TYPE;
2819: --