[Home] [Help]
View: 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
Name |
DQORG_CONTACT_ID |
DQSUBJECT_ID |
DQRELATIONSHIP_CODE |
DQSTART_DATE |
DQEND_DATE |
DQCOMMENTS |
DQPARTY_NAME |
DQPARTY_TYPE |