Data Dictionary report by file?

I'm trying to generate a report of data dictionary info (e.g. field, field name, field attributes, item glossary) for all fields in a table (e.g. F4311).

I'm running E1 Apps 9.0.2 with Tools 9.1.5.5.

I've looked at the R92400 Data Dictionary Items Report, but don't see how to choose data selection that will pick all the fields in a table, and return only one row per field.

I've also tried writing a SQL query, but am having trouble identifying how to select all the fields in a table (without typing them all in manually).

select frdtai ALIAS, trim(frowdi) DATA_ITEM, trim(drdl01) DATA_TYPE, frdtas FIELD_SIZE,