[Home] [Help] [Dependency Information]
Object Name: | IBE_MSITE_CURRENCIES |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_MSITE_CURRENCIES |
Subobject Name: | |
Status: | VALID |
IBE_MSITE_CURRENCIES stores the currencies supported by the Specialty Store defined in IBE_MSITES_B. A Specialty Store need to support at least one currency and can support more than one currencies. The default currency for aSpecialty Store must be supported by the sameSpecialty Store as well.
For each Specialty Store and any of its supported currencies, this table also stores the orderable limit and the price lists for business partners, registered and walkin customers, stored in QP_LIST_HEADERS_B.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_MSITE_CURRENCIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MSITE_ID |
IBE_MSITE_CURRENCIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSITE_CURRENCY_ID | NUMBER | Yes | Mini Site Currency Identifier. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number for Locking |
CREATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. | ||
MSITE_ID | NUMBER | Yes | Mini Site Identifier. | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code identifies the currency supported by the minisite. |
BIZPARTNER_PRC_LISTID | NUMBER | (15) | Yes | Price list identifier, for business partner |
REGISTERED_PRC_LISTID | NUMBER | (15) | Yes | Price list Identifier, for registered users. |
WALKIN_PRC_LISTID | NUMBER | (15) | Yes | Price list Identifier, for walkin users. |
ORDERABLE_LIMIT | NUMBER | (15) | Maximum orderable Amount per mini site and currency. | |
PAYMENT_THRESHOLD | NUMBER | (15) | The payment threshold value for the currency | |
PARTNER_PRC_LISTID | NUMBER | (15) | Price List Id associated with the partner |
Cut, paste (and edit) the following text to query this object:
SELECT MSITE_CURRENCY_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, MSITE_ID
, CURRENCY_CODE
, BIZPARTNER_PRC_LISTID
, REGISTERED_PRC_LISTID
, WALKIN_PRC_LISTID
, ORDERABLE_LIMIT
, PAYMENT_THRESHOLD
, PARTNER_PRC_LISTID
FROM IBE.IBE_MSITE_CURRENCIES;
IBE.IBE_MSITE_CURRENCIES does not reference any database object
IBE.IBE_MSITE_CURRENCIES is referenced by following:
|
|
|