VIEW: APPS.PV_PARTNERS_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 , 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'

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
, 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'