eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: EAM_WORK_CLEARANCE_STATUSES_VL
Product: EAM - Enterprise Asset Management
Description: View based on EAM_SAFETY_USR_DEF_STATUSES_B for displaying user defined work clearance statuses and their mapping with corresponding work clearance system status
Implementation/DBA Data:
APPS.EAM_WORK_CLEARANCE_STATUSES_VL
View Text
SELECT B.ROWID ROW_ID , B.STATUS_ID , B.SYSTEM_STATUS , DECODE(B.SEEDED_FLAG , 'Y' , (NVL(T.USER_DEFINED_STATUS , ML.MEANING)) , T.USER_DEFINED_STATUS) AS WORK_CLEARANCE_STATUS , ML.MEANING AS SYSTEM_STATUS_DESC , B.SEEDED_FLAG , B.ENABLED_FLAG , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.CREATED_BY , B.CREATION_DATE FROM EAM_SAFETY_USR_DEF_STATUSES_B B , EAM_SAFETY_USR_DEF_STATUSES_TL T , MFG_LOOKUPS ML WHERE B.STATUS_ID = T.STATUS_ID (+) AND B.ENTITY_TYPE=T.ENTITY_TYPE(+) AND B.ENTITY_TYPE = 2 AND T.LANGUAGE (+) = USERENV('LANG') AND ML.ENABLED_FLAG = 'Y' AND ML.LOOKUP_TYPE = 'EAM_WORK_CLEARANCE_STATUS' AND ML.LOOKUP_CODE = B.SYSTEM_STATUS(+)
Columns
Name
ROW_ID
STATUS_ID
SYSTEM_STATUS
WORK_CLEARANCE_STATUS
SYSTEM_STATUS_DESC
SEEDED_FLAG
ENABLED_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE