DBA Data[Home] [Help]

APPS.INV_ITEM_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 361

    SELECT 'Y'
    FROM   all_objects
    WHERE  owner        = schema_name
    AND    object_type  = cp_object_type
    AND    object_name  = cp_object_name
    AND    status       = 'VALID';
Line: 572

  SELECT count(1)  INTO l_exist
  FROM user_objects
  WHERE objecT_name= 'ENI_ITEMS_STAR_PKG'
  AND object_type = 'PACKAGE';