APPS.AD_ZD_TABLE dependencies on DBA_TRIGGERS

Line 608: from dba_triggers

604:
605: -- triggers defined on a table
606: CURSOR c_trg is
607: select owner, trigger_name, trigger_type, status
608: from dba_triggers
609: where table_owner in
610: ( select oracle_username from system.fnd_oracle_userid
611: where read_only_flag in ('A','B', 'E', 'U', 'C') )
612: -- EXCLUDE: trigger generated by the Oracle Text Indexing

Line 1336: from dba_triggers trg

1332: and syn.table_owner = ev.owner
1333: and syn.table_name = ev.table_name ) or
1334: exists /* unmoved triggers */
1335: ( select trg.trigger_name
1336: from dba_triggers trg
1337: where trg.owner in
1338: ( select oracle_username from system.fnd_oracle_userid
1339: where read_only_flag in ('A', 'B', 'C', 'E', 'U') )
1340: and trg.trigger_name not like '%$%' /* system trigger */

Line 1466: dba_triggers trg

1462: trg.owner owner
1463: , trg.trigger_name trigger_name
1464: , trg.status status
1465: from
1466: dba_triggers trg
1467: where trg.owner <> user
1468: and trg.table_owner = x_table_owner
1469: and trg.table_name = x_table_name
1470: order by 1, 2;

Line 1588: , dba_triggers rtrg

1584: , tord.referenced_trigger_name ref_trg_name
1585: , rtrg.status trg_status
1586: from
1587: dba_trigger_ordering tord
1588: , dba_triggers rtrg
1589: where tord.trigger_owner = x_owner
1590: and tord.trigger_name = x_name
1591: and tord.ordering_type = 'FOLLOWS'
1592: and rtrg.owner(+) = tord.referenced_trigger_owner

Line 1618: from dba_triggers trg

1614: -- Get CET info
1615: begin
1616: select trg.status, trg.crossedition, trg.table_owner, trg.table_name
1617: into l_status, l_crossedition, l_table_owner, l_table_name
1618: from dba_triggers trg
1619: where trg.crossedition in ('FORWARD', 'REVERSE')
1620: and trg.owner = c_cet_owner
1621: and trg.trigger_name = x_cet_name;
1622: exception

Line 2304: from dba_triggers trg

2300:
2301: -- Crossedition Triggers
2302: cursor C_CETS(X_TABLE_OWNER varchar2, X_TABLE_NAME varchar2) is
2303: select trg.owner, trg.trigger_name
2304: from dba_triggers trg
2305: where trg.crossedition in ('FORWARD', 'REVERSE')
2306: and trg.table_owner = nvl(x_table_owner, trg.table_owner)
2307: and trg.table_name = nvl(x_table_name, trg.table_name)
2308: order by trg.owner, trg.trigger_name;