APPS.AD_TSPACE_UTIL SQL Statements

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

Line: 24

    SELECT application_id
    INTO   l_appl_id
    FROM   fnd_application
    WHERE  UPPER(application_short_name) = UPPER(x_product_short_name);

Line: 44

    SELECT application_short_name
    INTO   l_product_short_name
    FROM   fnd_application
    WHERE  application_id = x_appl_id;

Line: 77

              SELECT UPPER(nvl(is_new_ts_mode, 'N'))
              INTO l_ts_mode
              FROM FND_PRODUCT_GROUPS
              WHERE PRODUCT_GROUP_ID = 1;

Line: 118

    select upper(TABLESPACE_TYPE), upper(OBJECT_TYPE)
    from FND_OBJECT_TABLESPACES
    where UPPER(OBJECT_NAME)=UPPER(c_object_name)
    AND APPLICATION_ID = c_appl_id;

Line: 125

    select TABLESPACE_NAME
    from DBA_TABLESPACES
    where TABLESPACE_NAME=UPPER(c_tspace);

Line: 283

              SELECT UPPER(TABLESPACE)
              INTO l_tspace
              FROM FND_TABLESPACES
              WHERE UPPER(TABLESPACE_TYPE)=UPPER(l_tspace_type);

Line: 310

                    SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
                    INTO l_tspace
                    FROM FND_PRODUCT_INSTALLATIONS
                    WHERE APPLICATION_ID = 191
                    AND install_group_num in (0, 1);

Line: 340

                    SELECT UPPER(nvl(INDEX_TABLESPACE, 'UNKNOWN'))
                    INTO l_tspace
                    FROM FND_PRODUCT_INSTALLATIONS
                    WHERE APPLICATION_ID = l_appl_id;

Line: 371

                    SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
                    INTO l_tspace
                    FROM FND_PRODUCT_INSTALLATIONS
                    WHERE APPLICATION_ID = l_appl_id;

Line: 445

    select UPPER(TABLESPACE)
    from FND_TABLESPACES
    where UPPER(TABLESPACE_TYPE)=UPPER(c_tspace_type);

Line: 452

    select TABLESPACE_NAME
    from DBA_TABLESPACES
    where TABLESPACE_NAME=UPPER(c_tspace);

Line: 523

                    SELECT UPPER(nvl(INDEX_TABLESPACE, 'UNKNOWN'))
                    INTO l_tspace
                    FROM FND_PRODUCT_INSTALLATIONS
                    WHERE APPLICATION_ID = l_appl_id;

Line: 554

                    SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
                    INTO l_tspace
                    FROM FND_PRODUCT_INSTALLATIONS
                    WHERE APPLICATION_ID = 191
                    AND install_group_num in (0, 1);

Line: 583

                    SELECT UPPER(nvl(TABLESPACE, 'UNKNOWN'))
                    INTO l_tspace
                    FROM FND_PRODUCT_INSTALLATIONS
                    WHERE APPLICATION_ID = l_appl_id;