Query to find the Inventory TRANSACTION_TYPE_NAME/TRANSACTION_SOURCE_TYPE_NAME/TRANSACTION_ACTION_ID in Oracle APPS R12

 

/*TRANSACTION_TYPE_NAME/TRANSACTION_SOURCE_TYPE_NAME/TRANSACTION_ACTION_ID in Oracle APPS R12*/

SELECT a.transaction_type_id,
       a.transaction_type_name,
       a.transaction_source_type_id,
       b.transaction_source_type_name,
       a.transaction_action_id,
       c.meaning
FROM   mtl_transaction_types a,
       mtl_txn_source_types b,
       mfg_lookups c
WHERE  a.transaction_source_type_id = b.transaction_source_type_id
       AND a.transaction_action_id = c.lookup_code
       AND c.lookup_type = 'MTL_TRANSACTION_ACTION'
ORDER  BY transaction_type_id;