How do I fetch the covered Levels of a subscription using query?

You can fetch the covered level name of a subscription by querying ASSET_NUMBER in the OSS_PRODUCT_ASSOCIATION table.

For more details, see Unable To Find Covered Level Name In Subscription Management (Doc ID 2973976.1) on My Oracle Support.