Get Maximo location hierarchy
Get location hierarchy in tree format
select lpad(' ',2*(level-1)) || to_char(location) s, level
from (select * from lochierarchy where siteid = 'BEDFORD')
start with parent is null
connect by prior location = parent;
Share this post
Blog Comments
epselon1
2017-12-30 21:02:52
Quick and easy
bizzarr
2018-01-11 19:05:48
Good one ..
Thank You! You comment is under review and will be published soon..
Thank You! You comment is Published.
Popular posts
Bulk add/remove of access rights
2015-01-03
Get Maximo location hierarchy
2017-11-08
Find and compile invalid Maximo objects
2016-05-05
Change NLS_LENGTH_SEMANTICS to CHAR
2015-03-01
Skip doclinks copy on object duplication
2019-06-27