APPS.MSD_DEM_COLLECT_RETURN_HISTORY SQL Statements

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

Line: 31

               SELECT
                identifier, MSD_SOURCE_DATE_COL, CUSTOM_VIEW_NAME
               FROM
                  msd_dem_series
               WHERE
                      series_id = p_series_id
                  AND series_type = 1;

Line: 41

         select rma_types
         from msd_dem_rma_type;

Line: 46

         select accnt_class_type
         from msd_dem_accnt_classes;

Line: 241

                /* insert return history data into return history staging table */
                EXECUTE IMMEDIATE x_large_sql;

Line: 262

                MSD_DEM_UPDATE_LEVEL_CODES.update_code(x_errbuf ,
                      x_retcode,
                      p_SR_instance_id,
                      'SITE',
                      p_dest_table,
                      'LEVEL4',
                      'LEVEL4_SR_PK');

Line: 280

          /* Delete the RMA types stored in the DB table */
          delete from msd_dem_rma_type;

Line: 284

          /* Delete the WIP Accounting classes stored in the DB table */
          delete from msd_dem_accnt_classes;

Line: 323

            SELECT meaning                            --jarora
            FROM fnd_lookup_values_vl
            WHERE lookup_type = p_lookup_type
              AND lookup_code = p_lookup_code;

Line: 330

         SELECT owner
         FROM dba_objects
         WHERE  owner = owner
            AND object_type = 'TABLE'
            AND object_name = 'MDP_MATRIX'
         ORDER BY created desc;

Line: 428

            x_errbuf  := 'The ''Date From'' and ''Date To'' fields are ignored if ''Rolling'' date range type is selected.';

Line: 440

            x_errbuf  := 'The ''History Collection Window'' field is ignored if ''Absolute'' date range type is selected.';

Line: 452

            errbuf  := 'The ''History Collection Window'' field cannot be NULL, if ''Rolling'' date range type is selected.';

Line: 466

            errbuf  := 'The ''Date From'' and ''Date To'' fields cannot be NULL, if ''Absolute'' date range type is selected.';

Line: 554

         select instr(p_entity_name,':'),length(p_entity_name)  --sopjarora
                INTO l_position,l_length
         FROM DUAL;

Line: 560

           select substr(p_entity_name,1,l_position - 1),substr(p_entity_name,l_position + 1,l_length)
                INTO l_table_name,l_series_name
           FROM DUAL;

Line: 615

         msd_dem_common_utilities.log_debug ('Begin delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));         --jarora

Line: 621

          x_sql := 'DELETE FROM ' || x_dest_table;   --amitku

Line: 623

	  msd_dem_common_utilities.log_debug ('End delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));    --jarora