[Oracle]TRANSACTION_TYPE List

SELECT MTT.TRANSACTION_TYPE_ID           T_TYPE_ID,
       MTT.TRANSACTION_TYPE_NAME         T_TYPE_NAME,
       MTT.DESCRIPTION,
       MTT.TRANSACTION_SOURCE_TYPE_ID    T_S_TYPE_ID,
       MTST.TRANSACTION_SOURCE_TYPE_NAME T_S_TYPE_NAME,
       MTST.DESCRIPTION,
       MTT.TRANSACTION_ACTION_ID         ACTION_ID,
       ML.MEANING                        ACTION_NAME
  FROM MTL_TRANSACTION_TYPES MTT, MTL_TXN_SOURCE_TYPES MTST, MFG_LOOKUPS ML
 WHERE 1 = 1
   AND MTT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
      --AND MTT.USER_DEFINED_FLAG <> 'Y'
   AND MTT.TRANSACTION_ACTION_ID = ML.LOOKUP_CODE
   AND ML.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'
 ORDER BY MTT.TRANSACTION_TYPE_ID;