DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on MRP_GROSS_REQUIREMENTS

Line 1389: FROM mrp_gross_requirements req

1385: /** Bug 2756660 **/
1386: CURSOR INV_VALUES_C3 IS
1387: SELECT NVL(SUM(NVL(req.using_requirements_quantity,0)),0) *
1388: mrp_item_cost(req.inventory_item_id, req.organization_id)
1389: FROM mrp_gross_requirements req
1390: WHERE TRUNC(req.using_assembly_demand_date) between p_start_date and p_end_date
1391: AND req.compile_designator = p_designator
1392: AND req.organization_id = p_org_id
1393: AND req.inventory_item_id = p_item_id