| 123456789 |
- SELECT
- (SELECT COUNT(*) FROM information_schema.TABLES
- WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_trans_type_map') = 1
- AND (SELECT COUNT(*) FROM mdp_trans_type_map WHERE tenant_id=0) > 0
- AND (SELECT COUNT(*) FROM mdp_trans_type_map
- WHERE stage_code IS NOT NULL
- AND stage_code NOT IN (
- 'MAT_RECEIPT','MAT_IQC_RELEASE','MAT_PUTAWAY','MAT_PICK','MAT_ISSUE','MAT_LINE',
- 'FG_RECEIPT','FG_PUTAWAY','FG_PICK','FG_SHIP','FG_PROD_RECEIPT','FG_FQC_RELEASE')) = 0;
|
