POZ_CONTACT_ACT_DATA_ACCESS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POZ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PER_PARTY_ID ACCESS_LEVEL ACCESS_CODE ACCESS_VALUE VENDOR_SITE_ID VENDOR_SITE_CODE VENDOR_ID PRC_BU_ID PARTY_SITE_NAME |
問合せ
| 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 |