040121 11H14 AMS CAP NHAT HACH TOAN VE DUNG NGAY RETRY BUT TOAN NHAP - XUAT TS.txt
| 1 |
SELECT * FROM ASS_ADDNEW WHERE ADDNEW_ID IN ('ASA000000254220','ASA000000254235')
|
|---|---|
| 2 |
SELECT * FROM ASS_ENTRIES_POST WHERE TRN_ID IN ('ASA000000254235','ASA000000254220')
|
| 3 |
SELECT * FROM ASS_TRANSACTIONS WHERE TRN_ID IN ('ASA000000254220','ASA000000254235')
|
| 4 |
SELECT * FROM ASS_MASTER WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_TRANSACTIONS WHERE TRN_ID IN ('ASA000000254220','ASA000000254235'))
|
| 5 |
SELECT * FROM ASS_AMORT_DT WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_MASTER WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_TRANSACTIONS WHERE TRN_ID IN ('ASA000000254220','ASA000000254235')))
|