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: CSI.CSI_ITEM_INSTANCE_LOCKS#

Source

View Text - Preformatted


select LOCK_ID LOCK_ID, LOCK_STATUS LOCK_STATUS, INSTANCE_ID INSTANCE_ID, CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID, CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID, CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM, ROOT_INSTANCE_ID ROOT_INSTANCE_ID, ROOT_CONFIG_INST_HDR_ID ROOT_CONFIG_INST_HDR_ID, ROOT_CONFIG_INST_ITEM_ID ROOT_CONFIG_INST_ITEM_ID, ROOT_CONFIG_INST_REV_NUM ROOT_CONFIG_INST_REV_NUM, LOCK_SOURCE_APPLN_ID LOCK_SOURCE_APPLN_ID, LOCK_SOURCE_HEADER_REF LOCK_SOURCE_HEADER_REF, LOCK_SOURCE_LINE_REF1 LOCK_SOURCE_LINE_REF1, LOCK_SOURCE_LINE_REF2 LOCK_SOURCE_LINE_REF2, LOCK_SOURCE_LINE_REF3 LOCK_SOURCE_LINE_REF3, DATE_LOCKED DATE_LOCKED, UNLOCK_SOURCE_APPLN_ID UNLOCK_SOURCE_APPLN_ID, UNLOCK_SOURCE_HEADER_REF UNLOCK_SOURCE_HEADER_REF, UNLOCK_SOURCE_LINE_REF1 UNLOCK_SOURCE_LINE_REF1, UNLOCK_SOURCE_LINE_REF2 UNLOCK_SOURCE_LINE_REF2, UNLOCK_SOURCE_LINE_REF3 UNLOCK_SOURCE_LINE_REF3, DATE_UNLOCKED DATE_UNLOCKED, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "CSI"."CSI_ITEM_INSTANCE_LOCKS"

View Text - HTML Formatted

SELECT LOCK_ID LOCK_ID
, LOCK_STATUS LOCK_STATUS
, INSTANCE_ID INSTANCE_ID
, CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID
, CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID
, CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM
, ROOT_INSTANCE_ID ROOT_INSTANCE_ID
, ROOT_CONFIG_INST_HDR_ID ROOT_CONFIG_INST_HDR_ID
, ROOT_CONFIG_INST_ITEM_ID ROOT_CONFIG_INST_ITEM_ID
, ROOT_CONFIG_INST_REV_NUM ROOT_CONFIG_INST_REV_NUM
, LOCK_SOURCE_APPLN_ID LOCK_SOURCE_APPLN_ID
, LOCK_SOURCE_HEADER_REF LOCK_SOURCE_HEADER_REF
, LOCK_SOURCE_LINE_REF1 LOCK_SOURCE_LINE_REF1
, LOCK_SOURCE_LINE_REF2 LOCK_SOURCE_LINE_REF2
, LOCK_SOURCE_LINE_REF3 LOCK_SOURCE_LINE_REF3
, DATE_LOCKED DATE_LOCKED
, UNLOCK_SOURCE_APPLN_ID UNLOCK_SOURCE_APPLN_ID
, UNLOCK_SOURCE_HEADER_REF UNLOCK_SOURCE_HEADER_REF
, UNLOCK_SOURCE_LINE_REF1 UNLOCK_SOURCE_LINE_REF1
, UNLOCK_SOURCE_LINE_REF2 UNLOCK_SOURCE_LINE_REF2
, UNLOCK_SOURCE_LINE_REF3 UNLOCK_SOURCE_LINE_REF3
, DATE_UNLOCKED DATE_UNLOCKED
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "CSI"."CSI_ITEM_INSTANCE_LOCKS"