Database Items (FF_DATABASE_ITEMS) query
SELECT
fdi.user_name db_item_name,
(
SELECT
frp.parameter_name
|| ' : '
|| frpv.value
FROM
ff_route_parameter_values frpv,
ff_route_parameters frp
WHERE
frpv.user_entity_id = fue.user_entity_id
AND frp.route_parameter_id = frpv.route_parameter_id
AND frp.sequence_no = 1
) parameter_value_1,
(
SELECT
frp.parameter_name
|| ' : '
|| frpv.value
FROM
ff_route_parameter_values frpv,
ff_route_parameters frp
WHERE
frpv.user_entity_id = fue.user_entity_id
AND frp.route_parameter_id = frpv.route_parameter_id
AND frp.sequence_no = 2
) parameter_value_2,
fdi.definition_text select_clause,
fr.text from_where_clause
FROM
ff_database_items fdi,
ff_user_entities fue,
ff_routes fr
where fdi.user_name = <DB_ITEM_NAME>
AND fue.user_entity_id = fdi.user_entity_id
AND fr.route_id = fue.route_id;
For more such queries, please drop a comment in the comment section. Thanks !!