VIEW: EGO.EGO_ITM_USR_ATTR_INTRFC#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, PROCESS_STATUS PROCESS_STATUS, DATA_SET_ID DATA_SET_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ITEM_NUMBER#1 ITEM_NUMBER, REVISION REVISION, ROW_IDENTIFIER ROW_IDENTIFIER, ATTR_GROUP_INT_NAME ATTR_GROUP_INT_NAME, ATTR_INT_NAME ATTR_INT_NAME, ATTR_VALUE_STR ATTR_VALUE_STR, ATTR_VALUE_NUM ATTR_VALUE_NUM, ATTR_VALUE_DATE ATTR_VALUE_DATE, ATTR_DISP_VALUE ATTR_DISP_VALUE, TRANSACTION_TYPE TRANSACTION_TYPE, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, REVISION_ID REVISION_ID, ATTR_GROUP_ID ATTR_GROUP_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTR_GROUP_TYPE ATTR_GROUP_TYPE, CHANGE_ID CHANGE_ID, CHANGE_LINE_ID CHANGE_LINE_ID, SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE, ATTR_UOM_DISP_VALUE ATTR_UOM_DISP_VALUE, ATTR_VALUE_UOM ATTR_VALUE_UOM, INTERFACE_TABLE_UNIQUE_ID INTERFACE_TABLE_UNIQUE_ID, PROG_INT_CHAR1 PROG_INT_CHAR1, PROG_INT_CHAR2 PROG_INT_CHAR2, PROG_INT_NUM1 PROG_INT_NUM1, PROG_INT_NUM2 PROG_INT_NUM2, PROG_INT_NUM3 PROG_INT_NUM3, PROG_INT_NUM4 PROG_INT_NUM4, DATA_LEVEL_ID DATA_LEVEL_ID, DATA_LEVEL_NAME DATA_LEVEL_NAME, PK1_VALUE PK1_VALUE, PK2_VALUE PK2_VALUE, PK3_VALUE PK3_VALUE, PK4_VALUE PK4_VALUE, PK5_VALUE PK5_VALUE, USER_DATA_LEVEL_NAME USER_DATA_LEVEL_NAME, BUNDLE_ID BUNDLE_ID from "EGO"."EGO_ITM_USR_ATTR_INTRFC"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, PROCESS_STATUS PROCESS_STATUS
, DATA_SET_ID DATA_SET_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ITEM_NUMBER#1 ITEM_NUMBER
, REVISION REVISION
, ROW_IDENTIFIER ROW_IDENTIFIER
, ATTR_GROUP_INT_NAME ATTR_GROUP_INT_NAME
, ATTR_INT_NAME ATTR_INT_NAME
, ATTR_VALUE_STR ATTR_VALUE_STR
, ATTR_VALUE_NUM ATTR_VALUE_NUM
, ATTR_VALUE_DATE ATTR_VALUE_DATE
, ATTR_DISP_VALUE ATTR_DISP_VALUE
, TRANSACTION_TYPE TRANSACTION_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, REVISION_ID REVISION_ID
, ATTR_GROUP_ID ATTR_GROUP_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, CHANGE_ID CHANGE_ID
, CHANGE_LINE_ID CHANGE_LINE_ID
, SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID
, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
, ATTR_UOM_DISP_VALUE ATTR_UOM_DISP_VALUE
, ATTR_VALUE_UOM ATTR_VALUE_UOM
, INTERFACE_TABLE_UNIQUE_ID INTERFACE_TABLE_UNIQUE_ID
, PROG_INT_CHAR1 PROG_INT_CHAR1
, PROG_INT_CHAR2 PROG_INT_CHAR2
, PROG_INT_NUM1 PROG_INT_NUM1
, PROG_INT_NUM2 PROG_INT_NUM2
, PROG_INT_NUM3 PROG_INT_NUM3
, PROG_INT_NUM4 PROG_INT_NUM4
, DATA_LEVEL_ID DATA_LEVEL_ID
, DATA_LEVEL_NAME DATA_LEVEL_NAME
, PK1_VALUE PK1_VALUE
, PK2_VALUE PK2_VALUE
, PK3_VALUE PK3_VALUE
, PK4_VALUE PK4_VALUE
, PK5_VALUE PK5_VALUE
, USER_DATA_LEVEL_NAME USER_DATA_LEVEL_NAME
, BUNDLE_ID BUNDLE_ID
FROM "EGO"."EGO_ITM_USR_ATTR_INTRFC"