View: AST_PTR_RELATION_DETAILS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_PTR_RELATION_DETAILS_V

View Text

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

Columns