Skip to Content
0
Former Member
Apr 13, 2009 at 07:09 PM

Merge queries in one query base on object type

16 Views

I cretaed UDF in marketing document and linked it to following scripts:

in Godd recipt from PO :

SELECT T0.[U_NTX_ Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[PDN1.ItemCode]

In Good issue:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[IGE1.ItemCode]

in Good Transfer:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[WTR1.ItemCode]

In Good recipt:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[IGN1.ItemCode]

In porchase Orde:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[POR1.ItemCode]

I would like to merge this script in one query , how can I do it:??

Edited by: Farhadn on Apr 13, 2009 9:09 PM