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: CZ.CZ_IMP_ITEM_PROPERTY_VALUE#

Source

View Text - Preformatted


select PROPERTY_ID PROPERTY_ID, ITEM_ID ITEM_ID, PROPERTY_VALUE PROPERTY_VALUE, REC_NBR REC_NBR, RUN_ID RUN_ID, REC_STATUS REC_STATUS, DISPOSITION DISPOSITION, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, EFF_MASK EFF_MASK, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, CHECKOUT_USER CHECKOUT_USER, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, FSK_PROPERTY_1_1 FSK_PROPERTY_1_1, FSK_PROPERTY_1_EXT FSK_PROPERTY_1_EXT, FSK_ITEMMASTER_2_1 FSK_ITEMMASTER_2_1, FSK_ITEMMASTER_2_EXT FSK_ITEMMASTER_2_EXT, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROPERTY_NUM_VALUE PROPERTY_NUM_VALUE, ORIG_SYS_REF ORIG_SYS_REF, SRC_APPLICATION_ID SRC_APPLICATION_ID, FSK_LOCALIZEDTEXT_3_1 FSK_LOCALIZEDTEXT_3_1, FSK_LOCALIZEDTEXT_3_EXT FSK_LOCALIZEDTEXT_3_EXT from "CZ"."CZ_IMP_ITEM_PROPERTY_VALUE"

View Text - HTML Formatted

SELECT PROPERTY_ID PROPERTY_ID
, ITEM_ID ITEM_ID
, PROPERTY_VALUE PROPERTY_VALUE
, REC_NBR REC_NBR
, RUN_ID RUN_ID
, REC_STATUS REC_STATUS
, DISPOSITION DISPOSITION
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, EFF_MASK EFF_MASK
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, CHECKOUT_USER CHECKOUT_USER
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, FSK_PROPERTY_1_1 FSK_PROPERTY_1_1
, FSK_PROPERTY_1_EXT FSK_PROPERTY_1_EXT
, FSK_ITEMMASTER_2_1 FSK_ITEMMASTER_2_1
, FSK_ITEMMASTER_2_EXT FSK_ITEMMASTER_2_EXT
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROPERTY_NUM_VALUE PROPERTY_NUM_VALUE
, ORIG_SYS_REF ORIG_SYS_REF
, SRC_APPLICATION_ID SRC_APPLICATION_ID
, FSK_LOCALIZEDTEXT_3_1 FSK_LOCALIZEDTEXT_3_1
, FSK_LOCALIZEDTEXT_3_EXT FSK_LOCALIZEDTEXT_3_EXT
FROM "CZ"."CZ_IMP_ITEM_PROPERTY_VALUE"