VIEW: APPS.AS_ACCESSES

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 , 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

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
, 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