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_INS_QUOTE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

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