There is a senario ..
In a table there are two entries with three columns.
1) FUNC_LOC = 12345: OPCAT = N: PROD_UNIT =X
2) FUNC_LOC = 54321: OPCAT = M: PROD_UNIT =' '
I have to implement a code if:
if a FUNC_LOC type M become a child of a FUNC_LOC type N, then that FUNC_LOC type M become a PROD_UNIT(means it becomes 'X')