Hi all. I have an OTBI report I created to get a list of all supplier contacts and whether they have user accounts enabled. However we realized that contacts with no address assignment were not showing up in the report. After some investigation, I've realized that they simply don't show up in the poz_supplier_contacts_v view, so I need to get to the base tables to figure this out. But I'm having a hard time figuring it out. Any tips? Below is what I had based on the view
select cv.FIRST_NAME
,cv.LAST_NAME
,cv.EMAIL_ADDRESS
,cv.status
,cv.inactive_date
,hzp.ATTRIBUTE3 as CONTACT_VERIFIED
,v.SEGMENT1
,v.vendor_name
,vs.vendor_site_code
,vs.ATTRIBUTE8 as CATEGORY
,pu.ACTIVE_FLAG as USER_ACCOUNT_ACTIVE
,pu.USERNAME
,prdt.role_name
from poz_supplier_contacts_v cv
LEFT JOIN hz_person_profiles hzp
ON cv.PER_PARTY_ID = hzp.PARTY_ID
LEFT JOIN poz_suppliers_v v
ON cv.vendor_id = v.vendor_id
LEFT JOIN poz_supplier_sites_v vs
ON cv.vendor_site_id = vs.vendor_site_id
LEFT JOIN per_users pu
ON cv.PER_PARTY_ID = pu.party_id
LEFT JOIN per_user_roles pur
ON pu.user_id = pur.user_id
LEFT JOIN per_roles_dn_tl prdt
ON pur.role_id = prdt.role_id
where 1=1
and v.SEGMENT1 like :VENDOR_NUM
