How to add the reason name to move order lines?
Hello,
This is simple for the SQL experts out there! I want to add the reason_name from mtl_transaction_reasons to the sql below. The field reason_id will join mtl_transaction_reasons and mtl_txn_request_lines_v.
I want all the rows in mtl_txn_request_lines_v to be returned, no matter if reason_id is populated or null. What is the proper approach? A join, another condition, a sub-select?
SELECT request_number AS "Move Order Name", mtrl.creation_date, transaction_type_name, move_order_type_name, organization_code
FROM
apps.mtl_txn_request_lines_v mtrl,