[Home] [Help]
[Dependency Information]
[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
|
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:
OSM
AS_LIST_ENTRIES#
|
|
|
|