APPS.OKE_PA_MDS_RELIEF_PKG dependencies on MRP_SCHEDULE_CONSUMPTIONS

Line 124: Select count(*) from mrp_schedule_consumptions

120: And Schedule_Quantity > 0
121: For Update Of schedule_quantity;
122:
123: Cursor c Is
124: Select count(*) from mrp_schedule_consumptions
125: Where disposition_id = l_disposition_id;
126:
127: Begin
128:

Line 175: INSERT INTO mrp_schedule_consumptions

171: and schedule_level = 2;
172:
173: write_log( 'MDS entry updated' );
174:
175: INSERT INTO mrp_schedule_consumptions
176: (transaction_id,
177: relief_type,
178: disposition_type,
179: disposition_id,