APPS.FLM_AUTO_REPLENISHMENT dependencies on MTL_SYSTEM_ITEMS

Line 44: FROM mtl_system_items_kfv

40: BEGIN
41:
42: SELECT concatenated_segments
43: INTO l_comp_name
44: FROM mtl_system_items_kfv
45: WHERE inventory_item_id = p_comp_id
46: AND organization_id = p_organization_id;
47:
48: IF (p_error_position = G_Error_Create_Cards) THEN

Line 174: mtl_system_items msi

170: SELECT mkps.pull_sequence_id
171: INTO l_pull_sequence_id
172: FROM mtl_kanban_pull_sequences mkps,
173: bom_inventory_components bic,
174: mtl_system_items msi
175: WHERE mkps.inventory_item_id = p_item_id
176: AND mkps.organization_id = p_organization_id
177: AND mkps.auto_request = 'Y'
178: AND mkps.release_kanban_flag = 1

Line 255: FROM mtl_system_items sys,

251: 1, sys.wip_supply_type),
252: comp.wip_supply_type)) wip_supply_type,
253: MIN(comp.component_quantity) component_quantity,
254: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
255: FROM mtl_system_items sys,
256: bom_inventory_components comp,
257: bom_explosions expl,
258: bom_bill_of_materials bbm
259: WHERE bbm.organization_id = sys.organization_id

Line 593: FROM mtl_system_items

589: l_stop_time);
590:
591: SELECT nvl(fixed_lead_time, 0) + (p_quantity - 1) * nvl(variable_lead_time, 0)
592: INTO l_lead_time
593: FROM mtl_system_items
594: WHERE inventory_item_id = p_assembly_item_id
595: AND organization_id = p_organization_id;
596:
597: -- Operation Start time