VIEW: APPS.HZ_DQM_RE_P_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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