Oracle01841错误,出现ORA-01841: 问题，急急急急

SELECT PROJECT PROJECT,

SUBSTR(B.LAST_UPDATE_DATE, 1, LENGTH(B.LAST_UPDATE_DATE)) LAST_UPDATE_DATE,

REQUEST_ID REQUEST_ID,

ASSIGNED_ID ASSIGNED_ID,

REQUEST_TYPE_NAME REQUEST_TYPE_NAME,       (第一层)

STATUS_NAME STATUS_NAME,

U.FIRST_NAME || ' ' || U.LAST_NAME FIRST_NAME_ULAST_NAME,

REQUEST_ID REQUEST_ID_HIPERLINK

FROM (SELECT PROJECT,

PROJECT_ID,

REQUEST_TYPE_NAME,                        (第二层)

REQUEST_ID,

REVIEW,

SCHEDULED_AUDIT,

DATE_EVA,

A.DESCRIPTION,

TRUNC(A.LAST_UPDATE_DATE) LAST_UPDATE_DATE,

STATUS_NAME,

U1.FULL_NAME CREATED_BY,

U2.FULL_NAME ASSIGNED_ID,

AUD_BY,

AUDITED_BY,

PROJECT_TYPE,

DM_ID,

PM_ID,

ADM_ID,

PL_ID

FROM (SELECT AUD_BY,

AUDITED_BY,

CREATED_BY,

ASSIGNED_TO_USER_ID,

STATUS_ID,

LAST_UPDATE_DATE,                              (第三层)

REQUEST_TYPE_ID,

REQUEST_ID,

REVIEW,

SCHEDULED_AUDIT,

DATE_EVA,

CASE

WHEN TRUNC(DATE_EVA) >= TRUNC(CURRENT_DATE - 31) THEN

'GREEN'

ELSE

'RED'

END AS DESCRIPTION,

PROJECT_TYPE,

DM_ID,

PM_ID,

ADM_ID,

PL_ID,

PROJECT_ID,

PROJECT,

REQUEST_TYPE_NAME

FROM (SELECT RHD.PARAMETER10 AUD_BY,

RHD.VISIBLE_PARAMETER10 AUDITED_BY,

R.CREATED_BY,

R.ASSIGNED_TO_USER_ID,                  (第四层)

R.STATUS_ID,

R.LAST_UPDATE_DATE,

R.REQUEST_TYPE_ID,

R.REQUEST_ID,

RHD.PARAMETER2 REVIEW,

RHD.PARAMETER17 SCHEDULED_AUDIT,

NVL(TO_DATE(RHD.PARAMETER2,

'YYYY-MM-DD HH24:MI:SS'),

TO_DATE(RHD.PARAMETER17,

'YYYY-MM-DD HH24:MI:SS')) DATE_EVA,

RD.PARAMETER3 PROJECT_TYPE,

RD.PARAMETER44 DM_ID,

RD.VISIBLE_PARAMETER44 DM,

RD.PARAMETER42 PM_ID,

RD.VISIBLE_PARAMETER42 PM,

RD.PARAMETER43 ADM_ID,

RD.VISIBLE_PARAMETER43 ADM,

RD.PARAMETER45 PL_ID,

RD.VISIBLE_PARAMETER45 PL,

RHD.PARAMETER5 LOCATION,

RD.PARAMETER1 PROJECT_ID,

RD.VISIBLE_PARAMETER1 PROJECT,

KRT.REQUEST_TYPE_NAME

FROM PPM.KCRT_REQUESTS           R,

PPM.KCRT_REQ_HEADER_DETAILS RHD,

PPM.KCRT_REQUEST_DETAILS    RD,

PPM.KCRT_REQUEST_TYPES      KRT

WHERE 1 = 1

AND R.REQUEST_ID = RHD.REQUEST_ID

AND R.REQUEST_ID = RD.REQUEST_ID

AND KRT.REQUEST_TYPE_ID = RHD.REQUEST_TYPE_ID

AND KRT.REQUEST_TYPE_ID = RD.REQUEST_TYPE_ID

AND KRT.REQUEST_TYPE_ID = R.REQUEST_TYPE_ID

AND KRT.REQUEST_TYPE_NAME = 'Audit Request'

AND RHD.BATCH_NUMBER = 1

AND RD.BATCH_NUMBER = 1

AND R.STATUS_CODE IN ('NEW', 'IN_PROGRESS'))

WHERE 1 = 1) A,

PPM.KCRT_STATUSES S,

PPM.KNTA_USERS U1,

PPM.KNTA_USERS U2

WHERE 1 = 1

AND S.STATUS_ID = A.STATUS_ID

AND U1.USER_ID = A.CREATED_BY

AND U2.USER_ID(+) = A.ASSIGNED_TO_USER_ID) B,

PPM.KNTA_USERS U

WHERE 1 = 1

AND B.AUD_BY = U.USER_ID(+)

AND B.DESCRIPTION IN ('GREEN')

AND ROWNUM <= 200

ORDER BY REQUEST_ID ASC