FND Design Data [Home] [Help]

View: AS_LEAD_CONTACTS

Product: AS - Sales Foundation
Description: Sales opportunity contacts (multi-org)
Implementation/DBA Data: ViewAPPS.AS_LEAD_CONTACTS
View Text

SELECT LEAD_CONTACT_ID
, LEAD_ID
, CONTACT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ENABLED_FLAG
, CUSTOMER_ID
, ADDRESS_ID
, RANK
, PHONE_ID
, ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTACT_PARTY_ID
, PRIMARY_CONTACT_FLAG
, ROLE
FROM AS_LEAD_CONTACTS_ALL

Columns

Name
LEAD_CONTACT_ID
LEAD_ID
CONTACT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ENABLED_FLAG
CUSTOMER_ID
ADDRESS_ID
RANK
PHONE_ID
ORG_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CONTACT_PARTY_ID
PRIMARY_CONTACT_FLAG
ROLE