Query to find suppliers with zip codes other than numeric and dash characters

  SELECT pv.vendor_name,
         pv.segment1 vendor_number,
         pvs.vendor_site_code,
         pvs.ADDRESS_LINE1,
         pvs.ADDRESS_LINE2,
         pvs.ADDRESS_LINE3,
         pvs.state,
         pvs.City,
         pvs.zip,
         pvs.country,
         hou.NAME OU
    FROM apps.po_vendors pv,
         apps.po_vendor_sites_all pvs,
         apps.hr_operating_units hou
   WHERE     pv.vendor_id = pvs.vendor_id
         AND pvs.org_id = hou.organization_id
         AND pv.ENABLED_FLAG = 'Y'
         AND NVL (pv.END_DATE_ACTIVE, SYSDATE + 1) >= SYSDATE
         AND NVL (pvs.INACTIVE_DATE, SYSDATE + 1) >= SYSDATE
         AND pvs.country = 'US'
         AND TRANSLATE (zip,
                        CHR (0) || '0123456789-' || CHR (9),
                        CHR (0))
                IS NOT NULL
ORDER BY pvs.org_id, pv.vendor_name

Discoverer Report Last Run By Stats Query

SELECT qs_doc_name disc_rpt_name,
         qs_doc_owner disc_rpt_owner,
         (SELECT user_name
            FROM fnd_user
           WHERE '#' || user_id = qs_created_by)
            disc_rpt_run_by,
         qs_created_date disc_rpt_run_date
    FROM disprd.eul5_qpp_stats
   WHERE qs_doc_name = 'XX Disc Report Name'
ORDER BY qs_created_date DESC