APPS.MSD_PUSH_SETUP_DATA SQL Statements

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

Line: 64

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 Planning for
geography dimension.';

Line: 81

	x_sql_stmt := 'SELECT COUNT(*) FROM '||x_source_table||' where instance_id = '||p_instance_id;

Line: 85

        x_sql_stmt := 'SELECT COUNT(*) FROM '||x_source_table;

Line: 314

    v_sql_stmt :=  'Select multi_org_flag from fnd_product_groups' || G_DBLINK ||
                   ' where product_group_type = ''Standard''';

Line: 400

                 msd_conc_log_util.display_message('If this is not the master org, please update the MSD_MASTER_ORG profile on the source',
                                                    msd_conc_log_util.C_WARNING);

Line: 413

           l_sql := 'delete from msd_setup_parameters' || g_dblink;

Line: 416

           msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);

Line: 418

           /* Insert profiles in source msd_setup_parameters */
           l_sql := 'insert into msd_setup_parameters' || g_dblink ||
              ' (instance_id, parameter_name, parameter_value) values (:1, :2, :3)';

Line: 455

    l_sql := 'Delete from MSD_APP_INSTANCE_ORGS' || g_dblink;

Line: 464

    l_sql := 'insert into MSD_APP_INSTANCE_ORGS' || g_dblink ||
             '( instance_id, organization_id, last_update_date, last_updated_by, creation_date, ' ||
             '  created_by, last_update_login, request_id, program_application_id, program_id,  ' ||
             '  program_update_date, attribute_category, attribute1, attribute2, attribute3,    ' ||
             '  attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, '         ||
             '  attribute10, attribute11, attribute12, attribute13, attribute14, attribute15) '   ||
             'select sr_instance_id, organization_id, last_update_date, last_updated_by, '        ||
             '  creation_date, created_by, last_update_login, request_id, program_application_id,' ||
             '  program_id, program_update_date, attribute_category, attribute1, attribute2, '    ||
             '  attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,' ||
             '  attribute10, attribute11, attribute12, attribute13, attribute14, attribute15' ||
             ' from msc_instance_orgs where sr_instance_id = :id and nvl(dp_enabled_flag, enabled_flag) = ''1''';

Line: 545

      v_sql_stmt := 'SELECT parameter_name, parameter_value FROM MSD_SETUP_PARAMETERS'||g_dblink ||
                    ' where instance_id = ' || p_instance_id;

Line: 605

         v_sql_stmt  := ' SELECT count(*) from ( ' ||
                        '        ( SELECT organization_id FROM msc_instance_orgs ' ||
                        '                 WHERE sr_instance_id = ' || p_instance_id ||
                        '                       and nvl(dp_enabled_flag, enabled_flag) = ''1''' ||
                        '          MINUS ' ||
                        '          SELECT organization_id FROM msd_app_instance_orgs' || g_dblink ||
                        '                 WHERE instance_id = ' || p_instance_id || ') ' ||
                        '          UNION ALL ' ||
                        '        ( SELECT organization_id FROM msd_app_instance_orgs' || g_dblink ||
                        '                 WHERE instance_id = ' || p_instance_id ||
                        '          MINUS ' ||
                        '          SELECT organization_id FROM msc_instance_orgs ' ||
                        '                 WHERE sr_instance_id = ' || p_instance_id ||
                        '                       and nvl(dp_enabled_flag, enabled_flag) = ''1'') ' ||
                        ' )';