Project

General

Profile

Debug.txt

Luc Tran Van, 12/02/2022 01:56 PM

 
1
SELECT * FROM PL_REQUEST_TRANSFER prt WHERE prt.REQ_DOC_ID = @p_REQ_ID AND prt.FR_BRN_ID = 'DV0001' AND prt.FR_DEP_ID = 'DEP000000000023'
2
      AND (prt.FR_BRN_ID <> 'DV0001' OR (@BRANCH_CREATE = 'DV0001' AND prt.FR_DEP_ID <> 'DEP000000000014'))
3