Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_LAST_DDL_OBJECTS
This query shows all FPS objects in the database sorted by the last_ddl_time. It excludes jobs, synonyms, and database links whose last_ddl_time is either blank or irrevelant. It also excludes our temporary types starting with R_ or T_ used in ADM_TABLE_MATCH_COMMIT. It includes dev only objects and objects in the recycle bin.
|
Column |
Comment |
|---|---|
|
ROWNUM_BY_DDL |
|
|
OWNER |
|
|
OBJECT_NAME |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* inherited from FPSADMIN.CFG_DISABLED) |
|
OBJECT_TYPE |
|
|
LAST_DDL_TIME |
|
|
CREATED |
|
|
STATUS |
|
|
IS_DEV_ONLY |
|
|
ORIGINAL_NAME |
|
|
DROPTIME |