VIEW: APPS.OKI_CONTACT_POINTS_V

Source

View Text - Preformatted

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 AR_LOOKUPS ALP,HZ_CONTACT_POINTS CPT,OKC_CONTACTS CTT,OKI_SALES_K_HDRS SHD WHERE alp.lookup_type = 'COMMUNICATION_TYPE' and alp.lookup_code = cpt.contact_point_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 and cpt.primary_flag = 'Y'

View Text - HTML Formatted

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 AR_LOOKUPS ALP
, HZ_CONTACT_POINTS CPT
, OKC_CONTACTS CTT
, OKI_SALES_K_HDRS SHD
WHERE ALP.LOOKUP_TYPE = 'COMMUNICATION_TYPE'
AND ALP.LOOKUP_CODE = CPT.CONTACT_POINT_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
AND CPT.PRIMARY_FLAG = 'Y'