ET_BYID.txt
| 1 |
ALTER PROC [dbo].[TR_REQ_PAY_ENTRIES_ById] |
|---|---|
| 2 |
@p_TRN_ID varchar(15) = NULL |
| 3 |
AS |
| 4 |
BEGIN |
| 5 |
SELECT A.REQ_PAY_DT_ID, A.REQ_PAY_ID,A.FUNCTION_TYPE,A.REF_ID,A.ENTRY_PAIR,A.DR_CR,A.DR_CR_NAME,A.ACCT,ISNULL(C.ACC_NAME,'') AS ACCT_NAME,A.BRANCH_ID,A.DEP_ID,A.AMT,A.CURRENCY,A.EXC_RATE,A.TRN_DATE,A.TRN_DESC, |
| 6 |
A.MAKER_ID,A.CREATE_DT,A.AUTH_STATUS,A.CHECKER_ID,A.APPROVE_DT,A.MAKER_ID_KT,A.CREATE_DT_KT,A.AUTH_STATUS_KT,A.CHECKER_ID_KT,A.RECORD_STATUS |
| 7 |
, BR.BRANCH_CODE, BR.BRANCH_NAME, BR.BRANCH_CODE+' - '+ BR.BRANCH_NAME AS BR_FULLNAME, |
| 8 |
DP.DEP_CODE, DP.DEP_NAME, DP.DEP_CODE+ ' - '+ DP.DEP_NAME AS DP_FULLNAME |
| 9 |
FROM TR_REQ_PAY_ENTRIES A |
| 10 |
LEFT JOIN CM_BRANCH BR ON A.BRANCH_ID = BR.BRANCH_ID |
| 11 |
LEFT JOIN CM_DEPARTMENT DP ON A.DEP_ID= DP.DEP_ID |
| 12 |
LEFT JOIN CM_ACCOUNT C ON A.ACCT = C.ACC_NO |
| 13 |
WHERE A.REQ_PAY_ID =@p_TRN_ID OR @p_TRN_ID ='' |
| 14 |
END |
| 15 |
|