EBS Customizations (MOSC)

MOSC Banner

XML Report needs to return multiple values.Currently Formula column returning only one value.

edited Apr 12, 2014 12:00PM in EBS Customizations (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center