run query based on a view
Dear All,
if i run this query : select count(*) from CE_260_RECONCILED_V
because it is a view : the result is zero
but usually to select data from a view we have to run this before
begin
fnd_global.apps_initialize(user_id =>user_id,
resp_id => resp_id,
resp_appl_id => app_id);
mo_global.init(p_appl_short_name => 'CE');
xla_security_pkg.set_security_context(p_application_id => app-id);
end;
but now even when i run this code the result is still zero..