View: PV_PARTNERS_V

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

View Text

SELECT INTERNAL.PARTY_ID
, INTERNAL.PARTY_NAME
, PARTNER.PARTY_ID
, PARTNER.PARTY_NAME
, HZOP.INTERNAL_FLAG
, HZR.RELATIONSHIP_ID
, HZR.RELATIONSHIP_CODE
, PVPP.PARTNER_PROFILE_ID
, PVPP.LAST_UPDATE_DATE
, PVPP.CREATION_DATE
, PVPP.OBJECT_VERSION_NUMBER
, PVPP.PARTNER_ID
, PVPP.TARGET_REVENUE_AMT
, PVPP.ACTUAL_REVENUE_AMT
, PVPP.TARGET_REVENUE_PCT
, PVPP.ACTUAL_REVENUE_PCT
, PVPP.ORIG_SYSTEM_REFERENCE
, PVPP.ORIG_SYSTEM_TYPE
, PVPP.CAPACITY_SIZE
, PVPP.CAPACITY_AMOUNT
, PVPP.AUTO_MATCH_ALLOWED_FLAG
, PVPP.PURCHASE_METHOD
, PVPP.CM_ID
, PVPP.PH_SUPPORT_REP
, PVPP.LEAD_SHARING_STATUS
, PVPP.LEAD_SHARE_APPR_FLAG
, PVPP.PARTNER_LEVEL
, PVPP.PREFERRED_VAD_ID
, PVPP.PARTNER_GROUP_ID
, PVPP.PARTNER_RESOURCE_ID
, PVPP.PARTNER_GROUP_NUMBER
, PVPP.PARTNER_RESOURCE_NUMBER
, PVPP.SALES_PARTNER_FLAG
, PVPP.INDIRECTLY_MANAGED_FLAG
, PVPP.CHANNEL_MARKETING_MANAGER
, PVPP.OPPTY_LAST_OFFERED_DATE
, PVPP.RELATED_PARTNER_ID
, PVPP.MAX_USERS
, INTERNAL.STATUS
, PARTNER.STATUS
, HZR.STATUS
, HZR.DIRECTIONAL_FLAG
, HZOP_PRT.INTERNAL_FLAG
, PVPP.PARTNER_PARTY_ID
, DECODE(PEAV.ATTR_VALUE
, 'VAD'
, 'Y'
, 'N')
FROM HZ_ORGANIZATION_PROFILES HZOP_PRT
, PV_ENTY_ATTR_VALUES PEAV
, HZ_PARTIES PARTNER
, HZ_ORGANIZATION_PROFILES HZOP
, HZ_PARTIES INTERNAL
, HZ_RELATIONSHIPS HZR
, PV_PARTNER_PROFILES PVPP
, JTF_RS_RESOURCE_EXTNS JRES
WHERE HZR.PARTY_ID = PVPP.PARTNER_ID
AND HZR.OBJECT_ID = INTERNAL.PARTY_ID
AND HZR.SUBJECT_ID = PVPP.PARTNER_PARTY_ID
AND HZR.SUBJECT_ID = PARTNER.PARTY_ID
AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HZR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HZR.SUBJECT_TYPE = 'ORGANIZATION'
AND HZR.OBJECT_TYPE = 'ORGANIZATION'
AND HZR.RELATIONSHIP_TYPE IN ('PARTNER'
, 'PARTNER_MANAGED_CUSTOMER')
AND INTERNAL.PARTY_TYPE='ORGANIZATION'
AND PARTNER.PARTY_TYPE ='ORGANIZATION'
AND HZOP.PARTY_ID = INTERNAL.PARTY_ID
AND HZOP.EFFECTIVE_END_DATE IS NULL
AND JRES.SOURCE_ID(+) = PVPP.PARTNER_ID
AND JRES.CATEGORY(+) = 'PARTNER'
AND (JRES.START_DATE_ACTIVE IS NULL OR JRES.START_DATE_ACTIVE <= SYSDATE)
AND (JRES.END_DATE_ACTIVE IS NULL OR JRES.END_DATE_ACTIVE >= SYSDATE)
AND INTERNAL.STATUS IN ('A'
, 'I')
AND PARTNER.STATUS IN ('A'
, 'I')
AND HZR.STATUS IN ('A'
, 'I')
AND HZOP_PRT.PARTY_ID = PARTNER.PARTY_ID
AND HZOP_PRT.EFFECTIVE_END_DATE IS NULL
AND PEAV.ENTITY_ID(+) = HZR.PARTY_ID
AND PEAV.ENTITY(+) = 'PARTNER'
AND PEAV.ATTRIBUTE_ID(+) = 3
AND PEAV.ATTR_VALUE(+) = 'VAD'
AND PEAV.LATEST_FLAG(+) = 'Y'

Columns