SELECT dbi.user_name
,base_context_name
FROM ff_database_items_vl dbi
,ff_user_entities_vl userent
,ff_routes_vl routes
,ff_route_context_usages rcu
,ff_contexts_vl con
WHERE dbi.user_entity_id = userent.user_entity_id
AND userent.route_id = routes.route_id
AND routes.route_id = rcu.route_id
AND con.context_id = rcu.context_id
AND dbi.base_user_name = :p_dbi_name
No comments:
Post a Comment