View: PV_PRTNR_SALES_TEAM_V

Product:	PV - Partner Management
Description:
Implementation/DBA Data:	APPS.PV_PRTNR_SALES_TEAM_V

View Text

SELECT ACC.LAST_UPDATE_DATE
, HZPP.PARTY_ID PERSON_ID
, ACC.TEAM_LEADER_FLAG
, ACC.FREEZE_FLAG FREEZE_FLAG
, HLOC.CITY CITY
, HLOC.POSTAL_CODE POSTAL_CODE
, HLOC.STATE STATE
, HLOC.PROVINCE PROVINCE
, HLOC.COUNTY COUNTY
, HLOC.COUNTRY COUNTRY
, HLOC.ADDRESS1 ADDRESS1
, HLOC.ADDRESS2 ADDRESS2
, HLOC.ADDRESS3 ADDRESS3
, HLOC.ADDRESS4 ADDRESS4
, ACC.ADDRESS_ID ADDRESS_ID
, ACC.CUSTOMER_ID CUSTOMER_ID
, ACC.SALESFORCE_ID SALESFORCE_ID
, HZCP.PHONE_LINE_TYPE PHONE_LINE_TYPE
, HZCP.PHONE_AREA_CODE
, HZCP.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, HZCP.PHONE_NUMBER
, HZCP.PHONE_EXTENSION PHONE_EXTENSION
, ACC.ACCESS_ID ACCESS_ID
, SG.GROUP_NAME SALES_GROUP_NAME
, HZ1.PERSON_LAST_NAME
, HZ1.PERSON_MIDDLE_NAME
, HZ1.PERSON_FIRST_NAME
, FNDU.EMAIL_ADDRESS EMAIL_ADDRESS
, HZOC.JOB_TITLE
, ACC.SALES_GROUP_ID SALES_GROUP_ID
, ACC.LEAD_ID
, ACC.SALES_LEAD_ID
, ACC.SALESFORCE_ROLE_CODE SALESFORCE_ROLE_CODE
, ACC.SALESFORCE_RELATIONSHIP_CODE SALESFORCE_RELATIONSHIP_CODE
, HP.PARTY_NAME
, HZPP.OBJECT_ID PARTY_ID
, PTORG.PARTY_NAME
, HZOC.JOB_TITLE_CODE
, HZPP.SUBJECT_ID PERSON_PARTY_ID
FROM AS_ACCESSES_ALL ACC
, HZ_PARTIES HP
, HZ_RELATIONSHIPS HZPP
, HZ_PARTIES PTORG
, HZ_ORG_CONTACTS HZOC
, HZ_PARTIES HZ1
, JTF_RS_GROUPS_VL SG
, HZ_CONTACT_POINTS HZCP
, FND_USER FNDU
, JTF_RS_RESOURCE_EXTNS JTFRE
, HZ_PARTY_SITES PSITE
, HZ_LOCATIONS HLOC
WHERE ACC.PARTNER_CONT_PARTY_ID = HP.PARTY_ID
AND ACC.PARTNER_CONT_PARTY_ID = HZPP.PARTY_ID
AND HZPP.RELATIONSHIP_ID = HZOC.PARTY_RELATIONSHIP_ID
AND HZPP.OBJECT_ID = PTORG.PARTY_ID
AND PTORG.PARTY_TYPE = 'ORGANIZATION'
AND HZPP.SUBJECT_ID = HZ1.PARTY_ID
AND HZ1.PARTY_TYPE = 'PERSON'
AND ACC.SALESFORCE_ID = JTFRE.RESOURCE_ID
AND JTFRE.USER_ID = FNDU.USER_ID
AND ACC.SALES_GROUP_ID = SG.GROUP_ID (+)
AND HZPP.PARTY_ID = HZCP.OWNER_TABLE_ID(+)
AND HZCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HZCP.PRIMARY_FLAG(+) = 'Y'
AND HZCP.CONTACT_POINT_TYPE(+) = 'PHONE'
AND ACC.ADDRESS_ID = PSITE.PARTY_SITE_ID (+)
AND PSITE.LOCATION_ID = HLOC.LOCATION_ID (+)

Columns