APPS.OKL_INS_QUOTE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4592: MTL_SYSTEM_ITEMS_B_KFV MSIB

4588: -- inventory org change
4589: CURSOR okl_count_k_product_csr(p_isu_id NUMBER, p_total_oec NUMBER, p_from_date DATE ,p_inv_org_id NUMBER) IS
4590: SELECT COUNT(*) --Bug:3825159
4591: FROM OKL_INS_PRODUCTS_B IPTB,
4592: MTL_SYSTEM_ITEMS_B_KFV MSIB
4593: WHERE IPTB.IPD_ID =MSIB.INVENTORY_ITEM_ID
4594: AND iptb.isu_id = p_isu_id
4595: AND IPTB.IPT_TYPE = 'LEASE_PRODUCT'
4596: AND p_total_oec BETWEEN IPTB.FACTOR_MIN AND IPTB.FACTOR_MAX

Line 4607: MTL_SYSTEM_ITEMS_B_KFV MSIB

4603: CURSOR okl_k_product_csr(p_isu_id NUMBER, p_total_oec NUMBER, p_from_date DATE ,p_inv_org_id NUMBER) IS
4604: SELECT iptb.ID ,iptt.NAME --Bug:3825159
4605: FROM OKL_INS_PRODUCTS_TL IPTT,
4606: OKL_INS_PRODUCTS_B IPTB,
4607: MTL_SYSTEM_ITEMS_B_KFV MSIB
4608: WHERE IPTB.ID = IPTT.ID
4609: AND IPTT.LANGUAGE = USERENV('LANG')
4610: AND IPTB.IPD_ID = MSIB.INVENTORY_ITEM_ID
4611: AND iptb.isu_id = p_isu_id

Line 4688: MTL_SYSTEM_ITEMS MTL,

4684:
4685: CURSOR c_loan_item_category(p_financial_line_id NUMBER) IS
4686: SELECT mtl.ASSET_CATEGORY_ID, MTL.DESCRIPTION
4687: FROM
4688: MTL_SYSTEM_ITEMS MTL,
4689: OKC_K_items FA_ITEM ,
4690: OKC_K_LINES_B MODEL,
4691: OKC_LINE_STYLES_B LS_MODEL
4692: WHERE

Line 4707: l_item MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;

4703: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
4704: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
4705:
4706: l_financial_line_id NUMBER ;
4707: l_item MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;
4708: l_deal_type VARCHAR2(30);
4709: l_item_category NUMBER;
4710:
4711: BEGIN