[Home] [Help] [Dependency Information]

TABLE: OSM.AS_LIST_ENTRIES

Object Details

Object Name:	AS_LIST_ENTRIES
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_LIST_ENTRIES
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

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

Columns

Query Text

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;

Dependencies

[top of page]

OSM.AS_LIST_ENTRIES does not reference any database object

OSM.AS_LIST_ENTRIES is referenced by following:

OSM

AS_LIST_ENTRIES#