[Home] [Help]
SELECT ptr_prof.partner_id, ptr_lvl.attr_code, ptr_prof.oppty_last_offered_date, ptr_prof.purchase_method, vad_party.party_name, ptr_prof.target_revenue_amt, sub_org_prof.pref_functional_currency, ptr_prof.actual_revenue_amt, sub_org_prof.pref_functional_currency, chnl_mgr_res.source_name, ph_sup_res.source_name, ptr_prof.lead_share_appr_flag, ptr_prof.auto_match_allowed_flag from PV_PARTNER_PROFILES ptr_prof, PV_ATTRIBUTE_CODES_VL ptr_lvl, HZ_RELATIONSHIPS rel, HZ_ORGANIZATION_PROFILES sub_org_prof, HZ_PARTIES vad_party, JTF_RS_RESOURCE_EXTNS chnl_mgr_res, JTF_RS_RESOURCE_EXTNS ph_sup_res WHERE ptr_lvl.attr_code_id(+) = ptr_prof.partner_level and vad_party.party_id(+) = ptr_prof.preferred_vad_id and rel.party_id = ptr_prof.partner_id and rel.directional_flag = 'F' and rel.subject_id = sub_org_prof.party_id and sub_org_prof.effective_end_date is null and chnl_mgr_res.resource_id(+) = ptr_prof.cm_id and ph_sup_res.resource_id(+) = ptr_prof.ph_support_rep
SELECT PTR_PROF.PARTNER_ID
, PTR_LVL.ATTR_CODE
, PTR_PROF.OPPTY_LAST_OFFERED_DATE
, PTR_PROF.PURCHASE_METHOD
, VAD_PARTY.PARTY_NAME
, PTR_PROF.TARGET_REVENUE_AMT
, SUB_ORG_PROF.PREF_FUNCTIONAL_CURRENCY
, PTR_PROF.ACTUAL_REVENUE_AMT
, SUB_ORG_PROF.PREF_FUNCTIONAL_CURRENCY
, CHNL_MGR_RES.SOURCE_NAME
, PH_SUP_RES.SOURCE_NAME
, PTR_PROF.LEAD_SHARE_APPR_FLAG
, PTR_PROF.AUTO_MATCH_ALLOWED_FLAG
FROM PV_PARTNER_PROFILES PTR_PROF
, PV_ATTRIBUTE_CODES_VL PTR_LVL
, HZ_RELATIONSHIPS REL
, HZ_ORGANIZATION_PROFILES SUB_ORG_PROF
, HZ_PARTIES VAD_PARTY
, JTF_RS_RESOURCE_EXTNS CHNL_MGR_RES
, JTF_RS_RESOURCE_EXTNS PH_SUP_RES
WHERE PTR_LVL.ATTR_CODE_ID(+) = PTR_PROF.PARTNER_LEVEL
AND VAD_PARTY.PARTY_ID(+) = PTR_PROF.PREFERRED_VAD_ID
AND REL.PARTY_ID = PTR_PROF.PARTNER_ID
AND REL.DIRECTIONAL_FLAG = 'F'
AND REL.SUBJECT_ID = SUB_ORG_PROF.PARTY_ID
AND SUB_ORG_PROF.EFFECTIVE_END_DATE IS NULL
AND CHNL_MGR_RES.RESOURCE_ID(+) = PTR_PROF.CM_ID
AND PH_SUP_RES.RESOURCE_ID(+) = PTR_PROF.PH_SUPPORT_REP
|
|
|
|