DBA Data[Home] [Help]

APPS.FND_GEN_MIG_CMDS dependencies on DBA_SNAPSHOT_LOGS

Line 1388: FROM dba_snapshot_logs dsl,

1384: dt.tablespace_name,
1385: dt.iot_type,
1386: dt.partitioned,
1387: dt.logging
1388: FROM dba_snapshot_logs dsl,
1389: dba_tables dt,
1390: fnd_tablespaces ft
1391: WHERE dsl.log_owner = p_owner
1392: AND dsl.master = p_table_name

Line 1920: from dba_snapshot_logs dsl

1916: from dba_snapshots ds
1917: where ds.owner = p_owner
1918: and ds.table_name = dt.table_name)
1919: AND NOT EXISTS ( select dsl.log_table
1920: from dba_snapshot_logs dsl
1921: where dsl.log_owner = p_owner
1922: and dsl.log_table = dt.table_name)
1923: AND NOT EXISTS ( select dqt.queue_table
1924: from dba_queue_tables dqt

Line 1971: from dba_snapshot_logs dsl

1967: from dba_snapshots ds
1968: where ds.owner = p_owner
1969: and ds.table_name = dt.table_name)
1970: AND NOT EXISTS ( select dsl.log_table
1971: from dba_snapshot_logs dsl
1972: where dsl.log_owner = p_owner
1973: and dsl.log_table = dt.table_name)
1974: AND NOT EXISTS ( select dqt.queue_table
1975: from dba_queue_tables dqt