need help on script conversion

Ask a Question

Hi All,

i need convert the below SQL script into QV script. i can do that without conversion also, but due to some other requirements i need to covert.

SELECT C.InvDAE,
A.SID,
TRIM(A.CU_ID) COID,
TRIM(C.CAK_ID) CID,
C.CART CTYPE,
D.SO_L SLN,
DECODE(A.Progress,'R','Red','P','Pink','Y','Yellow','W','White') OS,
DECODE(C.Progress,'P','Pink','Y','Yellow','R', 'Red','W','White') CS,
      TRIM(D.PA_ID) SU,
D.P_DEC,
D.OR_QY OQY,
D.CO_QY CQY,
A.CU_ID||' '||E.NAME
FROM OR_HEAD A,
SO_HEAD C,
SO_DETA D,
CU_INFO E
WHERE A.SID = C.SID(+)
        AND A.CU_ID = C.CU_TOID(+)
        AND A.CU_ID = E.CU_ID
        AND C.SID = D.SID(+)
        AND C.CAK_ID = D.CAK_ID(+)
        AND A.PLANT = '100'
ORDER BY A.SID,D.SLIN

I hope you guys understand requirement.

More thanks

Ajay

0 Replies