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.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_CONTACT_POINTS

Line 592: select /+ leading(cpi_cosr) use_nl(asg, ps_mosr, cp_mosr, hz_cpt_pri) index(hz_cpt_pri, hz_contact_points_n6) index(asg, hz_imp_addresses_sg_n2) /

588: PRIMARY_FLAG,
589: CONTACT_POINT_TYPE
590: )
591: (
592: select /*+ leading(cpi_cosr) use_nl(asg, ps_mosr, cp_mosr, hz_cpt_pri) index(hz_cpt_pri, hz_contact_points_n6) index(asg, hz_imp_addresses_sg_n2) */
593: cpi_cosr.pid party_id, cpi_cosr.pos party_os, cpi_cosr.posr,
594: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
595: cpi_cosr.int_row_id,
596: nvl2(cp_mosr.owner_table_id, decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,

Line 597: nvl(nvl2(cpi_cosr.owning_pty_chg_flag,null,cp_mosr.owner_table_id),hz_contact_points_s.nextval) cp_id,

593: cpi_cosr.pid party_id, cpi_cosr.pos party_os, cpi_cosr.posr,
594: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
595: cpi_cosr.int_row_id,
596: nvl2(cp_mosr.owner_table_id, decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,
597: nvl(nvl2(cpi_cosr.owning_pty_chg_flag,null,cp_mosr.owner_table_id),hz_contact_points_s.nextval) cp_id,
598: -- nvl(cp_mosr.owner_table_id, hz_contact_points_s.nextval) cp_id, -- Bug6082657
599: nvl2(nullif(ps_mosr.party_id,cpi_cosr.pid), 2, null) error_flag,
600: cpi_cosr.party_action_flag party_action_flag,
601: decode(cpi_cosr.old_posr, null, cpi_cosr.new_cosr, cpi_cosr.old_posr ||

Line 598: -- nvl(cp_mosr.owner_table_id, hz_contact_points_s.nextval) cp_id, -- Bug6082657

594: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
595: cpi_cosr.int_row_id,
596: nvl2(cp_mosr.owner_table_id, decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,
597: nvl(nvl2(cpi_cosr.owning_pty_chg_flag,null,cp_mosr.owner_table_id),hz_contact_points_s.nextval) cp_id,
598: -- nvl(cp_mosr.owner_table_id, hz_contact_points_s.nextval) cp_id, -- Bug6082657
599: nvl2(nullif(ps_mosr.party_id,cpi_cosr.pid), 2, null) error_flag,
600: cpi_cosr.party_action_flag party_action_flag,
601: decode(cpi_cosr.old_posr, null, cpi_cosr.new_cosr, cpi_cosr.old_posr ||
602: substr(cpi_cosr.new_cosr, instr(cpi_cosr.new_cosr, '-'))) old_cp_osr,

Line 617: hz_contact_points hz_cpt_pri,

613: cp_mosr.owner_table_id nulls last), 1, 'Y', null) ) primary_flag,
614: cpi_cosr.contact_point_type
615: from hz_imp_addresses_sg asg,
616: hz_imp_osr_change addr_osr_ch_tbl,
617: hz_contact_points hz_cpt_pri,
618: hz_orig_sys_references ps_mosr,
619: hz_orig_sys_references cp_mosr,
620: (
621: select /*+ no_merge leading(cp_int) index_asc(cp_int) use_hash(psg) use_nl(mosr) */

Line 677: and cp_mosr.owner_table_name (+) = 'HZ_CONTACT_POINTS'

673: cpi_cosr.new_cosr, '-'))) = cp_mosr.orig_system_reference (+)
674: and cpi_cosr.cos = cp_mosr.orig_system (+)
675: and ps_mosr.owner_table_name (+) = 'HZ_PARTY_SITES'
676: and ps_mosr.status (+) = 'A'
677: and cp_mosr.owner_table_name (+) = 'HZ_CONTACT_POINTS'
678: and cp_mosr.status (+) = 'A'
679: and hz_cpt_pri.owner_table_name (+) = 'HZ_PARTIES'
680: and hz_cpt_pri.owner_table_id (+) = cpi_cosr.pid
681: and hz_cpt_pri.contact_point_type (+) = cpi_cosr.contact_point_type

Line 705: select /+ leading(cpi_cosr) use_nl(asg, ps_mosr, cp_mosr, hz_cpt_pri) index(hz_cpt_pri, hz_contact_points_n6) index(asg, hz_imp_addresses_sg_n2) /

701: PRIMARY_FLAG,
702: CONTACT_POINT_TYPE
703: )
704: (
705: select /*+ leading(cpi_cosr) use_nl(asg, ps_mosr, cp_mosr, hz_cpt_pri) index(hz_cpt_pri, hz_contact_points_n6) index(asg, hz_imp_addresses_sg_n2) */
706: cpi_cosr.pid party_id, cpi_cosr.pos party_os, cpi_cosr.posr,
707: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
708: cpi_cosr.int_row_id,
709: nvl2(cp_mosr.owner_table_id,decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,

Line 710: nvl(nvl2(cpi_cosr.owning_pty_chg_flag,null,cp_mosr.owner_table_id),hz_contact_points_s.nextval) cp_id,

706: cpi_cosr.pid party_id, cpi_cosr.pos party_os, cpi_cosr.posr,
707: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
708: cpi_cosr.int_row_id,
709: nvl2(cp_mosr.owner_table_id,decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,
710: nvl(nvl2(cpi_cosr.owning_pty_chg_flag,null,cp_mosr.owner_table_id),hz_contact_points_s.nextval) cp_id,
711: -- nvl(cp_mosr.owner_table_id, hz_contact_points_s.nextval) cp_id, --Bug6082657
712: nvl2(nullif(ps_mosr.party_id,cpi_cosr.pid), 2, null) error_flag,
713: cpi_cosr.party_action_flag party_action_flag,
714: decode(cpi_cosr.old_posr, null, cpi_cosr.new_cosr, cpi_cosr.old_posr ||

Line 711: -- nvl(cp_mosr.owner_table_id, hz_contact_points_s.nextval) cp_id, --Bug6082657

707: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
708: cpi_cosr.int_row_id,
709: nvl2(cp_mosr.owner_table_id,decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,
710: nvl(nvl2(cpi_cosr.owning_pty_chg_flag,null,cp_mosr.owner_table_id),hz_contact_points_s.nextval) cp_id,
711: -- nvl(cp_mosr.owner_table_id, hz_contact_points_s.nextval) cp_id, --Bug6082657
712: nvl2(nullif(ps_mosr.party_id,cpi_cosr.pid), 2, null) error_flag,
713: cpi_cosr.party_action_flag party_action_flag,
714: decode(cpi_cosr.old_posr, null, cpi_cosr.new_cosr, cpi_cosr.old_posr ||
715: substr(cpi_cosr.new_cosr, instr(cpi_cosr.new_cosr, '-'))) old_cp_osr,

Line 730: hz_contact_points hz_cpt_pri,

726: cp_mosr.owner_table_id nulls last), 1, 'Y', null) ) primary_flag,
727: cpi_cosr.contact_point_type
728: from hz_imp_addresses_sg asg,
729: hz_imp_osr_change addr_osr_ch_tbl,
730: hz_contact_points hz_cpt_pri,
731: hz_orig_sys_references ps_mosr,
732: hz_orig_sys_references cp_mosr,
733: (
734: select /*+ no_merge leading(cp_int) index_asc(cp_int) use_hash(psg) use_nl(mosr) */

Line 790: and cp_mosr.owner_table_name (+) = 'HZ_CONTACT_POINTS'

786: cpi_cosr.new_cosr, '-'))) = cp_mosr.orig_system_reference (+)
787: and cpi_cosr.cos = cp_mosr.orig_system (+)
788: and ps_mosr.owner_table_name (+) = 'HZ_PARTY_SITES'
789: and ps_mosr.status (+) = 'A'
790: and cp_mosr.owner_table_name (+) = 'HZ_CONTACT_POINTS'
791: and cp_mosr.status (+) = 'A'
792: and hz_cpt_pri.owner_table_name (+) = 'HZ_PARTIES'
793: and hz_cpt_pri.owner_table_id (+) = cpi_cosr.pid
794: and hz_cpt_pri.contact_point_type (+) = cpi_cosr.contact_point_type