VIEW: EGO.EGO_MASSUPDATE_ITEM_TMP#

Source

View Text - Preformatted

select USER_ID USER_ID, BATCH_ID BATCH_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, REVISION_ID REVISION_ID, CATEGORY_ID CATEGORY_ID, SELECTED_FLAG SELECTED_FLAG, ORGANIZATION_CODE ORGANIZATION_CODE, REVISION_CODE REVISION_CODE, REVISION_LABEL REVISION_LABEL, CATEGORY_NAME CATEGORY_NAME, ITEM_NUMBER ITEM_NUMBER, DESCRIPTION DESCRIPTION, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, C_ATTR_1 C_ATTR_1, C_ATTR_2 C_ATTR_2, C_ATTR_3 C_ATTR_3, C_ATTR_4 C_ATTR_4, C_ATTR_5 C_ATTR_5, C_ATTR_6 C_ATTR_6, C_ATTR_7 C_ATTR_7, C_ATTR_8 C_ATTR_8, C_ATTR_9 C_ATTR_9, C_ATTR_10 C_ATTR_10, C_ATTR_11 C_ATTR_11, C_ATTR_12 C_ATTR_12, C_ATTR_13 C_ATTR_13, C_ATTR_14 C_ATTR_14, C_ATTR_15 C_ATTR_15, C_ATTR_16 C_ATTR_16, C_ATTR_17 C_ATTR_17, C_ATTR_18 C_ATTR_18, C_ATTR_19 C_ATTR_19, C_ATTR_20 C_ATTR_20, C_ATTR_21 C_ATTR_21, C_ATTR_22 C_ATTR_22, C_ATTR_23 C_ATTR_23, C_ATTR_24 C_ATTR_24, C_ATTR_25 C_ATTR_25, C_ATTR_26 C_ATTR_26, C_ATTR_27 C_ATTR_27, C_ATTR_28 C_ATTR_28, C_ATTR_29 C_ATTR_29, C_ATTR_30 C_ATTR_30, C_ATTR_31 C_ATTR_31, C_ATTR_32 C_ATTR_32, C_ATTR_33 C_ATTR_33, C_ATTR_34 C_ATTR_34, C_ATTR_35 C_ATTR_35, C_ATTR_36 C_ATTR_36, C_ATTR_37 C_ATTR_37, C_ATTR_38 C_ATTR_38, C_ATTR_39 C_ATTR_39, C_ATTR_40 C_ATTR_40, STYLE_ITEM_ID STYLE_ITEM_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE SUPPLIER_SITE, SUPPLIER_SITE_ID SUPPLIER_SITE_ID from "EGO"."EGO_MASSUPDATE_ITEM_TMP"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, BATCH_ID BATCH_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, REVISION_ID REVISION_ID
, CATEGORY_ID CATEGORY_ID
, SELECTED_FLAG SELECTED_FLAG
, ORGANIZATION_CODE ORGANIZATION_CODE
, REVISION_CODE REVISION_CODE
, REVISION_LABEL REVISION_LABEL
, CATEGORY_NAME CATEGORY_NAME
, ITEM_NUMBER ITEM_NUMBER
, DESCRIPTION DESCRIPTION
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, C_ATTR_1 C_ATTR_1
, C_ATTR_2 C_ATTR_2
, C_ATTR_3 C_ATTR_3
, C_ATTR_4 C_ATTR_4
, C_ATTR_5 C_ATTR_5
, C_ATTR_6 C_ATTR_6
, C_ATTR_7 C_ATTR_7
, C_ATTR_8 C_ATTR_8
, C_ATTR_9 C_ATTR_9
, C_ATTR_10 C_ATTR_10
, C_ATTR_11 C_ATTR_11
, C_ATTR_12 C_ATTR_12
, C_ATTR_13 C_ATTR_13
, C_ATTR_14 C_ATTR_14
, C_ATTR_15 C_ATTR_15
, C_ATTR_16 C_ATTR_16
, C_ATTR_17 C_ATTR_17
, C_ATTR_18 C_ATTR_18
, C_ATTR_19 C_ATTR_19
, C_ATTR_20 C_ATTR_20
, C_ATTR_21 C_ATTR_21
, C_ATTR_22 C_ATTR_22
, C_ATTR_23 C_ATTR_23
, C_ATTR_24 C_ATTR_24
, C_ATTR_25 C_ATTR_25
, C_ATTR_26 C_ATTR_26
, C_ATTR_27 C_ATTR_27
, C_ATTR_28 C_ATTR_28
, C_ATTR_29 C_ATTR_29
, C_ATTR_30 C_ATTR_30
, C_ATTR_31 C_ATTR_31
, C_ATTR_32 C_ATTR_32
, C_ATTR_33 C_ATTR_33
, C_ATTR_34 C_ATTR_34
, C_ATTR_35 C_ATTR_35
, C_ATTR_36 C_ATTR_36
, C_ATTR_37 C_ATTR_37
, C_ATTR_38 C_ATTR_38
, C_ATTR_39 C_ATTR_39
, C_ATTR_40 C_ATTR_40
, STYLE_ITEM_ID STYLE_ITEM_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE SUPPLIER_SITE
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
FROM "EGO"."EGO_MASSUPDATE_ITEM_TMP"