If you want to create custom views of data using your own SQL View, you first need to register your view with Oracle Applications. You can do so using the following SQL script:
We recommend creating a view on the table (even if it's just a select * from <table>) then you can use the following routine we've created:
BEGIN
xxas_fnd_dictionary_pkg.add_view
(p_application_short_name => xxas_util_pkg.app
,p_view_name => '<view name>'
,p_description => '<view description>');
END;
/