Unable to view the data in APPS form

Hi All,

I have created a APPS form based on a view which contains secure views of Oracle APPS.

Following is the scenario.

1.  Custom table XX_ADV_PAY_TAB having 139 records for ORG_ID = 1060.

2.  Created a view XX_ADV_PAY_V which contains the APPS secure view also ( ar_payment_schedule, ra_cust_trx_types which work with Org context set to the session ).

3.  Set the org context for ORG_ID = 1060 and query, we can see all the 139 records in TOAD or SQLPLUS.

Issue:

When I query the data from the form for the ORG_ID = 1060 only 14 rows are appearing.  When I see the last_query only ORG_ID = 1060 condition is displayed.  Didn;t understand why all the records are not getting displayed.