DBA Data[Home] [Help]

APPS.MRP_EXCEPTIONS_SC_PK dependencies on MRP_RECOMMENDATIONS

Line 88: FROM mrp_recommendations r,

84: +------------------------------------*/
85: UPDATE mrp_form_query q
86: SET number3 = /* number of orders */
87: (SELECT COUNT(r.organization_id)
88: FROM mrp_recommendations r,
89: mrp_item_exceptions e,
90: mrp_plan_organizations_v orgs
91: WHERE ((q.number1 = 6 /* reschedule in */
92: AND r.new_schedule_date < r.old_schedule_date)

Line 179: FROM mrp_recommendations r,

175:
176: UPDATE mrp_form_query q
177: SET number3 = /* number of orders */
178: (select COUNT(r.organization_id)
179: FROM mrp_recommendations r,
180: mrp_item_exceptions e,
181: mrp_system_items s
182: where ((q.number1 = 6 /* reschedule in */
183: and r.new_schedule_date < r.old_schedule_date)