3193: into l_unit_price,
3194: l_po_uom
3195: From po_lines_all pol,
3196: Po_headers_all poh,
3197: mtl_units_of_measure muom
3198: Where
3199: poh.type_lookup_code = 'BLANKET'
3200: AND poh.approved_flag = 'Y'
3201: AND nvl(poh.closed_code,'OPEN') NOT IN('FINALLY CLOSED','CLOSED')