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

Source

View Text - Preformatted


select ITEM_SOURCE_ID ITEM_SOURCE_ID, TYPE TYPE, URL URL, IMAGE_URL IMAGE_URL, 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, DISPLAY_ALWAYS DISPLAY_ALWAYS, PASSWORD PASSWORD, PROTOCOL_SUPPORTED PROTOCOL_SUPPORTED, PARTY_SITE_ID PARTY_SITE_ID, OPERATOR_ID OPERATOR_ID, LOCK_ITEM_FLAG LOCK_ITEM_FLAG, USER_DATA_LIST_ID USER_DATA_LIST_ID, USER_NAME USER_NAME, IS_HUB IS_HUB, SEQUENCE_NUMBER SEQUENCE_NUMBER, PUBLISHED_FLAG PUBLISHED_FLAG, ICX_SESSION_SERVLET_FLAG ICX_SESSION_SERVLET_FLAG, COMPANY_NAME COMPANY_NAME, COMPANY_NUMBER COMPANY_NUMBER, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_NUMBER SUPPLIER_NUMBER, AUTHENTICATED_KEY AUTHENTICATED_KEY, USER_INFO_FLAG USER_INFO_FLAG, SUPPLIER_ID_LIST SUPPLIER_ID_LIST, INCLUDE_INTERNAL_SOURCE_FLAG INCLUDE_INTERNAL_SOURCE_FLAG, ENCODING ENCODING, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, KEY_1 KEY_1, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, OPERATION_ALLOWED OPERATION_ALLOWED, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG from "ICX"."ICX_POR_ITEM_SOURCES"

View Text - HTML Formatted

SELECT ITEM_SOURCE_ID ITEM_SOURCE_ID
, TYPE TYPE
, URL URL
, IMAGE_URL IMAGE_URL
, 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
, DISPLAY_ALWAYS DISPLAY_ALWAYS
, PASSWORD PASSWORD
, PROTOCOL_SUPPORTED PROTOCOL_SUPPORTED
, PARTY_SITE_ID PARTY_SITE_ID
, OPERATOR_ID OPERATOR_ID
, LOCK_ITEM_FLAG LOCK_ITEM_FLAG
, USER_DATA_LIST_ID USER_DATA_LIST_ID
, USER_NAME USER_NAME
, IS_HUB IS_HUB
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, PUBLISHED_FLAG PUBLISHED_FLAG
, ICX_SESSION_SERVLET_FLAG ICX_SESSION_SERVLET_FLAG
, COMPANY_NAME COMPANY_NAME
, COMPANY_NUMBER COMPANY_NUMBER
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_NUMBER SUPPLIER_NUMBER
, AUTHENTICATED_KEY AUTHENTICATED_KEY
, USER_INFO_FLAG USER_INFO_FLAG
, SUPPLIER_ID_LIST SUPPLIER_ID_LIST
, INCLUDE_INTERNAL_SOURCE_FLAG INCLUDE_INTERNAL_SOURCE_FLAG
, ENCODING ENCODING
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KEY_1 KEY_1
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, OPERATION_ALLOWED OPERATION_ALLOWED
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
FROM "ICX"."ICX_POR_ITEM_SOURCES"