Supplier and Site Query Oracle ERP Cloud

SELECT psv.vendor_name supplier_name,

       psv.vendor_id supplier_id,

	   psv.segment1 supplier_number,

	   psv.enabled_flag,

	   psv.vendor_type_lookup_code,

	   psv.one_time_flag,

	   psv.start_date_active,

	   psv.end_date_active,

	   pssv.vendor_site_id,

	   pssv.vendor_site_code,

	   pssv.attribute1 wam_vendor_code,

	   pssv.address_line1,

	   pssv.city,

	   pssv.state,

	   pssv.country,

	   pssv.zip,

	   pssv.inactive_date

FROM poz_suppliers_v psv,

     poz_supplier_sites_v pssv

WHERE psv.vendor_id              = pssv.vendor_id

--AND psv.vendor_type_lookup_code  IN ( 'SUPPLIER','EMPLOYEE')

AND NVL(psv.enabled_flag,'N')    = 'Y'

AND NVL(psv.one_time_flag,'N')   = 'N'

AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE-1)) AND TRUNC(NVL(end_date_active,SYSDATE+1))

AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(effective_start_date,SYSDATE-1)) AND TRUNC(NVL(effective_end_date,SYSDATE+1))

Hope this Post helps