SQL Language (MOSC)

MOSC Banner

How to add the reason name to move order lines?

edited Nov 18, 2019 7:16AM in SQL Language (MOSC) 2 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center