DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_GROSS_REQUIREMENTS

Line 1662: mrp_gross_requirements reqs,

1658: FROM mrp_form_query list,
1659: bom_calendar_dates dates,
1660: mtl_parameters param,
1661: mrp_recommendations recom,
1662: mrp_gross_requirements reqs,
1663: mrp_system_items items,
1664: mrp_plan_organizations_v mpov /*1402080*/
1665: WHERE (arg_res_level = 1
1666: OR (arg_res_level = 2

Line 1724: mrp_gross_requirements reqs,

1720: daily_demand_rate)) new_quantity,
1721: 0 old_quantity
1722: FROM mrp_form_query list,
1723: mtl_parameters param,
1724: mrp_gross_requirements reqs,
1725: bom_calendar_dates dates
1726: WHERE (arg_res_level = 1
1727: OR (arg_res_level = 2
1728: AND reqs.project_id is NULL)

Line 2633: -- MRP_GROSS_REQUIREMENTS and

2629: 1, 2, 5, 3;
2630:
2631: -- --------------------------------------------
2632: -- This cursor selects the snapshot activity in
2633: -- MRP_GROSS_REQUIREMENTS and
2634: -- MRP_RECOMMENDATIONS for the items in the
2635: -- item list.
2636: -- --------------------------------------------
2637: CURSOR mrp_snapshot_activity IS

Line 2820: mrp_gross_requirements mgr,

2816: daily_demand_rate)) new_quantity,
2817: 0 old_quantity
2818: FROM mrp_form_query list,
2819: mtl_parameters param,
2820: mrp_gross_requirements mgr,
2821: bom_calendar_dates dates
2822: WHERE (arg_res_level = 1
2823: OR (arg_res_level = 2
2824: AND mgr.project_id is NULL)