APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on MTL_SYSTEM_ITEMS

Line 484: ||' mtl_system_items msi, '

480: ||' prvr.scale_type, '
481: ||' ffm.total_output_qty, ' -- Bug: 8736658 Added code to fetch total output of the formula
482: ||' ffm.yield_uom ' -- Bug: 8736658 Added code to fetch yield uom of the formula
483: ||' FROM mtl_parameters mp, '
484: ||' mtl_system_items msi, '
485: ||' bom_calendars bc, '
486: ||' fm_form_eff eff, '
487: ||' fm_form_mst ffm, '
488: ||' (SELECT DISTINCT '

Line 552: -- updates to the mtl_system_items into this procedure

548: log_message ('Calulate Lead Time for Item_no-> '||item_eff.item_no||' org_id '||
549: item_eff.org_id||' routing_id= '||item_eff.routing_id||' recipe_id '||item_eff.recipe_id);
550: calc_lead_time(item_eff.routing_id ) ;
551: -- We may want to move the insert into routing_offsets and
552: -- updates to the mtl_system_items into this procedure
553: END IF ;
554: END LOOP ;
555: CLOSE cur_item_eff ;
556:

Line 1195: UPDATE mtl_system_items

1191: ||' Cum Variable='|| g_cum_v_duration
1192: ||' Lot Size=' || l_lead_time_lot_size
1193: ||' Daily Work Hour=' || item_eff.daily_work_hours );
1194:
1195: UPDATE mtl_system_items
1196: SET
1197: fixed_lead_time = l_temp_f_lead_time,
1198: variable_lead_time = l_temp_v_lead_time ,
1199: lead_time_lot_size = 1,