EBS R12- Querying OLAP table using command LIMIT MSENTRY TO MSCAT

There is an issue with LIMIT command('LIMIT MSENTRY TO MSCAT(MSPROP ''SOURCE'') EQ ''PS''') in the olap_table. When this query was used in fetching a parameter value in EBS R12 ( 11.2.0.2) concurrent program it is always defaulting to 1.

When the command was changed to (LIMIT MSENTRY to MSENTRY), the parameter value in concurrent program is working fine

query pasted for reference..

CREATE OR REPLACE FORCE VIEW apps.xxmsd_input_parameters_view (demand_plan_id

                                                             , msentry

                                                             , input_parameter

                                                              )

AS   SELECT b.demand_plan_name demand_plan_id

        , a.msentry msentry

        , a.description input_parameter

     FROM msd.msd_demand_plans b