FND Design Data [Home] [Help]

View: AS_ACCESSES

Product: AS - Sales Foundation
Description: Contains employee access records for accounts and opportunities (multi-org).
Implementation/DBA Data: ViewAPPS.AS_ACCESSES
View Text

SELECT ACCESS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ACCESS_TYPE
, FREEZE_FLAG
, REASSIGN_FLAG
, TEAM_LEADER_FLAG
, CUSTOMER_ID
, ADDRESS_ID
, SALESFORCE_ID
, PERSON_ID
, PARTNER_CUSTOMER_ID
, PARTNER_ADDRESS_ID
, CREATED_PERSON_ID
, LEAD_ID
, FREEZE_DATE
, REASSIGN_REASON
, ORG_ID
, DOWNLOADABLE_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SALESFORCE_ROLE_CODE
, SALESFORCE_RELATIONSHIP_CODE
, SALES_GROUP_ID
, REASSIGN_REQUESTED_PERSON_ID
, REASSIGN_REQUEST_DATE
, INTERNAL_UPDATE_ACCESS
, SALES_LEAD_ID
, PARTNER_CONT_PARTY_ID
FROM AS_ACCESSES_ALL_ALL
WHERE DELETE_FLAG IS NULL

Columns

Name
ACCESS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ACCESS_TYPE
FREEZE_FLAG
REASSIGN_FLAG
TEAM_LEADER_FLAG
CUSTOMER_ID
ADDRESS_ID
SALESFORCE_ID
PERSON_ID
PARTNER_CUSTOMER_ID
PARTNER_ADDRESS_ID
CREATED_PERSON_ID
LEAD_ID
FREEZE_DATE
REASSIGN_REASON
ORG_ID
DOWNLOADABLE_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
SALESFORCE_ROLE_CODE
SALESFORCE_RELATIONSHIP_CODE
SALES_GROUP_ID
REASSIGN_REQUESTED_PERSON_ID
REASSIGN_REQUEST_DATE
INTERNAL_UPDATE_ACCESS
SALES_LEAD_ID
PARTNER_CONT_PARTY_ID