PL_IMPORT_LOG_BY_ID.txt
| 1 |
ALTER PROCEDURE [dbo].[PL_IMPORT_LOG_GetByID] |
|---|---|
| 2 |
@p_IMPORT_ID varchar(15) = NULL |
| 3 |
AS |
| 4 |
BEGIN |
| 5 |
|
| 6 |
SELECT A.IMP_LOG_CODE, A.FILE_NAME,A.CREATE_DT,A.APPROVE_DT,MA.TLFullName AS MAKER_NAME,AP.TLFullName AS APPROVE_NAME |
| 7 |
FROM dbo.PL_IMPORT_LOG A |
| 8 |
|
| 9 |
LEFT JOIN dbo.TL_USER MA ON MA.TLNANME=A.EDITER_ID |
| 10 |
LEFT JOIN dbo.TL_USER AP ON AP.TLNANME=A.CHECKER_ID |
| 11 |
|
| 12 |
WHERE 1 = 1 |
| 13 |
AND A.IMP_ID=@p_IMPORT_ID |
| 14 |
AND A.RECORD_STATUS = '1' |
| 15 |
GROUP BY A.IMP_LOG_CODE , A.FILE_NAME,A.CREATE_DT,A.APPROVE_DT,MA.TLFullName,AP.TLFullName |
| 16 |
ORDER BY A.CREATE_DT DESC |
| 17 |
END |