DBA Data[Home] [Help]

APPS.MSC_SECRULE_PKG dependencies on MSC_ITEMS

Line 640: from msc_items cm

636:
637: if (p_item_name is not null ) and ( l_supplier_item_flag=false ) and ( l_customer_item_flag=false ) then
638: BEGIN
639: select cm.inventory_item_id into l_item_id
640: from msc_items cm
641: where
642: item_name=p_item_name;
643:
644: -- --dbms_output.put_line('item name exists' ||l_item_id);