DBA Data[Home] [Help]

APPS.ICX_MARGIN_WEB_ANA_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 447: temp_item_num MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

443: end icx_get_total_margin;
444: --
445: function GET_ITEM_NUMBER (in_ITEM_ID in number)
446: return VARCHAR2 as
447: temp_item_num MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
448: begin
449: select distinct concatenated_segments
450: into temp_item_num
451: from mtl_system_items_kfv

Line 451: from mtl_system_items_kfv

447: temp_item_num MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
448: begin
449: select distinct concatenated_segments
450: into temp_item_num
451: from mtl_system_items_kfv
452: where inventory_item_id = in_item_id;
453: return (temp_item_num);
454: exception
455: when too_many_rows then