DBA Data[Home] [Help] [Dependency Information]

VIEW: IBE.IBE_LEAD_IMPORT_DETAILS#

Object Details
Object Name: IBE_LEAD_IMPORT_DETAILS#
Object Type: VIEW
Owner: IBE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DETAIL_ID NUMBER
Yes
LOG_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

QUOTE_HEADER_ID NUMBER
Yes
ORDER_ID NUMBER

CUSTOMER_FIRST_NAME VARCHAR2 (150)
CUSTOMER_LAST_NAME VARCHAR2 (150)
PHONE_NUMBER VARCHAR2 (25)
FAX_NUMBER VARCHAR2 (50)
EMAIL_ADDRESS VARCHAR2 (240)
NOTES VARCHAR2 (200)
CUSTOMER_NAME VARCHAR2 (360)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
CITY VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
STATUS_FLAG VARCHAR2 (3)
MESSAGE VARCHAR2 (2000)
SECURITY_GROUP_ID NUMBER

Query Text

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#;

Dependencies

[top of page]

IBE.IBE_LEAD_IMPORT_DETAILS# references the following:

SchemaIBE
TableIBE_LEAD_IMPORT_DETAILS
IBE.IBE_LEAD_IMPORT_DETAILS# is referenced by following:

SchemaAPPS
SynonymIBE_LEAD_IMPORT_DETAILS