DBA Data[Home] [Help]

APPS.ARH_DQM_TREE dependencies on HZ_CONTACT_POINTS

Line 454: hz_contact_points ctpt

450: 'PHONE', DECODE(ctpt.phone_area_code,NULL,NULL,ctpt.phone_area_code||'-')||ctpt.phone_number,
451: 'TELEX', ctpt.telex_number,
452: 'WEB', ctpt.url ) ad
453: FROM hz_matched_cpts_gt gcpt,
454: hz_contact_points ctpt
455: WHERE gcpt.search_context_id = i_ctx_id
456: AND gcpt.party_id = i_party_id
457: AND NVL(gcpt.score,0) >= 0
458: AND ctpt.owner_table_name = 'HZ_PARTIES'

Line 474: hz_contact_points ctpt

470: 'PHONE', DECODE(ctpt.phone_area_code,NULL,NULL,ctpt.phone_area_code||'-')||ctpt.phone_number,
471: 'TLX' , ctpt.telex_number,
472: 'WEB' , ctpt.url ) ad
473: FROM hz_matched_cpts_gt gcpt,
474: hz_contact_points ctpt
475: WHERE gcpt.search_context_id = i_ctx_id
476: AND gcpt.party_id = i_party_id
477: AND NVL(gcpt.score,0) >= 0
478: AND ctpt.owner_table_name = 'HZ_PARTIES'

Line 556: hz_contact_points ctpt

552: 'PHONE', DECODE(ctpt.phone_area_code,NULL,NULL,ctpt.phone_area_code||'-')||ctpt.phone_number,
553: 'TELEX', ctpt.telex_number,
554: 'WEB', ctpt.url ) ad
555: FROM hz_matched_cpts_gt gcpt,
556: hz_contact_points ctpt
557: WHERE gcpt.search_context_id = i_ctx_id
558: AND gcpt.party_id = i_party_id
559: AND NVL(gcpt.score,0) >= 0
560: AND ctpt.owner_table_name = 'HZ_PARTY_SITES'