APPS.IBE_CATALOG_PVT dependencies on MTL_ITEM_UOMS_VIEW

Line 2078: FROM MTL_ITEM_UOMS_VIEW miuv

2074: IF ((l_retrieve_all_uom IS NULL) OR (l_retrieve_all_uom = 'Y')) THEN
2075: IF ((p_load_level = G_ITEM_SHALLOW) OR (p_load_level = G_ITEM_DEEP)) THEN
2076: OPEN x_uom_csr FOR
2077: SELECT miuv.INVENTORY_ITEM_ID, miuv.UOM_CODE
2078: FROM MTL_ITEM_UOMS_VIEW miuv
2079: WHERE miuv.INVENTORY_ITEM_ID = l_itmid
2080: AND miuv.ORGANIZATION_ID = p_organization_id
2081: ORDER BY miuv.UOM_CODE;
2082: END IF;

Line 2199: FROM MTL_ITEM_UOMS_VIEW miuv

2195: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2196:
2197: CURSOR l_item_uom_csr IS
2198: SELECT miuv.INVENTORY_ITEM_ID, miuv.UOM_CODE
2199: FROM MTL_ITEM_UOMS_VIEW miuv
2200: WHERE miuv.INVENTORY_ITEM_ID = p_itmid
2201: AND miuv.ORGANIZATION_ID = p_organization_id
2202: ORDER BY miuv.UOM_CODE;
2203:

Line 2708: FROM MTL_ITEM_UOMS_VIEW miuv

2704: WHERE MSIV.inventory_item_id = l_item_id;
2705:
2706: CURSOR l_uom_csr(l_item_id NUMBER) IS
2707: SELECT miuv.UOM_CODE
2708: FROM MTL_ITEM_UOMS_VIEW miuv
2709: WHERE miuv.INVENTORY_ITEM_ID = l_item_id
2710: AND miuv.ORGANIZATION_ID = p_organization_id
2711: ORDER BY miuv.UOM_CODE;
2712: