SELECT d.id, d.name, dv.*
FROM PROCESS_INSTANCE pi 
INNER JOIN PROCESS_DEFINITION pd ON (pi.processdefinition = pd.oid and pi.model = pd.model)
INNER JOIN DATA_VALUE dv on (pi.scopeprocessinstance = dv.processinstance)
INNER JOIN DATA d on (dv.data = d.oid and dv.model = d.model)
INNER JOIN MODEL m on (pi.model = m.oid)
WHERE pi.oid = ?;

SELECT d.id, d.name, sd.xpath, sdv.*
FROM PROCESS_INSTANCE pi 
INNER JOIN PROCESS_DEFINITION pd ON (pi.processdefinition = pd.oid and pi.model = pd.model)
INNER JOIN STRUCTURED_DATA_VALUE sdv on (pi.scopeprocessinstance = sdv.processinstance)
INNER JOIN STRUCTURED_DATA sd on (sd.oid = sdv.xpath)
INNER JOIN DATA d on (sd.data = d.oid and sd.model = d.model)
INNER JOIN MODEL m on (pi.model = m.oid)
WHERE pi.oid = ?;

select pd.ID,pi.OID, SUBSTR(sd.XPATH,1,20) as "XPATH", SUBSTR(sdv.STRING_VALUE,1,20) as "STRING_VALUE", sdv.NUMBER_VALUE
FROM
PROCESS_INSTANCE pi,PROCESS_DEFINITION pd, DATA_VALUE dv, STRUCTURED_DATA sd, STRUCTURED_DATA_VALUE sdv
WHERE
pd.OID = pi.processDefinition
and pi.OID = dv.processInstance
and dv.data = sd.data
and sd.OID = sdv.XPATH
and pi.OID = sdv.processInstance
;