Project

General

Profile

Support #480

Kiểm tra mã tài sản 069CC15010205200071 thông báo đang xuất sử dụng - Khi user tiến hành xuất sử dụng tài sản

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
10/19/2020
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM ASS_MASTER WHERE ASSET_CODE ='069CC15010205200071'
SELECT TOP 1 * FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID ='SMA000000001448'
SELECT TOP 1 * FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID ='SMA000000001480'
SELECT * FROM ASS_USE_MULTI_DT WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_MASTER WHERE ASSET_CODE ='069CC15010205200071')

069CC15010205200071.xlsx (21.1 KB) 069CC15010205200071.xlsx Luc Tran Van, 10/19/2020 11:03 AM

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed
  • Assignee set to Luc Tran Van

Also available in: Atom PDF