106: po_line_types plt,
107: po_vendor_contacts vc,
108: po_vendor_sites vs,
109: po_vendors v,
110: mtl_system_items msi,
111: po_requisition_lines porl
112: WHERE porl.rowid = x_rowid
113: AND nvl(porl.cancel_flag,'N') = 'N'
114: AND nvl(porl.closed_code,'OPEN') <> 'FINALLY CLOSED'
276: BEGIN
277:
278: SELECT primary_unit_of_measure
279: INTO x_primary_unit_of_measure
280: FROM mtl_system_items
281: WHERE inventory_item_id = x_inventory_item_id
282: AND organization_id = x_organization_id;
283:
284: return(x_primary_unit_of_measure);