select distinct(vendor_product_num) supplier_item from po_lines union
select distinct(suggested_vendor_product_code) supplier_item from 
po_reqexpress_lines order by  1 

select vendor_product_num supplier_item from po_lines_all, po_headers_all
where po_lines_all.po_header_id = po_headers_all.po_header_id
and po_headers_all.status_lookup_code = 'A'
and po_headers_all.quote_type_lookup_code = 'CATALOG'
and sysdate between nvl(po_headers_all.start_date, sysdate -  1 ) and nvl(po_headers_all.closed_date, sysdate +  1 )
union
select suggested_vendor_product_code supplier_item from po_reqexpress_lines_all, po_headers_all
where po_reqexpress_lines_all.po_header_id = po_headers_all.po_header_id 
and po_headers_all.status_lookup_code = 'A'
and po_headers_all.quote_type_lookup_code = 'CATALOG'
and sysdate between nvl(po_headers_all.start_date, sysdate -  1 ) and nvl(po_headers_all.closed_date, sysdate +  1 )
order by  1 

declare
  lov_id lov := find_lov('SIC_FIND_VENDOR_PRODUCT_NUM_QP');
  rg_id recordgroup;
  err number;
begin
  rg_id := create_Group_from_Query('MY_FIND_VENDOR_PRODUCT_NUM_QP',
  'select vendor_product_num supplier_item from po_lines_all, po_headers_all ' ||
  'where po_lines_all.po_header_id = po_headers_all.po_header_id ' ||
  'and po_headers_all.status_lookup_code = ''A'' ' ||
  'and po_headers_all.quote_type_lookup_code = ''CATALOG'' ' ||
  'and sysdate between nvl(po_headers_all.start_date, sysdate - 1) and nvl(po_headers_all.closed_date, sysdate + 1) ' ||
  'union ' ||
  'select suggested_vendor_product_code supplier_item from po_reqexpress_lines_all, po_headers_all ' ||
  'where po_reqexpress_lines_all.po_header_id = po_headers_all.po_header_id ' ||
  'and po_headers_all.status_lookup_code = ''A'' ' ||
  'and po_headers_all.quote_type_lookup_code = ''CATALOG'' ' ||
  'and sysdate between nvl(po_headers_all.start_date, sysdate - 1) and nvl(po_headers_all.closed_date, sysdate + 1) ' ||
  'order by 1 ');
  err := populate_group(rg_id);
  set_lov_property(lov_id, GROUP_NAME, 'MY_FIND_VENDOR_PRODUCT_NUM_QP');
end;