672bbd5c8d
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2950 248e525c-4dfb-0310-94bc-949c084e9493
23 lines
839 B
Plaintext
23 lines
839 B
Plaintext
CREATE OR REPLACE VIEW v_supplier_administrators AS
|
|
SELECT supplier.ID AS supplier_id,
|
|
supplier.NAME AS supplier,
|
|
supplier.shortcode AS shortcode,
|
|
supp_admin.id AS supp_admin_id,
|
|
supp_admin.username,
|
|
supp_admin.first_name,
|
|
supp_admin.last_name
|
|
FROM parties supplier,
|
|
parties supp_admin,
|
|
party_roles supplier_role,
|
|
party_roles supp_admin_role,
|
|
party_relationships parel
|
|
WHERE parel.from_parl_prty_id = supp_admin.id
|
|
AND parel.from_parl_id = supp_admin_role.ID
|
|
AND parel.to_parl_prty_id = supplier.ID
|
|
AND parel.to_parl_id = supplier_role.ID
|
|
AND supp_admin_role.prty_id = supp_admin.ID
|
|
AND supp_admin_role.rt_code = 'SUPPADMIN'
|
|
AND supplier_role.prty_id = supplier.ID
|
|
AND supplier_role.rt_code = 'SUPP'
|
|
ORDER BY 1;
|