APPS.BENUTILS dependencies on DBA_TAB_COLUMNS

Line 2785: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start

2781: l_application_short_name varchar2(30);
2782: l_oracle_schema varchar2(30);
2783: l_return boolean;
2784: --
2785: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
2786: /* cursor c1(l_oracle_schema in varchar2) is
2787: select t.column_name
2788: from all_tab_columns t,
2789: all_cons_columns c,

Line 2806: dba_tab_columns col,

2802: cursor c1(l_oracle_schema in varchar2) is
2803: select col.column_name
2804: from --all_tab_columns t,
2805: user_synonyms syn,
2806: dba_tab_columns col,
2807: all_cons_columns c,
2808: all_constraints a
2809: where a.constraint_type = 'P'
2810: and a.table_name =p_tablename

Line 2879: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start

2875: l_application_short_name varchar2(30);
2876: l_oracle_schema varchar2(30);
2877: l_return boolean;
2878: --
2879: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
2880: cursor c1(l_oracle_schema in varchar2) is
2881: /* select null
2882: from all_tab_columns t
2883: where t.table_name = p_tablename

Line 2892: user_synonyms syn,dba_tab_columns col

2888: or substr(t.column_name,length(t.column_name)-4,5) = '_FLAG')
2889: and t.owner = upper(l_oracle_schema);*/
2890: select null
2891: from --all_tab_columns t
2892: user_synonyms syn,dba_tab_columns col
2893: where-- t.table_name = p_tablename
2894: syn.synonym_name = p_tablename
2895: and col.owner = syn.table_owner
2896: and col.table_name = syn.table_name

Line 2949: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start

2945: l_application_short_name varchar2(30);
2946: l_oracle_schema varchar2(30);
2947: l_return boolean;
2948: --
2949: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
2950: cursor c1(l_oracle_schema in varchar2) is
2951: /* select c.column_name
2952: from all_tab_columns t,
2953: all_cons_columns c,

Line 2967: dba_tab_columns col,

2963: order by c.position;*/
2964: select c.column_name
2965: from --all_tab_columns t,
2966: user_synonyms syn,
2967: dba_tab_columns col,
2968: all_cons_columns c,
2969: all_constraints a
2970: where a.constraint_type = 'P'
2971: and a.table_name =p_tablename

Line 3020: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start

3016: l_application_short_name varchar2(30);
3017: l_oracle_schema varchar2(30);
3018: l_return boolean;
3019: --
3020: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
3021: cursor c1(l_oracle_schema in varchar2) is
3022: /* select null
3023: from all_tab_columns a
3024: where a.column_name = 'BUSINESS_GROUP_ID'

Line 3028: from user_synonyms syn,dba_tab_columns col

3024: where a.column_name = 'BUSINESS_GROUP_ID'
3025: and a.table_name = p_tablename
3026: and a.owner = upper(l_oracle_schema);*/
3027: select null
3028: from user_synonyms syn,dba_tab_columns col
3029: where syn.synonym_name = p_tablename
3030: and col.owner = syn.table_owner
3031: and col.table_name = syn.table_name
3032: and col.column_name = 'BUSINESS_GROUP_ID'

Line 3100: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start

3096: l_application_short_name varchar2(30);
3097: l_oracle_schema varchar2(30);
3098: l_return boolean;
3099: --
3100: --Bug 15876152 CHANGING ALL_TAB_COLUMNS REFERENCE TO DBA_TAB_COLUMNS start
3101: cursor c1(l_oracle_schema in varchar2) is
3102: /* select null
3103: from all_tab_columns utc
3104: where utc.table_name = p_tablename

Line 3109: user_synonyms syn,dba_tab_columns col

3105: and utc.column_name like '%ATTRIBUTE%'
3106: and utc.owner = upper(l_oracle_schema);*/
3107: select null
3108: from -- all_tab_columns utc
3109: user_synonyms syn,dba_tab_columns col
3110: where syn.synonym_name = p_tablename
3111: and col.owner = syn.table_owner
3112: and col.table_name = syn.table_name
3113: and col.column_name like '%ATTRIBUTE%'