Column for Quantity and Rounded Quantity in Entitlement Plan Estimates
Summary:
We have a reporting requirement. We are trying to figure out a backend column for Quantity and Rounded Quantity. We queried in the table OSS_ENT_PLAN_ESTIMATES for the column QUANTITY and ROUNDED_QUANTITY, however, it showed '0'. However, on the UI, the value is different for a given subscription. We need to find the appropriate backend column.
select * from oss_ent_plan_estimates where ENTITLEMENT_PLAN_ID in (select ENTITLEMENT_PLAN_ID from oss_entitlement_plans where ENTITLEMENT_PLAN_ID in (select ENTITLEMENT_PLAN_ID from oss_products where subscription_id in (select subscription_id from oss_subscriptions where subscription_number = '30020073')))