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.csdn.net/pan_tian/article/details/7710980

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

ITPub博客

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

最新文章