top of page

Tags

Archive

Supplier and Site Query Oracle ERP Cloud

Updated: Jul 26, 2020


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

4,862 views0 comments

Recent Posts

See All

Business units Query-Oracle Fusion

The below Query will be handy while fetching Business unit name in r13 instance. SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS, FUBU.MODULE_NAME, FUBU.CONFIGURATION_STATUS, TO_CHAR(HOU.DATE_FROM,

Other Posts you may Interested