595: begin
596:
597: SELECT paa.purchasing_unit_of_measure
598: INTO x_purchasing_unit_of_measure
599: FROM po_asl_attributes_val_v paa
600: WHERE paa.vendor_id = x_vendor_id
601: AND paa.vendor_site_id = x_vendor_site_id
602: AND paa.item_id = x_item_id
603: AND paa.using_organization_id =
601: AND paa.vendor_site_id = x_vendor_site_id
602: AND paa.item_id = x_item_id
603: AND paa.using_organization_id =
604: (SELECT max(paa2.using_organization_id)
605: FROM po_asl_attributes_val_v paa2
606: WHERE decode(paa2.using_organization_id, -1,
607: x_organization_id,
608: paa2.using_organization_id) =
609: x_organization_id