APPS.QA_DBLINK_PKG SQL Statements

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

Line: 40

                  'as select event_time, event_data, event_tag_id device_source, ' ||
                  'device_name, 192 quality_code from edg_event_vw@';

Line: 51

                              'select systimestamp event_time, ' ||
                              'null event_data, ' ||
                              'null device_source, ' ||
                              'null device_name from dual';

Line: 91

            EXECUTE IMMEDIATE 'select 1 from edg_event_vw@' || p_dblink_name || ' where rownum = 1' INTO l_chk;

Line: 126

                   ' SELECT TO_TIMESTAMP_TZ(event_time) event_time, ' ||
                   ' event_data, ' ||
                   ' device_source, ' ||
                   ' device_name, ' ||
                   ' quality_code ' ||
                   'FROM qa_device_data_values';

Line: 138

                              'select systimestamp event_time, ' ||
                              'null event_data, ' ||
                              'null device_source, ' ||
                              'null device_name from dual';

Line: 208

       	-- If third party OPC server is selected, revert the view to its original state.
       	create_opc_view;