VIEW: APPS.AS_ACCESSES_ALL

Source

View Text - Preformatted

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,FREEZE_DATE,LEAD_ID,REASSIGN_REASON,SALESFORCE_ROLE_CODE,SALESFORCE_RELATIONSHIP_CODE,ORG_ID,DOWNLOADABLE_FLAG,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,SALES_GROUP_ID,REASSIGN_REQUESTED_PERSON_ID,REASSIGN_REQUEST_DATE,INTERNAL_UPDATE_ACCESS,SALES_LEAD_ID,SECURITY_GROUP_ID,PARTNER_CONT_PARTY_ID,OWNER_FLAG,CONTRIBUTOR_FLAG,CREATED_BY_TAP_FLAG,PRM_KEEP_FLAG,OPEN_FLAG,LEAD_RANK_SCORE,OBJECT_CREATION_DATE,OBJECT_VERSION_NUMBER FROM AS_ACCESSES_ALL_ALL WHERE DELETE_FLAG IS NULL

View Text - HTML Formatted

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
, FREEZE_DATE
, LEAD_ID
, REASSIGN_REASON
, SALESFORCE_ROLE_CODE
, SALESFORCE_RELATIONSHIP_CODE
, ORG_ID
, DOWNLOADABLE_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SALES_GROUP_ID
, REASSIGN_REQUESTED_PERSON_ID
, REASSIGN_REQUEST_DATE
, INTERNAL_UPDATE_ACCESS
, SALES_LEAD_ID
, SECURITY_GROUP_ID
, PARTNER_CONT_PARTY_ID
, OWNER_FLAG
, CONTRIBUTOR_FLAG
, CREATED_BY_TAP_FLAG
, PRM_KEEP_FLAG
, OPEN_FLAG
, LEAD_RANK_SCORE
, OBJECT_CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM AS_ACCESSES_ALL_ALL
WHERE DELETE_FLAG IS NULL