Script to check Txn Type, Txn Source Type, Txn Action

最新推荐文章于 2025-07-03 21:28:28 发布

最新推荐文章于 2025-07-03 21:28:28 发布 · 86 阅读

本文提供了一个用于查询交易类型的SQL脚本，包括交易类型ID、名称、来源类型ID及动作ID等信息。此外还展示了如何查询交易来源类型和交易动作的详细含义。

Transaction Type = Transaction Source Type + Transaction Action
eg.Move Order Issue = Move Order + Issue From Stores

Below is the script to check Txn Type, Txn Source Type, Txn Action(Lookups)

--Txn Type
SELECT TRANSACTION_TYPE_ID, TRANSACTION_TYPE_NAME,TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID 
FROM MTL_TRANSACTION_TYPES 
ORDER BY TRANSACTION_TYPE_ID;

--Source Type
SELECT  TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_TYPE_NAME
FROM  MTL_TXN_SOURCE_TYPES ORDER BY TRANSACTION_SOURCE_TYPE_ID;

--Txn Action
SELECT LOOKUP_CODE,MEANING
FROM FND_LOOKUP_VALUES 
WHERE LANGUAGE = 'US' 
AND LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'
ORDER BY LOOKUP_CODE;

转载请注明出处： http://blog.youkuaiyun.com/pan_tian/article/details/7710980

======EOF======