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_CAT_PUNCHOUT_ZONE_DETAILS

Object Details

Object Name:	ICX_CAT_PUNCHOUT_ZONE_DETAILS
Object Type:	TABLE
Owner:	ICX
Subobject Name:
Status:	VALID

This table stores the punchout zone details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_PUNCHOUT_ZONE_DTLS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ZONE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ZONE_ID	NUMBER		Yes	punchout zone ID
PROTOCOL_SUPPORTED	VARCHAR2	(20)		protocol supported
USER_NAME	VARCHAR2	(100)		user name
COMPANY_NAME	VARCHAR2	(240)		buyer company name
COMPANY_NUMBER	VARCHAR2	(35)		buyer company identity key
SUPPLIER_NAME	VARCHAR2	(240)		supplier name
SUPPLIER_NUMBER	VARCHAR2	(35)		identification for supplier
ECGATEWAY_MAP_KEY1	VARCHAR2	(30)		key1 of EC Gateway mapping
VENDOR_ID	NUMBER			supplier ID
VENDOR_SITE_ID	NUMBER			supplier site ID
ENCODING	VARCHAR2	(30)		encoding used for this content zone
PARTY_SITE_ID	NUMBER			supplier's trading partner ID on Oracle Exchange
PARENT_ZONE_ID	NUMBER			the content zone ID of the hub where this external site is downloaded from
AUTHENTICATED_KEY	VARCHAR2	(250)		key that the external site generates that Oracle iProcurement can use for all future search requests
USER_INFO_FLAG	VARCHAR2	(1)		flag to indicate whether this content zone has optional user elements
LOCK_ITEM_FLAG	VARCHAR2	(1)		flag to indicate whether changes are allowed to be made to the item that is brought back from this content zone
RETAIN_SESSION_FLAG	VARCHAR2	(1)		flag to indicate whether to extend user's idle session timeout during punchout
OPERATION_ALLOWED	VARCHAR2	(8)		flag to indicate if re-punchout is allowed
NEGOTIATED_FLAG	VARCHAR2	(1)		negotiated by preparer flag
CREATED_BY	NUMBER		Yes	created by
CREATION_DATE	DATE		Yes	creation date
LAST_UPDATED_BY	NUMBER		Yes	last updated by
LAST_UPDATE_DATE	DATE		Yes	last update date
LAST_UPDATE_LOGIN	NUMBER			last update login

Query Text

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


SELECT ZONE_ID
,      PROTOCOL_SUPPORTED
,      USER_NAME
,      COMPANY_NAME
,      COMPANY_NUMBER
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      ECGATEWAY_MAP_KEY1
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ENCODING
,      PARTY_SITE_ID
,      PARENT_ZONE_ID
,      AUTHENTICATED_KEY
,      USER_INFO_FLAG
,      LOCK_ITEM_FLAG
,      RETAIN_SESSION_FLAG
,      OPERATION_ALLOWED
,      NEGOTIATED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_CAT_PUNCHOUT_ZONE_DETAILS;

Dependencies

[top of page]

ICX.ICX_CAT_PUNCHOUT_ZONE_DETAILS does not reference any database object

ICX.ICX_CAT_PUNCHOUT_ZONE_DETAILS is referenced by following:

APPS: ICX_CAT_PUNCHOUT_ZONE_DETAILS