SELECT t. *, u.u ser_name, DE dep_name XMDW, re, s_name gys, rt. RETURN_USER, rt. RETURN_REASON, rt. Value
RETURN_TIME, pp.The from WZDP GUARD_STATE1 pp, WZDP. DP_INVOICE t, WZDP. Sys_user u, SYS_DEPARTMENT DE, wzapp. App_regact re, (select written BY k.R ETURN_REASON, written BY k.R ETURN_time, k.z ebeln, sr., user_name RETURN_USER from WZDP. Dp_invoice_return k, (select MAX (RETURN_TIME) RETURN_TIME, zebeln from WZDP. Dp_invoice_return GROUP BY zebeln) o, WZDP. Sys_user sr
Where pp. Id=t.p roblem_reason and o.z ebeln=k.Z ebeln and o.R ETURN_TIME=written by k.R ETURN_TIME and SR. USER_ID=written by k.R ETURN_USER) rt where t.R ECEIVE_USER=u.u ser_id (+) and DE. Dep_id=t.B UKRS and re. S_erp=t.S UPPLIER and rt. Zebeln (+)=t.z ebeln and t.z ebeln='4100408462' order by t.z NTDH, to_number (t.z num)


Everyone a great god why is this???????

CodePudding user response:

T.p roblem_reason
In a table or view DP_INVOICE t have any PROBLEM_REASON field (in the case of pay attention to the case, is there any mixed cases)

CodePudding user response:

WZDP. DP_INVOICE no problem_reason fields in the table? Take a closer look at next?

CodePudding user response:

DP_INVOICE no problem_reason fields in the table