Column for Quantity and Rounded Quantity in Entitlement Plan Estimates — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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')))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!