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_MASTER#

Source

View Text - Preformatted


select ITEM_ID ITEM_ID, ITEM_TYPE_ID ITEM_TYPE_ID, ORIG_SYS_REF ORIG_SYS_REF, DESC_TEXT DESC_TEXT, REF_PART_NBR REF_PART_NBR, QUOTEABLE_FLAG QUOTEABLE_FLAG, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, LEAD_TIME LEAD_TIME, ITEM_STATUS ITEM_STATUS, 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_ITEMTYPE_1_1 FSK_ITEMTYPE_1_1, FSK_ITEMTYPE_1_EXT FSK_ITEMTYPE_1_EXT, DECIMAL_QTY_FLAG DECIMAL_QTY_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SRC_TYPE_CODE SRC_TYPE_CODE, SRC_APPLICATION_ID SRC_APPLICATION_ID from "CZ"."CZ_IMP_ITEM_MASTER"

View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, ITEM_TYPE_ID ITEM_TYPE_ID
, ORIG_SYS_REF ORIG_SYS_REF
, DESC_TEXT DESC_TEXT
, REF_PART_NBR REF_PART_NBR
, QUOTEABLE_FLAG QUOTEABLE_FLAG
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, LEAD_TIME LEAD_TIME
, ITEM_STATUS ITEM_STATUS
, 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_ITEMTYPE_1_1 FSK_ITEMTYPE_1_1
, FSK_ITEMTYPE_1_EXT FSK_ITEMTYPE_1_EXT
, DECIMAL_QTY_FLAG DECIMAL_QTY_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SRC_TYPE_CODE SRC_TYPE_CODE
, SRC_APPLICATION_ID SRC_APPLICATION_ID
FROM "CZ"."CZ_IMP_ITEM_MASTER"