Home » Applications » Oracle Fusion Apps & E-Business Suite » issue with shipment number
issue with shipment number [message #268673] Wed, 19 September 2007 06:06 Go to next message
Messages: 2
Registered: September 2007
Junior Member
Hi all,
Im new to this forum,
i have a doubt regarding the shipment number.
i need to generate a report with shipment number column in it
shipment number comes from mtl_material_transactions table but the condition in my report is

if it is inter-org transfer then i have to print the shipment#
if it is internal sales order then i have to pront the salesorder#

MTL_TRANSACTION_TYPES -->TRANSACTION_TYPE_NAME we find different types of transactions like inter-org and internal sales order
but i dnt know how to get the shipment number based on that condition
can anyone plz help me out ..

Re: issue with shipment number [message #268767 is a reply to message #268673] Wed, 19 September 2007 11:37 Go to previous message
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Without having much Oracle Apps knowledge.

Something like:

select decode(txn_type,'INTERORG',ship_no,'INTERNAL',salesorder,null) as reference_no from 

should do the trick.

Obviously untested and you would need to join on the mtl_type_id to the transaction_name table etc etc
Previous Topic: tomorrow my exam!
Next Topic: Interview Tips
Goto Forum:

Current Time: Mon Oct 24 11:24:30 CDT 2016

Total time taken to generate the page: 0.09578 seconds