DBA Data[Home] [Help]

APPS.INV_ITEM_UTIL dependencies on ALL_OBJECTS

Line 362: FROM all_objects

358: schema_name VARCHAR2(30):='APPS';
359: --Schema Names can be 30 char wide Bug:5026190
360: CURSOR c_check_object(cp_object_type VARCHAR2, cp_object_name VARCHAR2)IS
361: SELECT 'Y'
362: FROM all_objects
363: WHERE owner = schema_name
364: AND object_type = cp_object_type
365: AND object_name = cp_object_name
366: AND status = 'VALID';