XML Report needs to return multiple values.Currently Formula column returning only one value.
XML Report needs to return multiple values.Currently Formula column returning only one value.
Hello Friends,
I have this function in Reports.But this function returns only one value.However i want all the contents of this sql stament to show in the report.can you please help me.
function CF_ITEM_LOCATORSFormula return Char is
cursor c_item_loc is
select LOC.segment1||'.'||
LOC.segment2||'.'||
LOC.segment3||'.'||
LOC.segment4||'.'||
LOC.segment5||'.'||
LOC.segment6
from
mtl_onhand_quantities_detail QTY, mtl_item_locations LOC
where QTY.inventory_item_id = 19831
and QTY.organization_id = 91
and QTY