[Home] [Help]
| Product: | OKI - Contracts Intelligence (Obsolete) |
|---|---|
| Description: | Contact point (email, phone, and other) information for contract contacts. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CPT.CONTACT_POINT_ID
, SHD.CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, CPT.CONTACT_POINT_TYPE
, CPT.OWNER_TABLE_ID CONTACT_ID
, CPT.EMAIL_FORMAT
, CPT.EMAIL_ADDRESS
, CPT.PHONE_LINE_TYPE PHONE_TYPE
, ALP.MEANING PHONE_TYPE_MEANING
, CPT.PHONE_COUNTRY_CODE
, CPT.PHONE_AREA_CODE
, CPT.PHONE_NUMBER
, CPT.PHONE_EXTENSION
, CPT.PRIMARY_FLAG
, CPT.CREATION_DATE
, CPT.LAST_UPDATE_DATE
FROM HZ_CONTACT_POINTS CPT
, AR_LOOKUPS ALP
, OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
WHERE ALP.LOOKUP_TYPE = 'PHONE_LINE_TYPE'
AND ALP.LOOKUP_CODE = CPT.PHONE_LINE_TYPE
AND NVL(CPT.DO_NOT_USE_FLAG
, 'N') = 'N'
AND CPT.STATUS = 'A'
AND CPT.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CPT.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND CPT.OWNER_TABLE_ID = CTT.OBJECT1_ID1
AND CTT.DNZ_CHR_ID = SHD.CHR_ID