VIEW: APPS.PV_PARTNERS_ALL_V

Source

View Text - Preformatted

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 , HZR.party_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_resource_id , PVPP.partner_group_id , PVPP.partner_resource_number , PVPP.partner_group_number, PVPP.partner_party_id FROM PV_PARTNER_PROFILES PVPP,HZ_PARTIES INTERNAL,HZ_RELATIONSHIPS HZR,HZ_ORGANIZATION_PROFILES HZOP,HZ_PARTIES PARTNER WHERE HZR.party_id = PVPP.partner_id(+) AND HZR.subject_id = PVPP.partner_party_id(+) AND HZR.object_id = INTERNAL.party_id AND HZR.STATUS ='A' AND HZR.start_date <= sysdate AND NVL(HZR.end_date,sysdate) >= sysdate AND HZR.relationship_type IN ('PARTNER','PARTNER_MANAGED_CUSTOMER') 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 INTERNAL.PARTY_TYPE='ORGANIZATION' AND PARTNER.PARTY_TYPE ='ORGANIZATION' AND HZOP.party_id = INTERNAL.party_id AND (PVPP.partner_id IS NOT NULL OR (nvl(HZOP.internal_flag,'N') = 'Y')) AND HZOP.effective_end_date is null

View Text - HTML Formatted

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
, HZR.PARTY_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_RESOURCE_ID
, PVPP.PARTNER_GROUP_ID
, PVPP.PARTNER_RESOURCE_NUMBER
, PVPP.PARTNER_GROUP_NUMBER
, PVPP.PARTNER_PARTY_ID
FROM PV_PARTNER_PROFILES PVPP
, HZ_PARTIES INTERNAL
, HZ_RELATIONSHIPS HZR
, HZ_ORGANIZATION_PROFILES HZOP
, HZ_PARTIES PARTNER
WHERE HZR.PARTY_ID = PVPP.PARTNER_ID(+)
AND HZR.SUBJECT_ID = PVPP.PARTNER_PARTY_ID(+)
AND HZR.OBJECT_ID = INTERNAL.PARTY_ID
AND HZR.STATUS ='A'
AND HZR.START_DATE <= SYSDATE
AND NVL(HZR.END_DATE
, SYSDATE) >= SYSDATE
AND HZR.RELATIONSHIP_TYPE IN ('PARTNER'
, 'PARTNER_MANAGED_CUSTOMER')
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 INTERNAL.PARTY_TYPE='ORGANIZATION'
AND PARTNER.PARTY_TYPE ='ORGANIZATION'
AND HZOP.PARTY_ID = INTERNAL.PARTY_ID
AND (PVPP.PARTNER_ID IS NOT NULL OR (NVL(HZOP.INTERNAL_FLAG
, 'N') = 'Y'))
AND HZOP.EFFECTIVE_END_DATE IS NULL