Project

General

Profile

Feature #1416

VẬN HÀNH SAU GOLIVE NGÀY 07-12-2022

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/07/2022
Due date:
% Done:

0%

Estimated time:
CM_EMPLOYEE_Sync.txt (30.4 KB) CM_EMPLOYEE_Sync.txt Luc Tran Van, 12/07/2022 09:24 AM
CM_EMPLOYEE_Sync.txt (31.8 KB) CM_EMPLOYEE_Sync.txt Luc Tran Van, 12/07/2022 10:28 AM
TL_SYS_ROLE_MAPPING.txt (188 Bytes) TL_SYS_ROLE_MAPPING.txt Luc Tran Van, 12/07/2022 10:29 AM
script_MW_071222.txt (563 Bytes) script_MW_071222.txt Luc Tran Van, 12/07/2022 01:39 PM
TR_REQ_PAY_UPD_071222.txt (103 KB) TR_REQ_PAY_UPD_071222.txt Luc Tran Van, 12/07/2022 03:10 PM
PERIOD_Byid.txt (674 Bytes) PERIOD_Byid.txt Luc Tran Van, 12/07/2022 03:44 PM
rpt_PL_REQ_DOC_Inventory.txt (2.5 KB) rpt_PL_REQ_DOC_Inventory.txt Luc Tran Van, 12/07/2022 04:03 PM
ppay_upd.txt (40.7 KB) ppay_upd.txt Luc Tran Van, 12/07/2022 04:12 PM
tr_role_noti.txt (105 KB) tr_role_noti.txt Luc Tran Van, 12/08/2022 10:52 AM

History

#3 Updated by Luc Tran Van over 2 years ago

SELECT * FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008')
SELECT * FROM MW_MAST_BAL WHERE PRICE_ID IN (SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008'))
AND BRANCH_ID ='BRN000000000416'

SELECT * FROM MW_OUT_DT WHERE MAST_BAL_ID IN (SELECT MAST_BAL_ID FROM MW_MAST_BAL WHERE PRICE_ID IN (SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008'))
AND BRANCH_ID ='BRN000000000416')

Also available in: Atom PDF