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
0