DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_RELIEF_INTERFACE

Line 5830: INSERT INTO mrp_relief_interface

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

Line 5891: mrp_relief_interface_s.nextval,

5887: 2,
5888: 'WIP',
5889: null,
5890: null,
5891: mrp_relief_interface_s.nextval,
5892: project_id,
5893: project_id,
5894: task_id,
5895: task_id

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

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