Hi,
I would like to have my parameter 'uom' parameter connected to the query. When I choose the parameter 'LM' I would like to see the data on the report in LM if i choose m2 i would like to see data in M2. My statement is: (JUST PART OF IT)
select
T1.BUSINESS ,
T1.ITEM_TYPE ,
T1.ITEM_CATEGORY ,
2.UOM_STOCK ,
ssi_davl_func('PNCLASS',T1.ITEM_CATEGORY,'E') ,
T1.ITEM_CODE ,
DECODE(T1.QTY_DTS,0,0 ,ssi_units_conversion(T1.BUSINESS,T1.ITEM_CODE,T1.QTY_DTS,T2.UOM_STOCK,KG,6)) QTY_DTS ,
DECODE(T1.QTY_REJ,0,0 ,ssi_units_conversion(T1.BUSINESS,T1.ITEM_CODE,T1.QTY_REJ,T2.UOM_STOCK,'KG',6)) QTY_REJ,
I don;t want 'kg' to be hard coded or create single columns for different UOM. Is there any way I can add parameter to this statement. I will aprreaciate any help,
Renata