277: BEGIN
278: SELECT max(rev.revision),
279: max(msi.revision_qty_control_code)
280: INTO var_revision, var_revision_ctrl
281: FROM mtl_system_items_b msi,
282: mtl_item_revisions rev
283: WHERE msi.inventory_item_id = p_inventoryItemId
284: AND msi.organization_id = p_organizationId
285: AND rev.inventory_item_id = msi.inventory_item_id