| 123456789101112 |
- -- 有库存入站模板时，13 个推送实体必须已开通。没有模板时本脚本不插入，验收放行。
- SELECT
- (SELECT COUNT(*) FROM mdp_entity WHERE entity_code='S5_INVENTORY_TXN') = 0
- OR (
- SELECT COUNT(*) FROM mdp_entity
- WHERE entity_code IN (
- 'S2_WORK_ORDER_SCHEDULE','S3_PURCHASE_ORDER','S3_PURCHASE_RECEIPT',
- 'S4_SHIPMENT','S4_IQC','S4_RETURN','S4_SHORTAGE',
- 'S6_WORK_ORDER_LINE','S7_SALES_ORDER_LINE','S5_WORK_ORDER_BOM',
- 'S6_REPORT_TXN','S7_FQC_TASK_TXN','S5_INVENTORY_BALANCE_MONTHLY')
- AND status=1 AND inbound_enabled=1
- ) = 13;
|
