View: HZ_DQM_RE_P_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_DQM_RE_P_V

View Text

SELECT O.ORG_CONTACT_ID DQORG_CONTACT_ID
, R.SUBJECT_ID DQSUBJECT_ID
, H.MEANING DQRELATIONSHIP_CODE
, R.START_DATE DQSTART_DATE
, R.END_DATE DQEND_DATE
, R.COMMENTS DQCOMMENTS
, P.PARTY_NAME DQPARTY_NAME
, H1.MEANING DQPARTY_TYPE
FROM HZ_RELATIONSHIPS R
, HZ_PARTIES P
, HZ_ORG_CONTACTS O
, HZ_MATCHED_CONTACTS_GT G
, AR_LOOKUPS H
, AR_LOOKUPS H1
WHERE R.OBJECT_ID = P.PARTY_ID
AND R.DIRECTIONAL_FLAG = 'B'
AND O.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
AND NVL(R.END_DATE
, SYSDATE) >= SYSDATE
AND O.ORG_CONTACT_ID = G.ORG_CONTACT_ID(+)
AND G.SEARCH_CONTEXT_ID(+) = ARH_DQM_TREE_HELPER.CTXMAX
AND H.LOOKUP_TYPE(+) = 'PARTY_RELATIONS_TYPE'
AND H.LOOKUP_CODE(+) = R.RELATIONSHIP_CODE
AND H1.LOOKUP_TYPE(+) = 'PARTY_TYPE'
AND H1.LOOKUP_CODE(+) = P.PARTY_TYPE ORDER BY DECODE(G.SCORE
, NULL
, -1
, G.SCORE) DESC

Columns