| | |
|---|
| | | left join T_SEC_user us1 with(nolock) on a.FCREATORID=us1.FUSERID |
|---|
| | | left join T_SEC_user us2 with(nolock) on a.FAPPROVERID=us2.FUSERID |
|---|
| | | left join T_SEC_user us3 with(nolock) on a.FMODIFIERID=us3.FUSERID |
|---|
| | | left join T_ORG_Organizations o with(nolock) on 1=o.FORGID |
|---|
| | | left join T_ORG_Organizations o with(nolock) on a.FCREATEORGID=o.FORGID |
|---|
| | | Where l.FLOCALEID=2052 and a.FFORBIDSTATUS='A' and a.FENTRYID='{id}' |
|---|
| | | select a.FID HID,a.FNUMBER HNumber,l.FName HName,l.FDESCRIPTION HRemark,l.FLOCALEID HLOCALEID |
|---|
| | | from T_BAS_ASSISTANTDATA a with(nolock) |
|---|
