APPS.IBE_PRICE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 797: from mtl_system_items_vl MSIV

793: l_primary_uom_code VARCHAR2(3);
794:
795: cursor l_bom_item_type_csr(l_itmid NUMBER) IS
796: select MSIV.bom_item_type, MSIV.primary_uom_code
797: from mtl_system_items_vl MSIV
798: where MSIV.inventory_item_id = l_itmid AND MSIV.organization_id = p_organization_id;
799:
800: l_resp_id NUMBER;
801: l_resp_appl_id NUMBER;

Line 2124: FROM mtl_system_items_vl

2120: WHERE org_id = l_operating_unit;
2121:
2122: CURSOR get_service_info_cur(l_item_id NUMBER, l_organization_id NUMBER) IS
2123: SELECT service_duration, service_duration_period_code
2124: FROM mtl_system_items_vl
2125: WHERE inventory_item_id = l_item_id
2126: AND organization_id = l_organization_id;
2127:
2128: BEGIN