DBA Data[Home] [Help]

APPS.JTF_DSPMGRVALIDATION_GRP dependencies on MTL_SYSTEM_ITEMS

Line 540: select distinct inventory_item_id from mtl_system_items

536: l_api_name CONSTANT VARCHAR2(40) := 'check_item_exists';
537:
538: CURSOR item_cur( p_item_id IN NUMBER ) IS
539: SELECT 1 from dual where exists (
540: select distinct inventory_item_id from mtl_system_items
541: where inventory_item_id = p_item_id);
542:
543: l_exists NUMBER;
544: l_return_status boolean := false;