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', '%');
