DBA Data[Home] [Help]

APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on MTL_SYSTEM_ITEMS

Line 447: ||' mtl_system_items msi, '

443: ||' eff.recipe_id, '
444: ||' eff.formula_id, '
445: ||' eff.routing_id '
446: ||' FROM mtl_parameters mp, '
447: ||' mtl_system_items msi, '
448: ||' bom_calendars bc, '
449: ||' fm_form_eff eff, '
450: ||' (SELECT DISTINCT '
451: ||' NVL(eff.organization_id,mp.organization_id) organization_id, '

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

491: g_non_rtg_itm_cnt := g_non_rtg_itm_cnt + 1 ;
492: ELSE -- item_eff.routing_id is NOT NULL
493: calc_lead_time(item_eff.routing_id) ;
494: -- We may want to move the insert into routing_offsets and
495: -- updates to the mtl_system_items into this procedure
496: END IF ;
497: END LOOP ;
498: CLOSE cur_item_eff ;
499:

Line 1001: UPDATE mtl_system_items

997: ||' Cum Fixed=' || g_cum_f_duration
998: ||' Variable='|| l_temp_v_lead_time
999: ||' Cum Variable='|| g_cum_v_duration );
1000:
1001: UPDATE mtl_system_items
1002: SET
1003: fixed_lead_time = l_temp_f_lead_time,
1004: variable_lead_time = l_temp_v_lead_time ,
1005: lead_time_lot_size = 1,