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======