[Home] [Help] [Dependency Information]
Object Name: | IBE_LEAD_IMPORT_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_LEAD_IMPORT_DETAILS |
Subobject Name: | |
Status: | VALID |
This table contains the details of the Leads Imported.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_LEAD_IMPORT_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DETAIL_ID
LOG_ID |
IBE_LEAD_IMPORT_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | QUOTE_HEADER_ID |
IBE_LEAD_IMPORT_DETAILS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORDER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_ID | NUMBER | Yes | Import Detail Identifier | |
LOG_ID | NUMBER | Yes | Log 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. | ||
QUOTE_HEADER_ID | NUMBER | Yes | Quote Header Identifier | |
ORDER_ID | NUMBER | Order Header Identifier | ||
CUSTOMER_FIRST_NAME | VARCHAR2 | (150) | Customer First Name | |
CUSTOMER_LAST_NAME | VARCHAR2 | (150) | Customer Last Name | |
PHONE_NUMBER | VARCHAR2 | (25) | Customer Phone Number | |
FAX_NUMBER | VARCHAR2 | (50) | Customer Fax Number | |
EMAIL_ADDRESS | VARCHAR2 | (240) | Customer Email Address | |
NOTES | VARCHAR2 | (200) | Lead Notes | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
ADDRESS1 | VARCHAR2 | (240) | Customer Address Line1 | |
ADDRESS2 | VARCHAR2 | (240) | Customer Address Line1 | |
ADDRESS3 | VARCHAR2 | (240) | Customer Address Line3 | |
CITY | VARCHAR2 | (60) | City | |
STATE | VARCHAR2 | (60) | State | |
POSTAL_CODE | VARCHAR2 | (60) | Postal Code | |
COUNTRY | VARCHAR2 | (60) | Country | |
STATUS_FLAG | VARCHAR2 | (3) | Import Status | |
MESSAGE | VARCHAR2 | (2000) | Error/Warning Message of Import | |
SECURITY_GROUP_ID | NUMBER | Security Group Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DETAIL_ID
, LOG_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, QUOTE_HEADER_ID
, ORDER_ID
, CUSTOMER_FIRST_NAME
, CUSTOMER_LAST_NAME
, PHONE_NUMBER
, FAX_NUMBER
, EMAIL_ADDRESS
, NOTES
, CUSTOMER_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, CITY
, STATE
, POSTAL_CODE
, COUNTRY
, STATUS_FLAG
, MESSAGE
, SECURITY_GROUP_ID
FROM IBE.IBE_LEAD_IMPORT_DETAILS;
IBE.IBE_LEAD_IMPORT_DETAILS does not reference any database object
IBE.IBE_LEAD_IMPORT_DETAILS is referenced by following:
|
|
|