FPSADMIN.ADM_FK_VALUE_LISTS

>

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSADMIN.ADM_FK_VALUE_LISTS

This view is used in BLD_STARTUP_WORKSHEET and can be created automatically with this query: select 'select ''' || r_constraint_name || ''' as r_constraint_name, ''' || table_name || ''' as table_name, ''' || column_name || ''' as column_name, ' || 'listagg(' || column_name || ', '', '') within group (order by ' || column_name || ') as value_list ' || 'from fpsadmin.' || table_name || case when column_name = 'ETP_STATE' then ' where etp_state like ''PRD%''' end || line_end as q from ( select distinct r_constraint_name, cc.table_name, cc.column_name, case when cc.table_name = max(cc.table_name) over () then ';' else ' union all ' end as line_end from dbf_constraints c join dbf_cons_columns cc on r_owner = cc.owner and r_constraint_name = cc.constraint_name where constraint_type = 'R' and r_owner = 'FPSADMIN' and c.owner = 'FPSINPUT' and r_constraint_name not in ('CFG_SCHED_PK', 'GEN_COLORS_PK', 'GEN_SITE_INC_BATCH') ) order by table_name, column_name