I follow this kind of Indentation, which is little different from what other use
And when writing the codes, use fixed with font so the indentation will appear properly.
Code: sql
SELECT TP.START STARTED
, TP.FINISH FINISHED
, TP.ID PERIOD
, TM.PROJECTID PROJECTID
, TM.ID TEAMID
, TM.RESOURCEID RESOURCEID
, SUM(TE.ACT) ACT
FROM TASK TK
, TEAM TM
, ASSIGNMENT ASM
, TIMEENTRY TE
, PERIOD TP
, (SELECT MAX(A.ID) ID
, PERIODID
, RESOURCEID
FROM TIMESHEET A
, PERIOD B
WHERE STATUS IN (1,3,4)
AND ADJUSTMENT = 0
AND A.periodid = B.id
AND TRUNC(B.START) >= TRUNC(NEXT_DAY(NVL(NULL,SYSDATE)-28,'MONDAY'))
GROUP BY PERIODID
, RESOURCEID
) TS
WHERE TM.PROJECTID IN (SELECT PRJ.ID
FROM PROJECTS PRJ
, CU_PROJECT CU
, PRJ_ASSOC AS
, PRJ_UNITS OBS
, PRJ_TYPES TYPE
WHERE AS.TABLE_NAME = 'PROJECTS'
AND AS.RECORD_ID = PRJ.ID
AND AS.UNIT_ID = OBS.ID
AND OBS.TYPE_ID=TYPE.ID
AND TYPE.NAME='TEST1'
AND CU.ID=PRJ.ID
AND CU.PRT_CODE='TEST2'
)
AND TK.PROJECTID = TM.PROJECTID
AND ASM.TASKID = TK.ID
AND ASM.RESOURCEID = TM.RESOURCEID
AND TE.TIMESHEETID = TS.ID
AND TS.PERIODID = TP.ID
AND TE.ASSIGNID = ASM.ID
AND TRUNC(TP.START) >= TRUNC(NEXT_DAY(NVL(NULL,SYSDATE)-28,'MONDAY'))
GROUP BY TP.START
, TM.ID
, TM.RESOURCEID
, TM.PROJECTID
, TP.ID
, TP.FINISH
Did you use the same query exactly, as I found lot of syntactical errors?
