DBA Data[Home] [Help]

APPS.BIS_VG_UTIL SQL Statements

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

Line: 204

  l_SQL_text := 'SELECT NULL ' || l_String || ' FROM DUAL';
Line: 1500

                   SELECT installed_flag
                   FROM fnd_languages_vl
                   WHERE UPPER(language_code) = UPPER(p_language);
Line: 1505

                          SELECT comments
                          FROM all_col_comments
                          WHERE table_name = UPPER(p_view_name)
                            AND owner = UPPER(p_view_owner)
                            AND column_name = UPPER(p_column_name);
Line: 1516

                             SELECT form_above_prompt
                             FROM fnd_id_flex_segments_tl
                             WHERE application_id = p_app_id
                               AND id_flex_code = p_flex_code
                               AND id_flex_num = p_struc_num
                               AND application_column_name = p_app_column
                               AND language = UPPER(p_language);
Line: 1527

                                    SELECT form_context_prompt
                                    FROM fnd_descriptive_flexs_tl
                                    WHERE application_id = p_app_id
                                      AND descriptive_flexfield_name = p_desc_flex_name
                                      AND language = UPPER(p_language);
Line: 1538

                                  SELECT form_above_prompt
                                  FROM fnd_descr_flex_col_usage_tl
                                  WHERE application_id = p_app_id
                                    AND descriptive_flexfield_name = p_desc_flex_name
                                    AND descriptive_flex_context_code = p_context_code
                                    AND application_column_name = p_app_column
                                    AND language = UPPER(p_language);