Consultas SQL comunes en Siebel

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.namefrom siebel.s_contact c, siebel.s_party_per cp, siebel.s_postn pwhere c.row_id = cp.person_id andcp.party_id = p.row_id andorder 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 ORGANIZATIONfrom 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 uwhere c.row_id = cp.person_id andcp.party_id = p.row_id andp.ou_id = d.row_id andp.bu_id = o.row_id andc.row_id = u.row_idorder by c.last_name, c.fst_name