APPS.WIP_DIAG_JOB_SCH_HC dependencies on ALL_TAB_COLUMNS

Line 23: FROM all_tab_columns

19: wdj_dyn_where_clause VARCHAR2(1000) := null;
20: wo_dyn_where_clause VARCHAR2(1000) := null;
21: wdj_atc_where_clause VARCHAR2(1000):= null;
22: CURSOR l_trail_space(l_table_owner varchar2) IS SELECT column_name
23: FROM all_tab_columns
24: WHERE table_name = 'WIP_DISCRETE_JOBS'
25: AND data_type = 'VARCHAR2'
26: AND owner = l_table_owner;
27:

Line 607: ' from wip_discrete_jobs wdj,all_tab_columns atc where '||

603:
604: sqltext:=RTrim(sqltext,',');
605: sqltext:='select '||
606: sqltext||
607: ' from wip_discrete_jobs wdj,all_tab_columns atc where '||
608: wdj_dyn_where_clause||
609: wdj_atc_where_clause||
610: ' and owner= '''||
611: p_table_owner||