Hello,
Would be able to help with my issue?
I have query build for Microsoft SQL Server Management Studio 17 and I am currently rewriting it to SQL Developer V3.2.2, but I am facing a problem with "OUTER APPLY " ( and some others)
Data extracted is from JDE 8.12
Please see below my query for SQL Developer:
SELECT t.TDCO, t.TDDGL, t.TDMCU, t.TDOBJ, t.TDSUB, t.TDAN8, AIAC09, ABAC15, t.TDDCTO, t.TDDOCO, t.TDICUT, t.TDITM, t.TDTXA1, AITXA1, t.TDTXR1, gl.GLEXR, t.TDSTAM/100 AS TDSTAM, gl.GLDOC, (gl.GLMCU||'.'||gl.GLOBJ||'.'||gl.GLSUB) AS GLANI,gl.GLAA/100 AS GLAA
FROM
(SELECT TDCO, TDAN8, TDDCTO, TDDOCO, TDITM, TDTXA1, TDTXR1, TDMCU, TDOBJ, TDSUB, TDAEXP, TDSTAM, TDCRCD, TDICUT, TDDGL, TDUSER
FROM proddta.F0018
WHERE TDCO= '22222' AND
((LTRIM(TDMCU)= '33333'AND TDDCTO NOT IN ('H1','H2','H3','H4','H5')) OR
(LTRIM(TDMCU)= '22222' AND TDDCTO IN ('H1','H2','H3','H4','H5'))) AND
TDSTAM <>'0' AND
TDDGL > '117275') t
LEFT JOIN proddta.F03012 ON AICO=t.TDCO AND AIAN8=t.TDAN8
LEFT JOIN proddta.F0101 ON ABAN8=t.TDAN8
OUTER APPLY
(SELECT GLCO, GLDOC, CONVERT(INT,substr(RTRIM(GLEXR),8)) AS GLEXR, GLEXA, GLMCU, GLOBJ, GLSUB, GLDGJ, GLAA
FROM proddta.F0911
WHERE GLCO= '22222' AND
GLOBJ = '212xxxx' AND GLLT = 'AA' AND
GLDCT = 'JE' AND GLPOST = 'P' AND
GLDGJ >'117275' AND CONVERT(INT,substr(RTRIM(GLEXR),8))=t.TDDOCO AND
GLOBJ=t.TDOBJ) gl WHERE gl.GLEXR IS NULL;
Would you know how cold I rewriting the below code for SQL Developer ?
OUTER APPLY
(SELECT GLCO, GLDOC, CONVERT(INT,substr(RTRIM(GLEXR),8)) AS GLEXR, GLEXA, GLMCU, GLOBJ, GLSUB, GLDGJ, GLAA
FROM proddta.F0911
WHERE GLCO= '33333' AND
GLOBJ = '212xxxx' AND GLLT = 'AA' AND
GLDCT = 'JE' AND GLPOST = 'P' AND
GLDGJ >'117275' AND CONVERT(INT,substr(RTRIM(GLEXR),8))=t.TDDOCO AND
GLOBJ=t.TDOBJ) gl WHERE gl.GLEXR IS NULL;