DBA Data[Home] [Help]

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 893: from mtl_system_items_kfv

889: l_item_id number;
890: begin
891: select inventory_item_id
892: into l_item_id
893: from mtl_system_items_kfv
894: where organization_id = p_org_id
895: and concatenated_segments = p_item_segments;
896: return l_item_id;
897: exception

Line 986: from mtl_system_items_kfv

982: end if;
983: elsif l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is not null then
984: begin
985: select 1 into l_temp
986: from mtl_system_items_kfv
987: where organization_id = l_flm_kanban_demand_intf(l_counter).organization_id
988: and inventory_item_id = l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID;
989: exception
990: when others then