DBA Data[Home] [Help]

APPS.OKE_DTS_ACTION_PKG dependencies on MRP_SCHEDULE_DATES

Line 237: FROM mrp_schedule_dates

233: And D.Create_Demand = 'Y'
234: --bug 8320909 start
235: And Not Exists
236: (SELECT Schedule_quantity
237: FROM mrp_schedule_dates
238: WHERE Mps_Transaction_ID =D. Mps_Transaction_Id
239: AND Schedule_Level = 2
240: AND Supply_Demand_Type = 1
241: AND Schedule_quantity=0);

Line 291: FROM mrp_schedule_dates

287: And D.Create_Demand = 'Y'
288: --bug 8320909 start
289: And Not Exists
290: (SELECT Schedule_quantity
291: FROM mrp_schedule_dates
292: WHERE Mps_Transaction_ID =D. Mps_Transaction_Id
293: AND Schedule_Level = 2
294: AND Supply_Demand_Type = 1
295: AND Schedule_quantity=0);