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.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_ITEMS

Line 657: okc_k_items srv_item,

653: okl_item.number_of_items okl_no_of_item,
654: srv_item.number_of_items srv_no_of_item
655: FROM okc_k_lines_b srv_line,
656: okc_line_styles_b srv_style,
657: okc_k_items srv_item,
658: okx_customer_products_v srv_prod,
659: okc_k_items okl_item,
660: mtl_system_items_b okl_mtl,
661: okc_k_lines_b okl_item_line,

Line 659: okc_k_items okl_item,

655: FROM okc_k_lines_b srv_line,
656: okc_line_styles_b srv_style,
657: okc_k_items srv_item,
658: okx_customer_products_v srv_prod,
659: okc_k_items okl_item,
660: mtl_system_items_b okl_mtl,
661: okc_k_lines_b okl_item_line,
662: okc_k_lines_v okl_fin_line,
663: okc_line_styles_b okl_style

Line 688: okc_k_items_v item,

684: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS
685: SELECT nvl(sum(l.price_negotiated),0) tot_amount
686: FROM okc_k_lines_v l,
687: okc_line_styles_v s,
688: okc_k_items_v item,
689: okx_install_items_v prod
690: WHERE l.lse_id = s.id
691: AND l.id = item.cle_id
692: AND item.object1_id1 = prod.id1

Line 695: FROM okc_k_items_v item,

691: AND l.id = item.cle_id
692: AND item.object1_id1 = prod.id1
693: AND EXISTS (
694: SELECT 'Y'
695: FROM okc_k_items_v item,
696: okx_system_items_v mtl,
697: okc_k_lines_v line,
698: okc_line_styles_v style
699: WHERE item.object1_id1 = mtl.id1

Line 733: FROM okc_k_items_v

729: CURSOR item_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
730: SELECT object1_id1,
731: object1_id2,
732: uom_code
733: FROM okc_k_items_v
734: WHERE cle_id = p_cle_id
735: AND jtot_object1_code = 'OKX_SERVICE';
736:
737: l_lse_id OKC_K_LINES_V.LSE_ID%TYPE;

Line 750: l_uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE;

746:
747: l_inv_item_id NUMBER;
748: l_inv_org_id NUMBER;
749:
750: l_uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE;
751:
752: l_start_date DATE;
753: l_end_date DATE;
754:

Line 3059: okc_k_items ib_item,

3055: ib_item.object1_id1,
3056: ib_item.object1_id2
3057: FROM okc_k_lines_b ib_line,
3058: okc_line_styles_b ib_style,
3059: okc_k_items ib_item,
3060: okc_k_lines_b cov_line,
3061: okc_k_items cov_item,
3062: okc_k_lines_b inst_line,
3063: okc_line_styles_b inst_style,

Line 3061: okc_k_items cov_item,

3057: FROM okc_k_lines_b ib_line,
3058: okc_line_styles_b ib_style,
3059: okc_k_items ib_item,
3060: okc_k_lines_b cov_line,
3061: okc_k_items cov_item,
3062: okc_k_lines_b inst_line,
3063: okc_line_styles_b inst_style,
3064: okc_k_rel_objs rel
3065: WHERE rel.cle_id = cov_line.id

Line 3089: FROM okc_k_items

3085: CURSOR oks_ib_csr (p_oks_chr_id OKC_K_HEADERS_B.ID%TYPE,
3086: p_oks_cov_line_id OKC_K_LINES_B.ID%TYPE) IS
3087: SELECT object1_id1,
3088: object1_id2
3089: FROM okc_k_items
3090: WHERE cle_id = p_oks_cov_line_id
3091: AND dnz_chr_id = p_oks_chr_id;
3092: --AND chr_id = p_oks_chr_id;
3093: -- don't use chr_id, use dnz_chr_id instead Bug# 2739831

Line 3104: okc_k_items kitem,

3100: csi.install_location_id location_id,
3101: csi.install_location_type_code location_type_code,
3102: csi.instance_number
3103: FROM okc_k_rel_objs krel,
3104: okc_k_items kitem,
3105: csi_item_instances csi,
3106: okc_k_lines_b line,
3107: okc_line_styles_b style,
3108: OKC_STATUSES_B sts

Line 3133: l_ib_item_id OKC_K_ITEMS_V.ID%TYPE;

3129: l_link_line_tbl OKL_SERVICE_INTEGRATION_PUB.link_line_tbl_type;
3130: l_cimv_rec okc_contract_item_pub.cimv_rec_type;
3131: x_cimv_rec okc_contract_item_pub.cimv_rec_type;
3132: l_ib_line_id OKC_K_LINES_B.ID%TYPE;
3133: l_ib_item_id OKC_K_ITEMS_V.ID%TYPE;
3134: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3135: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3136:
3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

Line 3134: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

3130: l_cimv_rec okc_contract_item_pub.cimv_rec_type;
3131: x_cimv_rec okc_contract_item_pub.cimv_rec_type;
3132: l_ib_line_id OKC_K_LINES_B.ID%TYPE;
3133: l_ib_item_id OKC_K_ITEMS_V.ID%TYPE;
3134: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3135: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3136:
3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3138: l_oks_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

Line 3135: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

3131: x_cimv_rec okc_contract_item_pub.cimv_rec_type;
3132: l_ib_line_id OKC_K_LINES_B.ID%TYPE;
3133: l_ib_item_id OKC_K_ITEMS_V.ID%TYPE;
3134: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3135: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3136:
3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3138: l_oks_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3139:

Line 3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

3133: l_ib_item_id OKC_K_ITEMS_V.ID%TYPE;
3134: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3135: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3136:
3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3138: l_oks_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3139:
3140: l_item_desc OKL_LA_COV_ASSET_UV.item_description%TYPE;
3141:

Line 3138: l_oks_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

3134: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3135: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3136:
3137: l_oks_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
3138: l_oks_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
3139:
3140: l_item_desc OKL_LA_COV_ASSET_UV.item_description%TYPE;
3141:
3142: BEGIN -- main process begins here

Line 3606: FROM okc_k_items cov_item,

3602: -- bug 4889070. START
3603: AND lease_item_qty = service_item_qty
3604: -- bug 4889070. END
3605: AND NOT EXISTS (SELECT 'Y'
3606: FROM okc_k_items cov_item,
3607: okc_k_lines_b line
3608: WHERE cov_item.object1_id1 = cov_asset.id1
3609: AND cov_item.jtot_object1_code = 'OKX_COVASST'
3610: AND line.id = cov_item.cle_id

Line 4339: okc_k_items kitem

4335:
4336: CURSOR link_asset_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4337: SELECT kitem.object1_id1
4338: FROM okc_k_rel_objs rel,
4339: okc_k_items kitem
4340: WHERE rel.cle_id = kitem.cle_id
4341: AND rel.rty_code = 'OKLSRV'
4342: AND rel.jtot_object1_code = 'OKL_COV_PROD'
4343: AND kitem.jtot_object1_code = 'OKX_COVASST'

Line 4355: okc_k_items_v kitem

4351: FROM okc_k_lines_b form2,
4352: okc_line_styles_b f2_style,
4353: okc_k_lines_b inst,
4354: okc_line_styles_b inst_style,
4355: okc_k_items_v kitem
4356: WHERE form2.lse_id = f2_style.id
4357: AND f2_style.lty_code = 'FREE_FORM2'
4358: AND inst.lse_id = inst_style.id
4359: AND inst_style.lty_code = 'INST_ITEM'

Line 4366: CURSOR oks_ib_csr (p_instance_id OKC_K_ITEMS.OBJECT1_ID1%TYPE) IS

4362: AND form2.id = inst.cle_id
4363: AND form2.dnz_chr_id = p_chr_id
4364: AND form2.cle_id = p_cle_id;
4365:
4366: CURSOR oks_ib_csr (p_instance_id OKC_K_ITEMS.OBJECT1_ID1%TYPE) IS
4367: SELECT DECODE(count(1),0,'N','Y') ib_exists
4368: FROM okc_k_items
4369: WHERE object1_id1 = p_instance_id
4370: AND jtot_object1_code = 'OKX_CUSTPROD';

Line 4368: FROM okc_k_items

4364: AND form2.cle_id = p_cle_id;
4365:
4366: CURSOR oks_ib_csr (p_instance_id OKC_K_ITEMS.OBJECT1_ID1%TYPE) IS
4367: SELECT DECODE(count(1),0,'N','Y') ib_exists
4368: FROM okc_k_items
4369: WHERE object1_id1 = p_instance_id
4370: AND jtot_object1_code = 'OKX_CUSTPROD';
4371:
4372: l_ib_used VARCHAR2(1) := 'N';