APPS.IBE_CATALOG_PVT dependencies on MTL_ITEM_UOMS_VIEW

Line 2079: FROM MTL_ITEM_UOMS_VIEW miuv

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

Line 2200: FROM MTL_ITEM_UOMS_VIEW miuv

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

Line 2709: FROM MTL_ITEM_UOMS_VIEW miuv

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