Oracle Apps Inventory Transaction setup scripts


a. Transaction types
PROMPT MANUFACTURING: INVENTORY
PROMPT Transaction Type

SELECT   transaction_type_id, transaction_action_id, transaction_source_type_id,
         transaction_type_name
    FROM mtl_transaction_types
   WHERE TO_CHAR (transaction_type_id) LIKE ('%&YourTransactionTypeID%')
ORDER BY transaction_type_id;

b. Transaction sources:
PROMPT Transaction Source
SELECT transaction_source_type_id, transaction_source_type_name
  FROM mtl_txn_source_types
 WHERE transaction_source_type_id LIKE NVL ('&TransSourceID', '%');