View: AS_ACCESSES_ACTIVE_V

Product:	AS - Sales Foundation
Description:	Contains active access records
Implementation/DBA Data:	APPS.AS_ACCESSES_ACTIVE_V

View Text

SELECT ACC.ROWID
, ACC.ACCESS_ID
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
, ACC.CREATION_DATE
, ACC.CREATED_BY
, ACC.LAST_UPDATE_LOGIN
, ACC.REQUEST_ID
, ACC.PROGRAM_APPLICATION_ID
, ACC.PROGRAM_ID
, ACC.PROGRAM_UPDATE_DATE
, ACC.ACCESS_TYPE
, ACC.FREEZE_FLAG
, ACC.REASSIGN_FLAG
, ACC.TEAM_LEADER_FLAG
, ACC.SALESFORCE_ID
, ACC.SALES_GROUP_ID
, GRP.GROUP_NAME
, ACC.PERSON_ID
, ACC.CUSTOMER_ID
, ACC.ADDRESS_ID
, ACC.CREATED_PERSON_ID
, ACC.LEAD_ID
, ACC.FREEZE_DATE
, ACC.REASSIGN_REASON
, ACC.DOWNLOADABLE_FLAG
, ACC.ATTRIBUTE_CATEGORY
, ACC.ATTRIBUTE1
, ACC.ATTRIBUTE2
, ACC.ATTRIBUTE3
, ACC.ATTRIBUTE4
, ACC.ATTRIBUTE5
, ACC.ATTRIBUTE6
, ACC.ATTRIBUTE7
, ACC.ATTRIBUTE8
, ACC.ATTRIBUTE9
, ACC.ATTRIBUTE10
, ACC.ATTRIBUTE11
, ACC.ATTRIBUTE12
, ACC.ATTRIBUTE13
, ACC.ATTRIBUTE14
, ACC.ATTRIBUTE15
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, PEOPLE.FIRST_NAME || ' ' || PEOPLE.LAST_NAME
, LEAD.LEAD_NUMBER
, LEAD.DESCRIPTION
, CUST.PARTY_NAME
, CUST.PARTY_NUMBER
, ADDR.PARTY_SITE_ID
, SALCUST.PARTY_NAME
, LOC.ADDRESS1
, LOC.CITY
, ACC.SALESFORCE_ROLE_CODE
, ASLKP1.MEANING
, ACC.SALESFORCE_RELATIONSHIP_CODE
, ASLKP2.MEANING
, ACC.REASSIGN_REQUEST_DATE
, ACC.REASSIGN_REQUESTED_PERSON_ID
, ACC.INTERNAL_UPDATE_ACCESS
FROM PER_PEOPLE_X PEOPLE
, AS_LEADS_ALL LEAD
, HZ_PARTY_SITES ADDR
, HZ_LOCATIONS LOC
, HZ_PARTIES CUST
, JTF_RS_RESOURCE_EXTNS SALES
, HZ_PARTIES SALCUST
, AS_ACCESSES_ALL ACC
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, JTF_RS_GROUPS_TL GRP
WHERE ACC.CUSTOMER_ID = CUST.PARTY_ID
AND ACC.LEAD_ID = LEAD.LEAD_ID(+)
AND ACC.PERSON_ID = PEOPLE.PERSON_ID(+)
AND ACC.ADDRESS_ID = ADDR.PARTY_SITE_ID(+)
AND ADDR.LOCATION_ID = LOC.LOCATION_ID(+)
AND ACC.SALESFORCE_ID = SALES.RESOURCE_ID
AND ACC.PARTNER_CUSTOMER_ID = SALCUST.PARTY_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+)
AND PEOPLE.EFFECTIVE_END_DATE(+)
AND ACC.SALESFORCE_ROLE_CODE = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'ROLE_TYPE'
AND ACC.SALESFORCE_RELATIONSHIP_CODE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'SALESFORCE_RELATIONSHIP'
AND ACC.SALES_GROUP_ID = GRP.GROUP_ID(+)
AND GRP.LANGUAGE(+) = USERENV('LANG')

Columns