Previous Next JavaScript must be enabled to correctly display this content

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