Hi all,
We have three warehouses and and three Goods In Transfer (GIT) warehouses. Transfers happen in two phases a below:
TRANSFER between whse A and B
Whse A----->GIT whseB -
> WhseB
I have developed queries to trigger approvals for each step as follows:
STEP1
SELECT DISTINCT 'TRUE' FROM WTR1 T0 WHERE $[WTR1.WhsCode]='GIT_whseB'
step2:
SELECT DISTINCT 'TRUE' FROM OWHS T0 WHERE $[OWTR.Filler]='GIT_whseB' AND $[WTR1.whscode]='whseB'
in Step 1,Mr John (whseA) initiates the transfer and Mr Peter (WhseB) approves it hence goods lie in GIT_WhseB. This step works perfectly.
My issue occurs in step 2: Mr. Peter (whseB) initiates the transfer from GIT-whseB to whseB. I want to come up with a better step2 query than the above which will ensure that only Mr. John (the first transfer initiator) gets the approval alert - not any other user from the third warehouse.
I hope you I am clear enough. Thank you.
Rgds,
Henry