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: ICX.ICX_ITEM_DETLS_INFO#

Source

View Text - Preformatted


select CREATED_BY CREATED_BY, CREATED_DATE CREATED_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TEMPLATE_BUSINESS TEMPLATE_BUSINESS, TEMPLATE_CONSUMER TEMPLATE_CONSUMER, MARKETING_TEXT_FILE MARKETING_TEXT_FILE, MARKETING_TEXT MARKETING_TEXT, SPECIAL_FLAG_BUSINESS SPECIAL_FLAG_BUSINESS, SPECIAL_TEXT_BUSINESS SPECIAL_TEXT_BUSINESS, SPECIAL_IMAGE_BUSINESS SPECIAL_IMAGE_BUSINESS, SPECIAL_THUMBNAIL_BUSINESS SPECIAL_THUMBNAIL_BUSINESS, SPECIAL_START_DATE_BUSINESS SPECIAL_START_DATE_BUSINESS, SPECIAL_END_DATE_BUSINESS SPECIAL_END_DATE_BUSINESS, SPECIAL_FLAG_CONSUMER SPECIAL_FLAG_CONSUMER, SPECIAL_START_DATE_CONSUMER SPECIAL_START_DATE_CONSUMER, SPECIAL_END_DATE_CONSUMER SPECIAL_END_DATE_CONSUMER, SPECIAL_THUMBNAIL_CONSUMER SPECIAL_THUMBNAIL_CONSUMER, SPECIAL_TEXT_CONSUMER SPECIAL_TEXT_CONSUMER, SPECIAL_IMAGE_CONSUMER SPECIAL_IMAGE_CONSUMER, IMAGE_FILE_1 IMAGE_FILE_1, IMAGE_FILE_2 IMAGE_FILE_2, IMAGE_FILE_3 IMAGE_FILE_3, IMAGE_FILE_4 IMAGE_FILE_4, IMAGE_FILE_5 IMAGE_FILE_5, IMAGE_FILE_6 IMAGE_FILE_6, IMAGE_FILE_7 IMAGE_FILE_7, IMAGE_FILE_8 IMAGE_FILE_8, IMAGE_FILE_9 IMAGE_FILE_9, IMAGE_FILE_10 IMAGE_FILE_10, IMAGE_FILE_11 IMAGE_FILE_11, IMAGE_FILE_12 IMAGE_FILE_12, IMAGE_FILE_13 IMAGE_FILE_13, IMAGE_FILE_14 IMAGE_FILE_14, IMAGE_FILE_15 IMAGE_FILE_15 from "ICX"."ICX_ITEM_DETLS_INFO"

View Text - HTML Formatted

SELECT CREATED_BY CREATED_BY
, CREATED_DATE CREATED_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TEMPLATE_BUSINESS TEMPLATE_BUSINESS
, TEMPLATE_CONSUMER TEMPLATE_CONSUMER
, MARKETING_TEXT_FILE MARKETING_TEXT_FILE
, MARKETING_TEXT MARKETING_TEXT
, SPECIAL_FLAG_BUSINESS SPECIAL_FLAG_BUSINESS
, SPECIAL_TEXT_BUSINESS SPECIAL_TEXT_BUSINESS
, SPECIAL_IMAGE_BUSINESS SPECIAL_IMAGE_BUSINESS
, SPECIAL_THUMBNAIL_BUSINESS SPECIAL_THUMBNAIL_BUSINESS
, SPECIAL_START_DATE_BUSINESS SPECIAL_START_DATE_BUSINESS
, SPECIAL_END_DATE_BUSINESS SPECIAL_END_DATE_BUSINESS
, SPECIAL_FLAG_CONSUMER SPECIAL_FLAG_CONSUMER
, SPECIAL_START_DATE_CONSUMER SPECIAL_START_DATE_CONSUMER
, SPECIAL_END_DATE_CONSUMER SPECIAL_END_DATE_CONSUMER
, SPECIAL_THUMBNAIL_CONSUMER SPECIAL_THUMBNAIL_CONSUMER
, SPECIAL_TEXT_CONSUMER SPECIAL_TEXT_CONSUMER
, SPECIAL_IMAGE_CONSUMER SPECIAL_IMAGE_CONSUMER
, IMAGE_FILE_1 IMAGE_FILE_1
, IMAGE_FILE_2 IMAGE_FILE_2
, IMAGE_FILE_3 IMAGE_FILE_3
, IMAGE_FILE_4 IMAGE_FILE_4
, IMAGE_FILE_5 IMAGE_FILE_5
, IMAGE_FILE_6 IMAGE_FILE_6
, IMAGE_FILE_7 IMAGE_FILE_7
, IMAGE_FILE_8 IMAGE_FILE_8
, IMAGE_FILE_9 IMAGE_FILE_9
, IMAGE_FILE_10 IMAGE_FILE_10
, IMAGE_FILE_11 IMAGE_FILE_11
, IMAGE_FILE_12 IMAGE_FILE_12
, IMAGE_FILE_13 IMAGE_FILE_13
, IMAGE_FILE_14 IMAGE_FILE_14
, IMAGE_FILE_15 IMAGE_FILE_15
FROM "ICX"."ICX_ITEM_DETLS_INFO"