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 |
---|
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 = 'SUPPLIER_SITE' AND acc.access_code = 'SUPPLIER_SITE' AND acc.access_value = s.vendor_site_id AND s.party_site_id = pss.party_site_id UNION 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 = 'SUPPLIER' AND acc.access_code = 'SUPPLIER' AND acc.access_value = s.vendor_id AND s.party_site_id = pss.party_site_id |