Untitled

 

SELECT distinct S.SAMPLING_POINT AS LOCATION, P.CUSTOMER AS SUBMITTER, S.SAMPLE_NUMBER AS SAMPLE_NO, P.DATE_RECEIVED AS ENTERED_DATE, R.NAME AS PA_NAME, R.ANALYSIS AS NAME, R.DATE_REVIEWED AS VALIDATED_ON, R.ENTERED_ON, P.X_TAT_FOR_REPORT
AS TAT_TYPE1,S.X_TAT_FOR_SAMPLE AS TAT_TYPE2,

C.COMPANY_NAME

FROM SAMPLE S, RESULT R , PROJECT P, CUSTOMER C , TEST T


WHERE S.PROJECT=P.NAME AND

S.SAMPLE_NUMBER= R.SAMPLE_NUMBER

AND P.CUSTOMER=C.NAME AND S.SAMPLE_NUMBER= T.SAMPLE_NUMBER


AND R.REPORTABLE='T' AND S.STATUS <> 'X' AND R.STATUS <> 'X'


AND S.STANDARD = 'F'  AND P.STATUS ='V' AND P.CLOSED='T'


AND R.STATUS = 'A' AND R.ANALYSIS NOT LIKE 'X_%' AND 

R.DATE_REVIEWED between '09/28/2025' AND '10/01/2025'

AND P.CUSTOMER = 'gippswater ' AND  P.T_PROGRAM NOT IN ('BOREDUTSON','LEACHATEDUTSON','LANDFILLGDUTSON')