DBA Data[Home] [Help]

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on MTL_ITEM_LOCATIONS_KFV

Line 909: from mtl_item_locations_kfv

905: l_locator_id number;
906: begin
907: select inventory_location_id
908: into l_locator_id
909: from mtl_item_locations_kfv
910: where organization_id = p_org_id
911: and concatenated_segments = p_locator_segments;
912: return l_locator_id;
913: exception

Line 1034: FROM mtl_item_locations_kfv

1030: end if;
1031: elsif l_flm_kanban_demand_intf(l_counter).locator_id is not null then
1032: begin
1033: select 1 into l_temp
1034: FROM mtl_item_locations_kfv
1035: WHERE inventory_location_id = l_flm_kanban_demand_intf(l_counter).locator_id
1036: AND organization_id = l_flm_kanban_demand_intf(l_counter).organization_id;
1037: exception
1038: when others then