[Home] [Help] [Dependency Information]
Object Name: | ICX_CAT_PUNCHOUT_ZONE_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
This table stores the punchout zone details.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_CAT_PUNCHOUT_ZONE_DTLS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ZONE_ID |
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 |
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;
ICX.ICX_CAT_PUNCHOUT_ZONE_DETAILS does not reference any database object
ICX.ICX_CAT_PUNCHOUT_ZONE_DETAILS is referenced by following:
|
|
|