Este tipo de consultas suelen ser solicitadas comúnmente en un entorno de siebel:

Selecciona empleado y posiciones:

select c.fst_name, c.last_name, cp.party_id, p.name
from siebel.s_contact c, siebel.s_party_per cp, siebel.s_postn p
where c.row_id = cp.person_id and
cp.party_id = p.row_id and
order by c.last_name, c.fst_name;

Selecciona todas las Responsabilidades por empleado:

select c.fst_name, c.last_name, r.name
from siebel.s_contact c, siebel.s_per_resp er, siebel.s_resp r
where c.row_id = er.per_id and
er.resp_id = r.row_id
order by c.last_name, c.fst_name

Selecciona todos logins, posiciones , divisiones y organizaciones:

select c.fst_name, c.last_name, u.login, p.name POSITION, d.name DIVISION, o.name ORGANIZATION
from siebel.s_contact c, siebel.s_party_per cp, siebel.s_postn p, siebel.s_org_ext d, siebel.s_bu o, siebel.s_user u
where c.row_id = cp.person_id and
cp.party_id = p.row_id and
p.ou_id = d.row_id and
p.bu_id = o.row_id and
c.row_id = u.row_id
order by c.last_name, c.fst_name