Default where clause S_REPOUTPT_PSTN.RPT_GEN_DATE >= TO_DATE('12/31/1979 18:30:00','MM/DD/YYYY HH24:

Hi,

When user navigates to My BIP view by default one where clause is getting added S_REPOUTPT_PSTN.RPT_GEN_DATE >= TO_DATE('12/31/1979 18:30:00','MM/DD/YYYY HH24:MI:SS'). Which is causing full table scan. Please suggest how we can remove this where clause or else modify this date to some other dates.

Below is the SQL generated when user navigated to this view.

SQL ID     : 6fav1qw8t94br

SQL Text   : SELECT

                   T6.CONFLICT_ID,

                   T6.LAST_UPD,

                   T6.CREATED,

                   T6.LAST_UPD_BY,

                   T6.CREATED_BY,

                   T6.MODIFICATION_NUM,

                   T6.ROW_ID,

                   T6.FILE_AUTO_UPD_FLG,