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 590: 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) /

586: PRIMARY_FLAG,
587: CONTACT_POINT_TYPE
588: )
589: (
590: 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) */
591: cpi_cosr.pid party_id, cpi_cosr.pos party_os, cpi_cosr.posr,
592: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
593: cpi_cosr.int_row_id,
594: nvl2(cp_mosr.owner_table_id, decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,

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

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

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

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

Line 615: hz_contact_points hz_cpt_pri,

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

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

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

Line 701: 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) /

697: PRIMARY_FLAG,
698: CONTACT_POINT_TYPE
699: )
700: (
701: 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) */
702: cpi_cosr.pid party_id, cpi_cosr.pos party_os, cpi_cosr.posr,
703: nvl(nvl(asg.party_site_id, addr_osr_ch_tbl.entity_id), ps_mosr.owner_table_id) site_id,
704: cpi_cosr.int_row_id,
705: nvl2(cp_mosr.owner_table_id,decode(cpi_cosr.owning_pty_chg_flag,'Y','I','U'), 'I') action_flag,

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

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

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

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

Line 726: hz_contact_points hz_cpt_pri,

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

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

780: cpi_cosr.new_cosr, '-'))) = cp_mosr.orig_system_reference (+)
781: and cpi_cosr.cos = cp_mosr.orig_system (+)
782: and ps_mosr.owner_table_name (+) = 'HZ_PARTY_SITES'
783: and ps_mosr.status (+) = 'A'
784: and cp_mosr.owner_table_name (+) = 'HZ_CONTACT_POINTS'
785: and cp_mosr.status (+) = 'A'
786: and hz_cpt_pri.owner_table_name (+) = 'HZ_PARTIES'
787: and hz_cpt_pri.owner_table_id (+) = cpi_cosr.pid
788: and hz_cpt_pri.contact_point_type (+) = cpi_cosr.contact_point_type