APPS.FND_TS_MIG_UTIL dependencies on FND_ORACLE_USERID

Line 155: from fnd_oracle_userid

151: CURSOR usr_def_csr IS
152: SELECT '1'
153: FROM dba_users
154: WHERE username in (select oracle_username
155: from fnd_oracle_userid
156: where read_only_flag in ('E','A','U','K','M'))
157: AND default_tablespace <> (select tablespace
158: from fnd_tablespaces
159: where tablespace_type = l_def_tab_tsp);

Line 165: from fnd_oracle_userid

161: CURSOR prd_inst_csr IS
162: SELECT '1'
163: FROM fnd_product_installations
164: WHERE oracle_id in (select oracle_id
165: from fnd_oracle_userid
166: where read_only_flag in ('E','A','U','K','M'))
167: AND (index_tablespace <> (select tablespace
168: from fnd_tablespaces
169: where tablespace_type = l_def_ind_tsp)

Line 248: fnd_oracle_userid fou

244: BEGIN
245: UPDATE fnd_object_tablespaces fot
246: SET oracle_username = (select fou.oracle_username
247: from fnd_product_installations fpi,
248: fnd_oracle_userid fou
249: where fpi.oracle_id = fou.oracle_id
250: and fpi.application_id = fot.application_id)
251: WHERE oracle_username IS NULL;
252:

Line 307: fnd_oracle_userid fou

303:
304: CURSOR app_csr(l_oracle_username VARCHAR2) IS
305: SELECT fpi.application_id
306: FROM fnd_product_installations fpi,
307: fnd_oracle_userid fou
308: WHERE fpi.oracle_id = fou.oracle_id
309: AND fou.oracle_username = l_oracle_username
310: ORDER BY fpi.application_id;
311: l_app_id FND_PRODUCT_INSTALLATIONS.APPLICATION_ID%TYPE;

Line 395: fnd_oracle_userid fou

391: l_rowid ROWID;
392: CURSOR app_csr(l_oracle_username VARCHAR2) IS
393: SELECT fpi.application_id
394: FROM fnd_product_installations fpi,
395: fnd_oracle_userid fou
396: WHERE fpi.oracle_id = fou.oracle_id
397: AND fou.oracle_username = l_oracle_username
398: ORDER BY fpi.application_id;
399: l_app_id FND_PRODUCT_INSTALLATIONS.APPLICATION_ID%TYPE;

Line 416: from fnd_oracle_userid

412: AND fot.object_name(+) = dt.table_name
413: AND NVL(dt.iot_type, ''X'') NOT IN (''IOT'', ''IOT_OVERFLOW'')
414: AND NVL(dt.temporary, ''N'') = ''N''
415: AND dt.owner IN (select oracle_username
416: from fnd_oracle_userid
417: where read_only_flag IN (''E'',''A'',''U'',''K'',''M''))
418: AND NOT EXISTS ( select ds.table_name
419: from dba_snapshots ds
420: where ds.owner = dt.owner

Line 502: FROM fnd_oracle_userid

498: IS
499: CURSOR usr_csr IS
500: SELECT oracle_id,
501: oracle_username
502: FROM fnd_oracle_userid
503: WHERE read_only_flag in ('E', 'A', 'U', 'K', 'M')
504: ORDER by oracle_username;
505:
506: CURSOR usr_quota_csr(p_username VARCHAR2) IS