APPS.EAM_ASSET_SEARCH_PVT SQL Statements

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

Line: 77

      SELECT    DISTINCT meast.descriptive_flex_context_code AS DESCR_CONTEXT_CODE
      FROM      MTL_EAM_ASSET_SEARCH_TEMP meast
      WHERE     meast.SEARCH_SET_ID = p_search_set_id;

Line: 82

      SELECT    meast.end_user_column_name      END_USER_COLUMN_NAME,
                meast.operator                  OPERATOR,
                meast.line_type                 LINE_TYPE,
                meast.attribute_varchar2_value  ATTRIBUTE_VARCHAR2_VALUE,
                meast.attribute_number_value    ATTRIBUTE_NUMBER_VALUE,
                meast.attribute_date_value      ATTRIBUTE_DATE_VALUE
      FROM      MTL_EAM_ASSET_SEARCH_TEMP       meast
      WHERE     meast.SEARCH_SET_ID                   = p_search_set_id
      AND       meast.DESCRIPTIVE_FLEX_CONTEXT_CODE   = l_context_code
      AND       meast.line_type                       = l_line_type;

Line: 159

        l_sql_stmt := l_sql_stmt || ' AND EXISTS (SELECT * '
                                 || ' '
                                 || 'FROM MTL_EAM_ASSET_ATTR_VALUES MAEAV WHERE ';

Line: 225

         DELETE    MTL_EAM_ASSET_SEARCH_TEMP
         WHERE     SEARCH_SET_ID      = p_search_set_id;

Line: 336

        SELECT  application_column_name
        INTO    l_application_column_name
        FROM    FND_DESCR_FLEX_COLUMN_USAGES fdfcu
        WHERE   fdfcu.APPLICATION_ID                = p_application_id
        AND     fdfcu.DESCRIPTIVE_FLEXFIELD_NAME    = p_descr_flexfield_name
        AND     fdfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_descr_flex_context_code
        AND     fdfcu.end_user_column_name          = p_end_user_column_name;