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

Do we have any equivalent view in Fusion for mrp_orders_sc_v

Hi,

I've a requirement to provide the Demand quantity. Please provide me the equivalent view for mrp_orders_sc_v.

SELECT inventory_item_id, abs(sum(quantity_rate)) dmd
FROM apps.mrp_orders_sc_v
WHERE 1=1
AND plan_organization_id = 123
AND source_table = 'MRP_GROSS_REQUIREMENTS'
GROUP BY INVENTORY_ITEM_ID

Thanks in advance

Dinesh

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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