APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_ITEMS_V

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 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 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'