SYSTEM.AD_APPS_PRIVATE dependencies on DBA_SYNONYMS

Line 450: FROM dba_synonyms

446: IF (l_object_type = 'SYNONYM') THEN
447: BEGIN
448: SELECT table_owner
449: INTO l_owner_schema_name
450: FROM dba_synonyms
451: WHERE owner = p_grantor_schema_name
452: AND synonym_name = p_object_name;
453: EXCEPTION
454: WHEN OTHERS THEN

Line 1813: From Dba_Synonyms Syn

1809: Where Owner=Tab.Owner
1810: And Queue_Table=Tab.Table_Name
1811: And Queue_table not like '%$%')
1812: And Not Exists (Select 'x'
1813: From Dba_Synonyms Syn
1814: Where Syn.Owner=upper(apps_schema)
1815: And Syn.Table_Name=Nvl(Ev.View_Name,Tab.Table_Name)
1816: And Syn.Table_Owner=Tab.Owner)
1817: union all

Line 1825: from dba_synonyms ds

1821: where sequence_owner= upper(base_schema)
1822: and sequence_name not like '%$%'
1823: Minus
1824: select ds.synonym_name Target_name, ds.synonym_name object_name, 'SEQUENCE' object_type
1825: from dba_synonyms ds
1826: where ds.owner = upper(apps_schema)
1827: and ds.table_owner = upper(base_schema)
1828: and ds.synonym_name = ds.table_name
1829: and ds.table_name not like '%$%';

Line 1920: From Dba_Synonyms Ds

1916: cust_row_index) then
1917: -- not an active exception object. Calculate the replace_existing_syn flag.
1918: Select decode (Computed_Value.Val,1,'TRUE','FALSE') into replace_existing_syn_tmp
1919: From (Select Count(1) as val
1920: From Dba_Synonyms Ds
1921: where Ds.Table_Owner = upper(base_schema)
1922: And Ds.Table_Name = rtrim(Syn_Rec.object_Name)) Computed_Value;
1923:
1924: if (replace_existing_syn_tmp = 'TRUE') then

Line 1934: From dba_synonyms ds

1930: -- finding the synonym name for each object_name
1931:
1932: IF replace_existing_syn= TRUE THEN
1933: Select ds.synonym_name into syn_name
1934: From dba_synonyms ds
1935: Where ds.table_owner= upper(base_schema)
1936: And ds.table_name = rtrim(Syn_Rec.object_Name);
1937: ELSE
1938: Select rtrim(Syn_Rec.object_Name) into syn_name

Line 2155: from dba_synonyms ds

2151: grant_from_schema in varchar2 default null)
2152: is
2153: cursor c1 is
2154: select ds.synonym_name
2155: from dba_synonyms ds
2156: where ds.owner = upper(from_schema)
2157: and ds.synonym_name = ds.table_name -- regular synonyms only
2158: and ds.synonym_name not like '%$%';
2159: exact_syn_match boolean;

Line 2247: from dba_synonyms ds

2243: toschema in varchar2)
2244: is
2245: cursor c1 is
2246: select ds.synonym_name
2247: from dba_synonyms ds
2248: where ds.owner = upper(fromschema)
2249: and ds.synonym_name <> ds.table_name; -- odd synonyms only
2250: exact_syn_match boolean;
2251: any_obj_w_this_name boolean;

Line 2866: from dba_synonyms

2862: c_synonym_name in varchar2,
2863: c_table_owner in varchar2,
2864: c_table_name in varchar2) is
2865: select 'X'
2866: from dba_synonyms
2867: where owner = c_owner
2868: and synonym_name = c_synonym_name
2869: and table_owner = c_table_owner
2870: and table_name = c_table_name