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: EGO.EGO_GTN_MUL_ATTR_CHG_B#

Source

View Text - Preformatted


select EXTENSION_ID EXTENSION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, 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, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, REVISION_ID REVISION_ID, ATTR_GROUP_ID ATTR_GROUP_ID, MANUFACTURER_GLN MANUFACTURER_GLN, MANUFACTURER_ID MANUFACTURER_ID, PARTY_RECEIVING_PRIVATE_DATA PARTY_RECEIVING_PRIVATE_DATA, BAR_CODE_TYPE BAR_CODE_TYPE, COLOR_CODE_LIST_AGENCY COLOR_CODE_LIST_AGENCY, COLOR_CODE_VALUE COLOR_CODE_VALUE, CLASS_OF_DANGEROUS_CODE CLASS_OF_DANGEROUS_CODE, DANGEROUS_GOODS_MARGIN_NUMBER DANGEROUS_GOODS_MARGIN_NUMBER, DANGEROUS_GOODS_HAZARDOUS_CODE DANGEROUS_GOODS_HAZARDOUS_CODE, DANGEROUS_GOODS_PACK_GROUP DANGEROUS_GOODS_PACK_GROUP, DANGEROUS_GOODS_REG_CODE DANGEROUS_GOODS_REG_CODE, DANGEROUS_GOODS_SHIPPING_NAME DANGEROUS_GOODS_SHIPPING_NAME, UNITED_NATIONS_DANG_GOODS_NO UNITED_NATIONS_DANG_GOODS_NO, FLASH_POINT_TEMP FLASH_POINT_TEMP, UOM_FLASH_POINT_TEMP UOM_FLASH_POINT_TEMP, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN, HARMONIZED_TARIFF_SYS_ID_CODE HARMONIZED_TARIFF_SYS_ID_CODE, SIZE_CODE_LIST_AGENCY SIZE_CODE_LIST_AGENCY, SIZE_CODE_VALUE SIZE_CODE_VALUE, MASTER_ORG_EXTENSION_ID MASTER_ORG_EXTENSION_ID, DELIVERY_METHOD_INDICATOR DELIVERY_METHOD_INDICATOR, CHANGE_ID CHANGE_ID, CHANGE_LINE_ID CHANGE_LINE_ID, ACD_TYPE ACD_TYPE, IMPLEMENTATION_DATE IMPLEMENTATION_DATE from "EGO"."EGO_GTN_MUL_ATTR_CHG_B"

View Text - HTML Formatted

SELECT EXTENSION_ID EXTENSION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, 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
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, REVISION_ID REVISION_ID
, ATTR_GROUP_ID ATTR_GROUP_ID
, MANUFACTURER_GLN MANUFACTURER_GLN
, MANUFACTURER_ID MANUFACTURER_ID
, PARTY_RECEIVING_PRIVATE_DATA PARTY_RECEIVING_PRIVATE_DATA
, BAR_CODE_TYPE BAR_CODE_TYPE
, COLOR_CODE_LIST_AGENCY COLOR_CODE_LIST_AGENCY
, COLOR_CODE_VALUE COLOR_CODE_VALUE
, CLASS_OF_DANGEROUS_CODE CLASS_OF_DANGEROUS_CODE
, DANGEROUS_GOODS_MARGIN_NUMBER DANGEROUS_GOODS_MARGIN_NUMBER
, DANGEROUS_GOODS_HAZARDOUS_CODE DANGEROUS_GOODS_HAZARDOUS_CODE
, DANGEROUS_GOODS_PACK_GROUP DANGEROUS_GOODS_PACK_GROUP
, DANGEROUS_GOODS_REG_CODE DANGEROUS_GOODS_REG_CODE
, DANGEROUS_GOODS_SHIPPING_NAME DANGEROUS_GOODS_SHIPPING_NAME
, UNITED_NATIONS_DANG_GOODS_NO UNITED_NATIONS_DANG_GOODS_NO
, FLASH_POINT_TEMP FLASH_POINT_TEMP
, UOM_FLASH_POINT_TEMP UOM_FLASH_POINT_TEMP
, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, HARMONIZED_TARIFF_SYS_ID_CODE HARMONIZED_TARIFF_SYS_ID_CODE
, SIZE_CODE_LIST_AGENCY SIZE_CODE_LIST_AGENCY
, SIZE_CODE_VALUE SIZE_CODE_VALUE
, MASTER_ORG_EXTENSION_ID MASTER_ORG_EXTENSION_ID
, DELIVERY_METHOD_INDICATOR DELIVERY_METHOD_INDICATOR
, CHANGE_ID CHANGE_ID
, CHANGE_LINE_ID CHANGE_LINE_ID
, ACD_TYPE ACD_TYPE
, IMPLEMENTATION_DATE IMPLEMENTATION_DATE
FROM "EGO"."EGO_GTN_MUL_ATTR_CHG_B"