| issue with shipment number [message #268673] |
Wed, 19 September 2007 06:06  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
