321: ** value.
322: */
323: SELECT msi.primary_unit_of_measure
324: INTO X_primary_uom
325: FROM mtl_system_items msi
326: WHERE inventory_item_id = x_item_id
327: AND organization_id = x_org_id;
328:
329:
625: BEGIN
626:
627: SELECT NVL(receiving_routing_id,0)
628: INTO x_routing_id
629: FROM mtl_system_items
630: WHERE inventory_item_id = x_item_id
631: AND organization_id = x_org_id;
632:
633: EXCEPTION