APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on MTL_SYSTEM_ITEMS

Line 50: from mtl_system_items

46: and organization_id = p_org_id;
47:
48: select nvl(fixed_lead_time,0) + (p_qty - 1)*nvl(variable_lead_time,0)
49: into l_lead_time
50: from mtl_system_items
51: where organization_id = p_org_id
52: and inventory_item_id = p_item_id;
53:
54: return ( MRP_LINE_SCHEDULE_ALGORITHM.calculate_begin_time(

Line 250: from mtl_system_items sys,

246: 1, sys.wip_supply_type),
247: comp.wip_supply_type)) wip_supply_type,
248: MIN(comp.component_quantity) component_quantity,
249: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
250: from mtl_system_items sys,
251: bom_inventory_components comp,
252: bom_explosions expl,
253: bom_bill_of_materials bbm
254: where sys.planning_make_buy_code = 1

Line 459: from mtl_system_items_kfv

455: exception
456: WHEN no_data_found THEN
457: select concatenated_segments
458: into var_comp_name
459: from mtl_system_items_kfv
460: where inventory_item_id = var_comp_id
461: and organization_id = arg_org_id;
462:
463: fnd_message.set_name('FLM','FLM_SYNCH_INVALID_SEQ');