Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_SALES_TEAM_PTR_V |
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.CUSTOMER_ID
, ACC.ADDRESS_ID
, ACC.PARTNER_CUSTOMER_ID
, ACC.PARTNER_ADDRESS_ID
, ACC.SALESFORCE_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
, CUST.PARTY_NAME
, CUST.PARTY_NUMBER
, ACC.SALESFORCE_ROLE_CODE
, ASLKP2.MEANING
, ACC.SALESFORCE_RELATIONSHIP_CODE
, ASLKP3.MEANING
, ACC.REASSIGN_REQUEST_DATE
, ACC.REASSIGN_REQUESTED_PERSON_ID
, ACC.PARTNER_CONT_PARTY_ID
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, LOC.COUNTRY
, FTV.TERRITORY_SHORT_NAME
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, CUST.PARTY_TYPE
, ACC.SALES_LEAD_ID
, PV_MATCH_V3_PUB.GET_PARTNER_TYPES(PV.PARTNER_ID) PARTNERTYPE
, DECODE(PV.PARTNER_LEVEL
, NULL
, ''
, (SELECT DESCRIPTION
FROM PV_ATTRIBUTE_CODES_VL
WHERE ATTR_CODE_ID = PV.PARTNER_LEVEL))PARTLEVEL
, FNDLV.MEANING CERTLEVEL
FROM HZ_PARTIES CUST
, PV_PARTNER_PROFILES PV
, AS_ACCESSES_ALL ACC
, HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, AS_LOOKUPS ASLKP2
, AS_LOOKUPS ASLKP3
, FND_TERRITORIES_VL FTV
, FND_LOOKUP_VALUES FNDLV
WHERE ACC.PARTNER_CUSTOMER_ID = PV.PARTNER_ID
AND CUST.PARTY_ID = PV.PARTNER_PARTY_ID
AND ACC.PARTNER_ADDRESS_ID = SITE.PARTY_SITE_ID(+)
AND SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND ACC.SALESFORCE_ROLE_CODE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'ROLE_TYPE'
AND ACC.SALESFORCE_RELATIONSHIP_CODE = ASLKP3.LOOKUP_CODE(+)
AND ASLKP3.LOOKUP_TYPE(+) = 'SALESFORCE_RELATIONSHIP'
AND FNDLV.LOOKUP_CODE(+) = CUST.CERTIFICATION_LEVEL
AND FNDLV.LOOKUP_TYPE(+) = 'HZ_PARTY_CERT_LEVEL'
AND FNDLV.LANGUAGE(+) = USERENV('LANG')
AND LOC.COUNTRY = FTV.TERRITORY_CODE(+)