APPS.FND_GEN_MIG_CMDS dependencies on DBA_QUEUE_TABLES

Line 1228: FROM dba_queue_tables dqt,

1224: dt.tablespace_name tablespace_name,
1225: dt.iot_type iot_type,
1226: dt.partitioned partitioned,
1227: dt.logging logging
1228: FROM dba_queue_tables dqt,
1229: dba_tables dt,
1230: fnd_tablespaces ft
1231: WHERE dqt.owner = p_owner
1232: AND dqt.owner = dt.owner

Line 1924: from dba_queue_tables dqt

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
1925: where dqt.owner = p_owner
1926: and dqt.queue_table = dt.table_name)
1927: AND NOT EXISTS ( select det.table_name
1928: from dba_external_tables det

Line 1975: from dba_queue_tables dqt

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
1976: where dqt.owner = p_owner
1977: and dqt.queue_table = dt.table_name)
1978: AND NOT EXISTS ( select det.table_name
1979: from dba_external_tables det

Line 2012: from dba_queue_tables dqt

2008: AND NVL(dt.temporary, 'N') = 'N'
2009: AND NVL(dt.iot_type, 'X') = 'IOT'
2010: AND dt.cluster_name IS NULL
2011: AND NOT EXISTS ( select dqt.queue_table
2012: from dba_queue_tables dqt
2013: where dqt.owner = p_owner
2014: and dqt.queue_table = dt.table_name)
2015: AND NOT EXISTS ( select det.table_name
2016: from dba_external_tables det