DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 393: SELECT uom_code FROM mtl_uom_conversions_view mucv

389: x_return_status OUT nocopy VARCHAR2)
390: IS
391:
392: CURSOR c_mtl_uom IS
393: SELECT uom_code FROM mtl_uom_conversions_view mucv
394: WHERE mucv.inventory_item_id = p_item_id
395: AND mucv.organization_id = p_org_id
396: AND mucv.conversion_rate = p_total_qty
397: AND Nvl(mucv.uom_code,'@@@') = Nvl(p_primary_uom,Nvl(mucv.uom_code,'@@@'));