APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_K_ITEMS

Line 2757: , ( select object1_id1||'#' || object1_id2 from okc_k_items

2753: , l.last_update_date termination_entry_date
2754: , h.trx_currency curr_code
2755: , h.func_currency curr_code_f
2756: , h.order_number hdr_order_number
2757: , ( select object1_id1||'#' || object1_id2 from okc_k_items
2758: where cle_id = sl.id and rownum=1) service_item_attribs
2759: /* For line lelvel order number */
2760: ,CASE WHEN root_lty_code <> 'WARRANTY' then (
2761: /* rel objs has multiple entries for the same order number */

Line 2848: , okc_k_items itm2

2844: FROM okc_line_styles_b n
2845: where lse_parent_id = l_service_code
2846: or lse_parent_id = l_warranty_code
2847: or lse_parent_id = l_ext_warr_code ) root_temp
2848: , okc_k_items itm2
2849: , oks_k_lines_b oksl
2850: WHERE 1 = 1
2851: AND h.worker_number = p_worker
2852: AND (h.chr_id = cur.chr_id OR upper(cur.rate_type) <> 'USER')

Line 5215: , okc_k_items itm

5211: FROM
5212: oki_dbi_chr_inc h
5213: , oki_dbi_curr_conv cur
5214: , okc_k_lines_b sl
5215: , okc_k_items itm
5216: , okc_k_lines_b l
5217: , ( select /*+ no_merge */ oab.agreement_id
5218: , qpl.meaning agreement_type_code
5219: , oat.name agreement_name

Line 5235: , okc_k_items itm2

5231: ) root_temp
5232: , oks_k_lines_b oksl
5233: /*, okc_operation_lines okl
5234: , okc_operation_instances OPINS */
5235: , okc_k_items itm2
5236: , csi_item_instances cii
5237: , ( /* rel objs has multiple entries for the same order number */
5238: Select /*+ no_merge parallel(oehdr) parallel(oelin) parallel(okcrel) */ okcrel.cle_id,max(oehdr.order_number) order_number
5239: from