DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_RELIEF_INTERFACE

Line 5833: INSERT INTO mrp_relief_interface

5829: | a new flow schedule quantity is created. In order not to double |
5830: | count the relief, we need to relieve the old quantity. |
5831: +-------------------------------------------------------------------*/
5832:
5833: INSERT INTO mrp_relief_interface
5834: (inventory_item_id, -- NN
5835: organization_id, -- NN
5836: last_update_date, -- NN sysdate
5837: last_updated_by, -- NN :new.last_updated_by

Line 5894: mrp_relief_interface_s.nextval,

5890: 2,
5891: 'WIP',
5892: null,
5893: null,
5894: mrp_relief_interface_s.nextval,
5895: project_id,
5896: project_id,
5897: task_id,
5898: task_id

Line 6178: to be queried to insert into mrp_relief_interface */

6174: +-----------------------------------------------------*/
6175:
6176: /* this part of code is moved from the buttom of the procedure to here,
6177: because after the schedules got rolled, there would be no flow schedules
6178: to be queried to insert into mrp_relief_interface */
6179: IF p_output = 2 THEN
6180: l_cursor := Create_Relieve_Cursor(l_from_start_date,l_from_end_date); --fix bug#317105
6181:
6182: IF l_cursor IS NULL THEN