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
siru_115
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 ..



thanks
siri
Re: issue with shipment number [message #268767 is a reply to message #268673] Wed, 19 September 2007 11:37 Go to previous message
MarcL
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 
MTL_TRANSACTION_TYPES


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: Wed Dec 07 20:37:12 CST 2016

Total time taken to generate the page: 0.09932 seconds