SELECT d.base_user_name dbi_name
,d.data_type dbi_data_type
,(SELECT listagg ('<' || rcu.sequence_no || ',' || c.base_context_name || '>', ',')
within GROUP (ORDER BY rcu.sequence_no)
FROM ff_route_context_usages rcu
,ff_contexts_b c
WHERE rcu.route_id = r.route_id
AND rcu.context_id = c.context_id
) route_context_usages
FROM ff_database_items_b d
,ff_user_entities_b u
,ff_routes_b r
WHERE UPPER(d.base_user_name) LIKE 'ANC%'
AND d.user_entity_id = u.user_entity_id
AND r.route_id = u.route_id
No comments:
Post a Comment