APPS.MSD_DEM_PUSH_SETUP_PARAMETERS SQL Statements

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

Line: 96

         x_sql := 'SELECT multi_org_flag FROM fnd_product_groups' || g_dblink ||
                  ' WHERE product_group_type = ''Standard''';

Line: 160

It is recommended to set the profile to selectively collect these level values.
To collect all the available geography dimension level values, please clear
out the dummy profile value. Until the profile value is set appropriately or
cleared out, only the dummy level value (other) will be collected into
Demand Management for geography dimension.';

Line: 178

         x_sql := 'SELECT count(*) FROM msd_dem_setup_parameters' || g_dblink;

Line: 376

	    msd_dem_common_utilities.log_message ('If this is not the master org, please update the MSD_DEM_MASTER_ORG profile on the Source');

Line: 397

            x_sql := 'DELETE FROM msd_dem_setup_parameters' || g_dblink;

Line: 401

            msd_dem_common_utilities.log_message ('Inserting profiles into source msd_dem_setup_parameters');

Line: 402

            x_sql := 'INSERT INTO msd_dem_setup_parameters' || g_dblink ||
                     ' (parameter_name, parameter_value, last_update_date, last_updated_by, creation_date, ' ||
                     '  created_by, last_update_login) values (:1, :2, sysdate, :3, sysdate, ' ||
                     '  :4, :5)';

Line: 462

         x_sql := 'DELETE FROM msd_dem_app_instance_orgs' || g_dblink;

Line: 466

         msd_dem_common_utilities.log_message ('Inserting Organizations into source msd_dem_app_instance_orgs');

Line: 467

         x_sql := 'INSERT INTO msd_dem_app_instance_orgs' || g_dblink ||
                  ' ( organization_id, organization_code, last_update_date, last_updated_by, creation_date, ' ||
                  '   created_by, last_update_login) ' ||
                  ' SELECT mtp.sr_tp_id, mtp.organization_code, sysdate, :a1, sysdate, ' ||
                  '  :a2, :a3 ' ||
                  ' FROM msc_instance_orgs mio, ' ||
                  '      msc_trading_partners mtp ' ||
                  ' WHERE mio.sr_instance_id = :1 ' ||
                  '   AND nvl(mio.org_group, ''-888'') = decode( :2, ''-999'', nvl(mio.org_group, ''-888''), :3) ' ||
                  '   AND nvl(mio.dp_enabled_flag, mio.enabled_flag) = 1 ' ||
                  '   AND mtp.sr_instance_id = mio.sr_instance_id ' ||
                  '   AND mtp.sr_tp_id = mio.organization_id ' ||
                  '   AND mtp.partner_type = 3';

Line: 511

            SELECT meaning
            FROM fnd_lookup_values_vl
            WHERE lookup_type = 'MSD_DEM_TABLES'
              AND lookup_code = p_lookup_code;

Line: 545

         x_sql := 'DELETE FROM msd_dem_dates' || g_dblink;

Line: 558

         x_sql := 'SELECT time_bucket, first_day_of_week, aggregation_method ' ||
                  ' FROM ' || x_dm_table ||
                  ' WHERE dm_or_template = 2 ' ||
                  '   AND is_active = 1 ';

Line: 567

            msd_dem_common_utilities.log_message ('Lowest Time Bucket - Day : Time data not inserted into source msd_dem_dates');

Line: 601

         msd_dem_common_utilities.log_message ('Inserting time data into source msd_dem_dates');

Line: 602

         x_sql := 'INSERT INTO msd_dem_dates' || g_dblink ||
                  ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
                  ' SELECT datet, num_of_days, ' || x_start_date || x_end_date ||
                  ' sysdate, :1, sysdate, :2, :3 ' ||
                  ' FROM ' || x_source_time_table;

Line: 650

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