SELECT MTT.TRANSACTION_SOURCE_TYPE_ID "来源ID",
MTST.TRANSACTION_SOURCE_TYPE_NAME 来源,
DECODE(MTT.USER_DEFINED_FLAG, 'Y', '用户', '系统') 类别,
MTT.TRANSACTION_TYPE_ID "事务处理类型ID",
MTT.TRANSACTION_TYPE_NAME 事务处理类型,
MTT.Description 描述,
MTT.TRANSACTION_ACTION_ID
FROM INV.MTL_TRANSACTION_TYPES MTT, INV.MTL_TXN_SOURCE_TYPES MTST
WHERE MTT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
ORDER BY 1, 4;
04-07
1004
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)