Convert Text Equation to an 'actual' Equation?
The query:
SELECT CONNECT_BY_ROOT(IXKIT) OSZ56ITMP, CONNECT_BY_ROOT(IXMMCU) OSZ56MCUP, LEVEL OSLEV,
A.IXMMCU OSMMCU, A.IXKIT OSKIT, A.IXKITL OSKITL, A.IXCMCU OSCMCU,
A.IXITM OSCPIT, A.IXLITM OSCPIL, A.IXQNTY OSQNTY, ('1' ||SYS_CONNECT_BY_PATH(a.ixqnty/10000, '*')) OSEXQTY
FROM TESTDTA.F3002 A
WHERE A.IXTBM='M' AND A.IXMMCU IN (' 2620001',' 2740001') AND IXEFFF<114021 AND IXEFFT>114021
START WITH A.IXKIT IN (SELECT DISTINCT D.SDITM FROM TESTDTA.F4211 D
WHERE A.IXMMCU=D.SDMCU AND D.SDMCU IN (' 2620001',' 2740001') AND D.SDNXTR<'560' AND D.SDPDDJ<115108 AND SDITM > 0 AND SDDOCO=12000034 )