eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARH_DQM_TREE dependencies on HZ_MATCHED_CPTS_GT

Line 453: FROM hz_matched_cpts_gt gcpt,

449: decode(ctpt.contact_point_type, 'EMAIL', ctpt.email_address,
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

Line 473: FROM hz_matched_cpts_gt gcpt,

469: decode(ctpt.contact_point_type, 'EMAIL', ctpt.email_address,
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

Line 555: FROM hz_matched_cpts_gt gcpt,

551: decode(ctpt.contact_point_type, 'EMAIL', ctpt.email_address,
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