FND Design Data [Home] [Help]

View: HZ_DQM_PS_CPT_V

Product: AR - Receivables
Description:
Implementation/DBA Data: ViewAPPS.HZ_DQM_PS_CPT_V
View Text

SELECT C.CONTACT_POINT_ID DQCONTACT_POINT_ID
, C.OWNER_TABLE_NAME DQOWNER_TABLE_NAME
, C.OWNER_TABLE_ID DQOWNER_TABLE_ID
, DECODE(C.CONTACT_POINT_TYPE
, 'PHONE'
, H1.MEANING
, H.MEANING) DQCONTACT_POINT_TYPE
, C.PRIMARY_BY_PURPOSE DQPRIMARY_PER_PURPOSE
, C.PRIMARY_FLAG DQPRIMARY_FLAG
, C.STATUS DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, C.STATUS)
, C.STATUS) DQSTATUSM
, DECODE(C.CONTACT_POINT_TYPE
, 'EMAIL'
, C.EMAIL_ADDRESS
, 'PHONE'
, C.RAW_PHONE_NUMBER
, 'TLX'
, C.TELEX_NUMBER
, 'WEB'
, C.URL ) DQCONTACT_INFO
FROM HZ_CONTACT_POINTS C
, HZ_MATCHED_CPTS_GT G
, AR_LOOKUPS H
, AR_LOOKUPS H1
WHERE C.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
AND C.CONTACT_POINT_ID = G.CONTACT_POINT_ID(+)
AND NVL(C.STATUS
, 'A') NOT IN ('M')
AND G.SEARCH_CONTEXT_ID(+) = ARH_DQM_TREE_HELPER.CTXMAX
AND H.LOOKUP_TYPE(+) = 'COMMUNICATION_TYPE'
AND H.LOOKUP_CODE(+) = C.CONTACT_POINT_TYPE
AND H1.LOOKUP_TYPE(+) = 'PHONE_LINE_TYPE'
AND H1.LOOKUP_CODE(+) = C.PHONE_LINE_TYPE ORDER BY DECODE(G.SCORE
, NULL
, -1
, G.SCORE) DESC

Columns

Name
DQCONTACT_POINT_ID
DQOWNER_TABLE_NAME
DQOWNER_TABLE_ID
DQCONTACT_POINT_TYPE
DQPRIMARY_PER_PURPOSE
DQPRIMARY_FLAG
DQSTATUS
DQSTATUSM
DQCONTACT_INFO