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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ICX.ICX_POR_ITEM_SOURCES

Object Details

Object Name:	ICX_POR_ITEM_SOURCES
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_POR_ITEM_SOURCES
Subobject Name:
Status:	VALID

This table is obsolete since R12.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_ITEM_SOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_SOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_SOURCE_ID	NUMBER		Yes	The Item Source/Catalog Unique Identifier.
TYPE	VARCHAR2	(8)		The Type of the Catalog. Valid values for the Catalog Types are LOCAL, DISTSRCH, EXTERNAL, INFO
URL	VARCHAR2	(2000)		The URL of the External Catalog. Attribute applicable for all the types of Catalog other than the Local Catalog.
IMAGE_URL	VARCHAR2	(2000)		The url of the thumbnail image (Logo) for the external Supplier Site or Informational Catalog.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column: date when this record was last updated
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column: the user who last updated this record. (References FND_USERS.user_id.)
CREATION_DATE	DATE		Yes	Standard Who column: date when this record was created
CREATED_BY	NUMBER		Yes	Standard Who column: the user who created this record. (References FND_USERS.user_id.)
LAST_UPDATE_LOGIN	NUMBER			Standard Who column: identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id.)
DISPLAY_ALWAYS	VARCHAR2	(1)		Flag indicating if the Catalog's display, in the Shopping Pages, within the Store.
PASSWORD	VARCHAR2	(100)		The password credential for the External Punchout Catalogs (Exchange and Supplier). The password is stored in the encrypted format.
PROTOCOL_SUPPORTED	VARCHAR2	(20)		The Access Method for the Catalog. The access method is based on the Catalog Type. Valid values for this attribute are LOCAL, LOCAL_BASE, EXCHANGE, DISTSRCH_EXCH, INFORMATIONAL, VIA_EXCH, XML_SUPP, CXML_SUPP, DISTSRCH_SUPP.
PARTY_SITE_ID	NUMBER			Not used
OPERATOR_ID	NUMBER			Identifier for the Exchange Operator. Valid only in case of the Exchange Punchout Catalog.
LOCK_ITEM_FLAG	VARCHAR2	(1)		Flag to prevent the changes to items returned from punchout site.
USER_DATA_LIST_ID	NUMBER			For future Use.
USER_NAME	VARCHAR2	(100)		The User Name to the external site application. Applicable to the Exchange Punchout and Supplier Transparent Punchout Catalogs.
IS_HUB	VARCHAR2	(1)		Not used
SEQUENCE_NUMBER	NUMBER			Not used
PUBLISHED_FLAG	VARCHAR2	(1)		For future Use.
ICX_SESSION_SERVLET_FLAG	VARCHAR2	(1)		Flag to extend the user's idle session timeout during punchout. The Flag indicates ICX Session Callback URL is sent to Supplier or not in the punchout login request document (under the ICXSessionCallbackURL element).
COMPANY_NAME	VARCHAR2	(240)		The Buyer Company Name/Domain. Used in case of a Punchout Catalog, where the supplier may use this information for authentication and validation purposes.
COMPANY_NUMBER	VARCHAR2	(35)		The Buyer Company Id/Domain Identifier. Used in case of a Punchout Catalog, where the supplier may use this information for authentication and validation purposes.
SUPPLIER_NAME	VARCHAR2	(240)		The Supplier Credentials. The Supplier Name corresponds to the external supplier to whom the buyer is punching out.
SUPPLIER_NUMBER	VARCHAR2	(35)		The Supplier Credentials. The Identifier of the Supplier.
AUTHENTICATED_KEY	VARCHAR2	(250)		Key sent back by the supplier site for transparent punchout which can be used for successive searches within that supplier site without needing re-authentication.
USER_INFO_FLAG	VARCHAR2	(1)		Flag indicating if the optional user and company information is to be sent to the punchout supplier site.
SUPPLIER_ID_LIST	VARCHAR2	(700)		The List of Vendor Ids, delimited by a comma. The Supplier lists include the supplier's catalogs that are enabled for the current local catalog. A Supplier Id of {-2} indicates the whole of the catalog data (All Suppliers).
INCLUDE_INTERNAL_SOURCE_FLAG	VARCHAR2	(240)		Flag specifies if the Internal Items (Items in a catalog not pertaining to any supplier) should be included in the current local catalog.
ENCODING	VARCHAR2	(30)		The (Middle-Tier) Character Set Encoding to be used during punchout.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number (per eBiz Suite Physical Data Model Standard). Set to 1 initially, incremented every time row is updated. See standards doc for full description.
KEY_1	VARCHAR2	(30)		The field directly correlates to the Key 1 FORMs field used for category and uom mapping in Oracle eCommerce Gateway. This attribute is marked mandatory.
VENDOR_ID	NUMBER			The Vendor Id of the external Supplier (Transparent) Punchout Site. Foreign key to the PO_VENDORS.VENDOR_ID. Used for resolving the category and uom mapping defined in Oracle eCommerce Gateway.
VENDOR_SITE_ID	NUMBER			The Vendor Site Id of the external Supplier (Transparent) Punchout Site. Used for resolving the category and uom mapping.
OPERATION_ALLOWED	VARCHAR2	(8)		Repunchout operation 1. null : Inspect only 2. edit: Inspect and edit item
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)		Indicates whether the requisition line has a price negotiated by buyer.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_SOURCE_ID
,      TYPE
,      URL
,      IMAGE_URL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISPLAY_ALWAYS
,      PASSWORD
,      PROTOCOL_SUPPORTED
,      PARTY_SITE_ID
,      OPERATOR_ID
,      LOCK_ITEM_FLAG
,      USER_DATA_LIST_ID
,      USER_NAME
,      IS_HUB
,      SEQUENCE_NUMBER
,      PUBLISHED_FLAG
,      ICX_SESSION_SERVLET_FLAG
,      COMPANY_NAME
,      COMPANY_NUMBER
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      AUTHENTICATED_KEY
,      USER_INFO_FLAG
,      SUPPLIER_ID_LIST
,      INCLUDE_INTERNAL_SOURCE_FLAG
,      ENCODING
,      OBJECT_VERSION_NUMBER
,      KEY_1
,      VENDOR_ID
,      VENDOR_SITE_ID
,      OPERATION_ALLOWED
,      NEGOTIATED_BY_PREPARER_FLAG
FROM ICX.ICX_POR_ITEM_SOURCES;

Dependencies

[top of page]

ICX.ICX_POR_ITEM_SOURCES does not reference any database object

ICX.ICX_POR_ITEM_SOURCES is referenced by following:

ICX: ICX_POR_ITEM_SOURCES#