Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Oil and Gas solution for 7.x

From: al_potanin (2011-08-05 06:24)

Guys,
We think about Oil and Gas solution and users asked me:
- what failure hierarchy and
- what classifications
it bringsĀ…
If you have this solution installed could you please share it with me?
I would much appreciate it.
You will need to run following queries and export it (Excel format is preferable)
- Failure hierarchy
select c.FAILURELIST, c.FAILURECODE, description, c.PARENT, p.FAILURECODE as parentCode, c.TYPE
from maximo.FAILURELIST c, maximo.FAILURECODE d, maximo.FAILURELIST p
where c.FAILURECODE=d.FAILURECODE and c.parent=p.failurelist(+);
- classifications
select c.CLASSIFICATIONID, c.DESCRIPTION, a.ASSETATTRID, d.description from maximo.CLASSSTRUCTURE c, maximo.CLASSSPEC a, maximo.ASSETATTRIBUTE d
where C.CLASSSTRUCTUREID=A.CLASSSTRUCTUREID(+) and A.ASSETATTRID=d.ASSETATTRID(+)
order by c.CLASSIFICATIONID, a.ASSETATTRID;
Regards,
Alexey