APPS.WIP_DIAG_JOB_SCH_HC dependencies on ALL_TAB_COLUMNS

Line 24: FROM user_synonyms syn, all_tab_columns col

20: wo_dyn_where_clause VARCHAR2(1000) := null;
21: wdj_atc_where_clause VARCHAR2(1000):= null;
22: --Bug#15877953: Fetching the columns using user_synonyms
23: CURSOR l_trail_space(l_table_owner varchar2) IS SELECT col.column_name
24: FROM user_synonyms syn, all_tab_columns col
25: WHERE syn.synonym_name = 'WIP_DISCRETE_JOBS'
26: AND syn.table_owner=l_table_owner
27: AND col.owner=syn.table_owner
28: AND col.table_name = syn.table_name

Line 611: ' from wip_discrete_jobs wdj,all_tab_columns atc,user_synonyms syn where '|| --Bug#15877953:Added user_synonyms

607:
608: sqltext:=RTrim(sqltext,',');
609: sqltext:='select '||
610: sqltext||
611: ' from wip_discrete_jobs wdj,all_tab_columns atc,user_synonyms syn where '|| --Bug#15877953:Added user_synonyms
612: wdj_dyn_where_clause||
613: wdj_atc_where_clause;
614:
615: