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

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