[Home] [Help] [Dependency Information]
Object Name: | IBE_ORD_ONECLICK_ALL |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_ORD_ONECLICK_ALL |
Subobject Name: | |
Status: | VALID |
This table stores the express checkout settings for any registered customer of iStore. The settings stored include a flag to indicate whether the settings are currently enabled, and foreign keys to the billing address, the shipping address, the shipment method and the payment information.
For any given combination of party_id and cust_account_id there can be only one row in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_ORD_ONECLICK_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CUST_ACCOUNT_ID
PARTY_ID ORG_ID |
IBE_ORD_ONECLICK_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYMENT_ID |
IBE_ORD_ONECLICK_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
IBE_ORD_ONECLICK_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BILL_TO_PTY_SITE_ID |
IBE_ORD_ONECLICK_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SHIP_TO_PTY_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORD_ONECLICK_ID | NUMBER | (15) | Yes | One Click Settings Identifier |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Object version number for locking |
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Customer Account Identifier |
PARTY_ID | NUMBER | (15) | Yes | Party Identifier |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ENABLED_FLAG | VARCHAR2 | (3) | Flag (Y, N) to enable or disable the express checkout | |
FREIGHT_CODE | VARCHAR2 | (25) | Shipment method for express checkout | |
PAYMENT_ID | NUMBER | (15) | Payment instrument for express checkout | |
BILL_TO_PTY_SITE_ID | NUMBER | (15) | Billing address for express checkout | |
SHIP_TO_PTY_SITE_ID | NUMBER | (15) | Shipping address for express checkout | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. | ||
REQUEST_ID | NUMBER | Concurrent WHO column. | ||
PROGRAM_ID | NUMBER | Concurrent WHO column. | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent WHO column. | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent WHO column. | ||
ORG_ID | NUMBER | Organization Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ORD_ONECLICK_ID
, OBJECT_VERSION_NUMBER
, CUST_ACCOUNT_ID
, PARTY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ENABLED_FLAG
, FREIGHT_CODE
, PAYMENT_ID
, BILL_TO_PTY_SITE_ID
, SHIP_TO_PTY_SITE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
FROM IBE.IBE_ORD_ONECLICK_ALL;
IBE.IBE_ORD_ONECLICK_ALL does not reference any database object
IBE.IBE_ORD_ONECLICK_ALL is referenced by following:
|
|
|