data-dictionary

FPSAPP.SYSMNTR_P_CHK_DWH_CURR_LOCKS

Data Dictionary

>

FPSAPP Views

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSAPP.SYSMNTR_P_CHK_DWH_CURR_LOCKS

View to check curr locks based on this link: http://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_locks001.htm#SQLRF55502

Column

Comment

SID

USERNAME

Field that uniquely identifies a user. (* inherited from FPSINPUT.GEN_USERS)

OSUSER

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

LOCKED_MODE

LOCKED_MODE_MSG

ALERT