POZ_CONTACT_ACT_DATA_ACCESS_V

Details

• Schema: FUSION

• Object owner: POZ

• Object type: VIEW

Columns

Name
PER_PARTY_ID ACCESS_LEVEL ACCESS_CODE ACCESS_VALUE VENDOR_SITE_ID VENDOR_SITE_CODE VENDOR_ID PRC_BU_ID PARTY_SITE_NAME

Query

SQL_Statement

/* Explicit supplier-site grants apply to SUPPLIER_SITE and MULTI contacts. MULTI site grants do not require companion supplier rows. */ SELECT lvl.per_party_id, lvl.access_level, acc.access_code, acc.access_value, s.vendor_site_id, s.vendor_site_code, s.vendor_id, s.prc_bu_id, pss.party_site_name FROM poz_contact_attributes lvl, pos_user_access_values acc, poz_supplier_sites_all_m s, hz_party_sites pss WHERE lvl.per_party_id = acc.per_party_id AND lvl.access_level IN ('SUPPLIER_SITE', 'MULTI') AND acc.access_code = 'SUPPLIER_SITE' AND acc.access_value = s.vendor_site_id AND s.party_site_id = pss.party_site_id UNION /* Supplier grants expand to all supplier sites for explicit SUPPLIER grants, including MULTI contacts with supplier grants. */ SELECT lvl.per_party_id, lvl.access_level, acc.access_code, acc.access_value, s.vendor_site_id, s.vendor_site_code, s.vendor_id, s.prc_bu_id, pss.party_site_name FROM poz_contact_attributes lvl, pos_user_access_values acc, poz_supplier_sites_all_m s, hz_party_sites pss WHERE lvl.per_party_id = acc.per_party_id AND lvl.access_level IN ('SUPPLIER', 'MULTI') AND acc.access_code = 'SUPPLIER' AND acc.access_value = s.vendor_id AND s.party_site_id = pss.party_site_id