ASS_ADDNEW.txt
| 1 |
DECLARE @tmp VARCHAR(25),@ASSET_ID VARCHAR(25) |
|---|---|
| 2 |
SELECT @ASSET_ID=ASSET_ID FROM dbo.ASS_MASTER WHERE ASSET_CODE='069TS24010012220001' |
| 3 |
SELECT @tmp=TRN_ID FROM ASS_TRANSACTIONS WHERE ASSET_ID =@ASSET_ID |
| 4 |
SELECT * FROM dbo.ASS_ADDNEW WHERE ADDNEW_ID =@tmp |
| 5 |
SELECT * FROM dbo.ASS_MASTER WHERE ASSET_CODE =@ASSET_ID |
| 6 |
SELECT * FROM dbo.ASS_ENTRIES_POST WHERE ASSET_ID =@ASSET_ID |