[Home] [Help] [Dependency Information]
Object Name: | AS_LIST_ENTRIES |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_LIST_ENTRIES |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_LIST_ENTRIES_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | LIST_ENTRY_ID |
AS_LIST_ENTRIES_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LIST_ID |
AS_LIST_ENTRIES_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
CUSTOMER_ID
ADDRESS_ID |
AS_LIST_ENTRIES_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CONTACT_ID |
AS_LIST_ENTRIES_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LEAD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_ENTRY_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
TRANSFER_FLAG | VARCHAR2 | (1) | ||
TRANSFER_STATUS | VARCHAR2 | (1) | ||
LIST_ID | NUMBER | Yes | ||
LIST_SOURCE | VARCHAR2 | (240) | ||
COMPANY_NAME | VARCHAR2 | (50) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
ADDRESS4 | VARCHAR2 | (240) | ||
CITY | VARCHAR2 | (60) | ||
COUNTY | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (60) | ||
PROVINCE | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
COUNTRY_CODE | VARCHAR2 | (60) | ||
FIRST_NAME | VARCHAR2 | (40) | ||
LAST_NAME | VARCHAR2 | (50) | ||
CONTACT_SUFFIX | VARCHAR2 | (60) | ||
TITLE_CODE | VARCHAR2 | (30) | ||
JOB_TITLE_CODE | VARCHAR2 | (30) | ||
JOB_TITLE | VARCHAR2 | (50) | ||
MAIL_STOP | VARCHAR2 | (60) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
PHONE_TYPE_CODE | VARCHAR2 | (15) | ||
AREA_CODE | VARCHAR2 | (10) | ||
PHONE_NUMBER | VARCHAR2 | (25) | ||
EXTENSION | VARCHAR2 | (20) | ||
CUSTOMER_ID | NUMBER | |||
ADDRESS_ID | NUMBER | |||
CONTACT_ID | NUMBER | |||
PHONE_ID | NUMBER | |||
LEAD_ID | NUMBER | |||
PERSON_ID | NUMBER | |||
PERSON_USER_ID | NUMBER | |||
LETTER_ID | NUMBER | |||
EVENT_ID | NUMBER | |||
PICKING_HEADER_ID | NUMBER | |||
BATCH_ID | NUMBER | |||
MARKED_FLAG | VARCHAR2 | (1) | ||
USE_PVT_MAILING_ADDRESS | VARCHAR2 | (1) | ||
CUSTOMER_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
ADDRESS_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
CONTACT_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
NUM_OF_EMPLOYEES | NUMBER | (15) | ||
PARENT_CUSTOMER_ID | NUMBER | (15) | ||
PARENT_COMPANY_NAME | VARCHAR2 | (50) | ||
POTENTIAL_REVENUE_CURR_FY | NUMBER | |||
NATIVE_LANGUAGE_CODE | VARCHAR2 | (30) | ||
OTHER_LANGUAGE_CODE_1 | VARCHAR2 | (30) | ||
POTENTIAL_REVENUE_NEXT_FY | NUMBER | |||
OTHER_LANGUAGE_CODE_2 | VARCHAR2 | (30) | ||
FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | ||
ANALYSIS_FY | VARCHAR2 | (5) | ||
MISSION_STATEMENT | VARCHAR2 | (2000) | ||
TAX_REFERENCE | VARCHAR2 | (50) | ||
NET_WORTH | NUMBER | |||
YEAR_ESTABLISHED | NUMBER | (4) | ||
DEPARTMENT_CODE | VARCHAR2 | (30) | ||
DEPARTMENT | VARCHAR2 | (60) | ||
RANK | VARCHAR2 | (30) | ||
MANAGED_BY | NUMBER | (15) | ||
MANAGER_FIRST_NAME | VARCHAR2 | (40) | ||
MANAGER_LAST_NAME | VARCHAR2 | (50) | ||
NATIVE_LANGUAGE | VARCHAR2 | (30) | ||
OTHER_LANGUAGE_1 | VARCHAR2 | (30) | ||
OTHER_LANGUAGE_2 | VARCHAR2 | (30) | ||
ADDRESS_PHONE_TYPE_CODE1 | VARCHAR2 | (30) | ||
ADDRESS_PHONE_TYPE_CODE2 | VARCHAR2 | (30) | ||
ADDRESS_PHONE_TYPE_CODE3 | VARCHAR2 | (30) | ||
ADDRESS_PHONE_TYPE_CODE4 | VARCHAR2 | (30) | ||
ADDRESS_PHONE_TYPE_CODE5 | VARCHAR2 | (30) | ||
ADDRESS_PHONE_AREA_CODE1 | VARCHAR2 | (10) | ||
ADDRESS_PHONE_AREA_CODE2 | VARCHAR2 | (10) | ||
ADDRESS_PHONE_AREA_CODE3 | VARCHAR2 | (10) | ||
ADDRESS_PHONE_AREA_CODE4 | VARCHAR2 | (10) | ||
ADDRESS_PHONE_AREA_CODE5 | VARCHAR2 | (10) | ||
ADDRESS_PHONE_NUMBER1 | VARCHAR2 | (25) | ||
ADDRESS_PHONE_NUMBER2 | VARCHAR2 | (25) | ||
ADDRESS_PHONE_NUMBER3 | VARCHAR2 | (25) | ||
ADDRESS_PHONE_NUMBER4 | VARCHAR2 | (25) | ||
ADDRESS_PHONE_NUMBER5 | VARCHAR2 | (25) | ||
ADDRESS_PHONE_EXTENSION1 | VARCHAR2 | (20) | ||
ADDRESS_PHONE_EXTENSION2 | VARCHAR2 | (20) | ||
ADDRESS_PHONE_EXTENSION3 | VARCHAR2 | (20) | ||
ADDRESS_PHONE_EXTENSION4 | VARCHAR2 | (20) | ||
ADDRESS_PHONE_EXTENSION5 | VARCHAR2 | (20) | ||
CONTACT_PHONE_TYPE_CODE1 | VARCHAR2 | (30) | ||
CONTACT_PHONE_TYPE_CODE2 | VARCHAR2 | (30) | ||
CONTACT_PHONE_TYPE_CODE3 | VARCHAR2 | (30) | ||
CONTACT_PHONE_TYPE_CODE4 | VARCHAR2 | (30) | ||
CONTACT_PHONE_TYPE_CODE5 | VARCHAR2 | (30) | ||
CONTACT_PHONE_AREA_CODE1 | VARCHAR2 | (10) | ||
CONTACT_PHONE_AREA_CODE2 | VARCHAR2 | (10) | ||
CONTACT_PHONE_AREA_CODE3 | VARCHAR2 | (10) | ||
CONTACT_PHONE_AREA_CODE4 | VARCHAR2 | (10) | ||
CONTACT_PHONE_AREA_CODE5 | VARCHAR2 | (10) | ||
CONTACT_PHONE_NUMBER1 | VARCHAR2 | (25) | ||
CONTACT_PHONE_NUMBER2 | VARCHAR2 | (25) | ||
CONTACT_PHONE_NUMBER3 | VARCHAR2 | (25) | ||
CONTACT_PHONE_NUMBER4 | VARCHAR2 | (25) | ||
CONTACT_PHONE_NUMBER5 | VARCHAR2 | (25) | ||
CONTACT_PHONE_EXTENSION1 | VARCHAR2 | (20) | ||
CONTACT_PHONE_EXTENSION2 | VARCHAR2 | (20) | ||
CONTACT_PHONE_EXTENSION3 | VARCHAR2 | (20) | ||
CONTACT_PHONE_EXTENSION4 | VARCHAR2 | (20) | ||
CONTACT_PHONE_EXTENSION5 | VARCHAR2 | (20) | ||
CUSTOMER_USER_DEFINED1 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED2 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED3 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED4 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED5 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED6 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED7 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED8 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED9 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED10 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED11 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED12 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED13 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED14 | VARCHAR2 | (150) | ||
CUSTOMER_USER_DEFINED15 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED1 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED2 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED3 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED4 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED5 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED6 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED7 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED8 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED9 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED10 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED11 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED12 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED13 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED14 | VARCHAR2 | (150) | ||
ADDRESS_USER_DEFINED15 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED1 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED2 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED3 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED4 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED5 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED6 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED7 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED8 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED9 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED10 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED11 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED12 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED13 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED14 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED15 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED16 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED17 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED18 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED19 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED20 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED21 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED22 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED23 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED24 | VARCHAR2 | (150) | ||
CONTACT_USER_DEFINED25 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
ATTRIBUTE21 | VARCHAR2 | (150) | ||
ATTRIBUTE22 | VARCHAR2 | (150) | ||
ATTRIBUTE23 | VARCHAR2 | (150) | ||
ATTRIBUTE24 | VARCHAR2 | (150) | ||
ATTRIBUTE25 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_ENTRY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSFER_FLAG
, TRANSFER_STATUS
, LIST_ID
, LIST_SOURCE
, COMPANY_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, COUNTY
, STATE
, PROVINCE
, POSTAL_CODE
, COUNTRY_CODE
, FIRST_NAME
, LAST_NAME
, CONTACT_SUFFIX
, TITLE_CODE
, JOB_TITLE_CODE
, JOB_TITLE
, MAIL_STOP
, EMAIL_ADDRESS
, PHONE_TYPE_CODE
, AREA_CODE
, PHONE_NUMBER
, EXTENSION
, CUSTOMER_ID
, ADDRESS_ID
, CONTACT_ID
, PHONE_ID
, LEAD_ID
, PERSON_ID
, PERSON_USER_ID
, LETTER_ID
, EVENT_ID
, PICKING_HEADER_ID
, BATCH_ID
, MARKED_FLAG
, USE_PVT_MAILING_ADDRESS
, CUSTOMER_ORIG_SYSTEM_REFERENCE
, ADDRESS_ORIG_SYSTEM_REFERENCE
, CONTACT_ORIG_SYSTEM_REFERENCE
, NUM_OF_EMPLOYEES
, PARENT_CUSTOMER_ID
, PARENT_COMPANY_NAME
, POTENTIAL_REVENUE_CURR_FY
, NATIVE_LANGUAGE_CODE
, OTHER_LANGUAGE_CODE_1
, POTENTIAL_REVENUE_NEXT_FY
, OTHER_LANGUAGE_CODE_2
, FISCAL_YEAREND_MONTH
, ANALYSIS_FY
, MISSION_STATEMENT
, TAX_REFERENCE
, NET_WORTH
, YEAR_ESTABLISHED
, DEPARTMENT_CODE
, DEPARTMENT
, RANK
, MANAGED_BY
, MANAGER_FIRST_NAME
, MANAGER_LAST_NAME
, NATIVE_LANGUAGE
, OTHER_LANGUAGE_1
, OTHER_LANGUAGE_2
, ADDRESS_PHONE_TYPE_CODE1
, ADDRESS_PHONE_TYPE_CODE2
, ADDRESS_PHONE_TYPE_CODE3
, ADDRESS_PHONE_TYPE_CODE4
, ADDRESS_PHONE_TYPE_CODE5
, ADDRESS_PHONE_AREA_CODE1
, ADDRESS_PHONE_AREA_CODE2
, ADDRESS_PHONE_AREA_CODE3
, ADDRESS_PHONE_AREA_CODE4
, ADDRESS_PHONE_AREA_CODE5
, ADDRESS_PHONE_NUMBER1
, ADDRESS_PHONE_NUMBER2
, ADDRESS_PHONE_NUMBER3
, ADDRESS_PHONE_NUMBER4
, ADDRESS_PHONE_NUMBER5
, ADDRESS_PHONE_EXTENSION1
, ADDRESS_PHONE_EXTENSION2
, ADDRESS_PHONE_EXTENSION3
, ADDRESS_PHONE_EXTENSION4
, ADDRESS_PHONE_EXTENSION5
, CONTACT_PHONE_TYPE_CODE1
, CONTACT_PHONE_TYPE_CODE2
, CONTACT_PHONE_TYPE_CODE3
, CONTACT_PHONE_TYPE_CODE4
, CONTACT_PHONE_TYPE_CODE5
, CONTACT_PHONE_AREA_CODE1
, CONTACT_PHONE_AREA_CODE2
, CONTACT_PHONE_AREA_CODE3
, CONTACT_PHONE_AREA_CODE4
, CONTACT_PHONE_AREA_CODE5
, CONTACT_PHONE_NUMBER1
, CONTACT_PHONE_NUMBER2
, CONTACT_PHONE_NUMBER3
, CONTACT_PHONE_NUMBER4
, CONTACT_PHONE_NUMBER5
, CONTACT_PHONE_EXTENSION1
, CONTACT_PHONE_EXTENSION2
, CONTACT_PHONE_EXTENSION3
, CONTACT_PHONE_EXTENSION4
, CONTACT_PHONE_EXTENSION5
, CUSTOMER_USER_DEFINED1
, CUSTOMER_USER_DEFINED2
, CUSTOMER_USER_DEFINED3
, CUSTOMER_USER_DEFINED4
, CUSTOMER_USER_DEFINED5
, CUSTOMER_USER_DEFINED6
, CUSTOMER_USER_DEFINED7
, CUSTOMER_USER_DEFINED8
, CUSTOMER_USER_DEFINED9
, CUSTOMER_USER_DEFINED10
, CUSTOMER_USER_DEFINED11
, CUSTOMER_USER_DEFINED12
, CUSTOMER_USER_DEFINED13
, CUSTOMER_USER_DEFINED14
, CUSTOMER_USER_DEFINED15
, ADDRESS_USER_DEFINED1
, ADDRESS_USER_DEFINED2
, ADDRESS_USER_DEFINED3
, ADDRESS_USER_DEFINED4
, ADDRESS_USER_DEFINED5
, ADDRESS_USER_DEFINED6
, ADDRESS_USER_DEFINED7
, ADDRESS_USER_DEFINED8
, ADDRESS_USER_DEFINED9
, ADDRESS_USER_DEFINED10
, ADDRESS_USER_DEFINED11
, ADDRESS_USER_DEFINED12
, ADDRESS_USER_DEFINED13
, ADDRESS_USER_DEFINED14
, ADDRESS_USER_DEFINED15
, CONTACT_USER_DEFINED1
, CONTACT_USER_DEFINED2
, CONTACT_USER_DEFINED3
, CONTACT_USER_DEFINED4
, CONTACT_USER_DEFINED5
, CONTACT_USER_DEFINED6
, CONTACT_USER_DEFINED7
, CONTACT_USER_DEFINED8
, CONTACT_USER_DEFINED9
, CONTACT_USER_DEFINED10
, CONTACT_USER_DEFINED11
, CONTACT_USER_DEFINED12
, CONTACT_USER_DEFINED13
, CONTACT_USER_DEFINED14
, CONTACT_USER_DEFINED15
, CONTACT_USER_DEFINED16
, CONTACT_USER_DEFINED17
, CONTACT_USER_DEFINED18
, CONTACT_USER_DEFINED19
, CONTACT_USER_DEFINED20
, CONTACT_USER_DEFINED21
, CONTACT_USER_DEFINED22
, CONTACT_USER_DEFINED23
, CONTACT_USER_DEFINED24
, CONTACT_USER_DEFINED25
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
FROM OSM.AS_LIST_ENTRIES;
OSM.AS_LIST_ENTRIES does not reference any database object
OSM.AS_LIST_ENTRIES is referenced by following:
|
|
|