APPS.JTM_VIEW SQL Statements

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

Line: 69

        SELECT user_profile_option_name, description
        FROM fnd_profile_options_tl
        WHERE profile_option_name = p_profile_option_name
        AND language = USERENV('LANG');

Line: 86

        SELECT meaning, description
        FROM fnd_lookup_types_tl
        WHERE lookup_type = p_lookup_type
        AND security_group_id = p_security_group_id
        AND view_application_id = p_view_application_id
        AND language = USERENV('LANG');

Line: 109

        SELECT title, form_context_prompt, description
        FROM fnd_descriptive_flexs_tl
        WHERE application_id = p_application_id
        AND descriptive_flexfield_name = p_descriptive_flexfield_name
        AND language = USERENV('LANG');