[OAUGNet]-Re: Linking mtl_material_transactions and mtl_sales_orders

["Greg Birkett" <gbirkett@adelphia.net>]

Kathy,

Did you get an answer on this?
I have been wondering the same thing.

Thanks,
Greg
greg.birkett@qlogic.com

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com]On Behalf Of Kathy
Sadaitys
Sent: Thursday, October 14, 2004 8:03 AM
To: OAUG Net listserver
Subject: [OAUGNet]-Linking mtl_material_transactions and
mtl_sales_orders


I am trying to make the link between mtl_material_transactions and
mtl_sales_orders. I know the link is between
mtl_material_transactions.transaction_source_id and
mtl_sales_orders.sales_order_id. My questions is, how do I tell which
transactions should be linked to mtl_sales_order. Can I get that by
transaction_source_type_id, or another column? If it is
transaction_source_type_id, which standard id's should be used. I was
thinking, 2,7,8 and 12.

Thanks, Kathy



#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>




#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>