DBA Data[Home] [Help]

APPS.FND_TS_MIG_UTIL dependencies on DBA_SNAPSHOTS

Line 280: from dba_snapshots ds

276: AND fot.object_name(+) = dt.table_name
277: -- AND NVL(dt.iot_type, 'X') NOT IN ('IOT', 'IOT_OVERFLOW')
278: AND NVL(dt.temporary, 'N') = 'N'
279: AND NOT EXISTS ( select ds.table_name
280: from dba_snapshots ds
281: where ds.owner = dt.owner
282: and ds.table_name = dt.table_name)
283: AND NOT EXISTS ( select dsl.log_table
284: from dba_snapshot_logs dsl

Line 419: from dba_snapshots ds

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
421: and ds.table_name = dt.table_name)
422: AND NOT EXISTS ( select dsl.log_table
423: from dba_snapshot_logs dsl