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_IMP_ADDRESSES_SG

Line 299: into hz_imp_addresses_sg

295: -- re-run
296: insert all
297: when ( 1 = 1 )
298: then
299: into hz_imp_addresses_sg
300: (
301: PARTY_ID,
302: party_orig_system,
303: PARTY_ORIG_SYSTEM_REFERENCE,

Line 429: into hz_imp_addresses_sg

425: -- first run
426: insert all
427: when ( 1 = 1 )
428: then
429: into hz_imp_addresses_sg
430: (
431: PARTY_ID,
432: party_orig_system,
433: PARTY_ORIG_SYSTEM_REFERENCE,

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 613: from hz_imp_addresses_sg asg,

609: null,cpi_cosr.primary_flag
610: ) desc nulls last,
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,

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 724: from hz_imp_addresses_sg asg,

720: null,cpi_cosr.primary_flag
721: ) desc nulls last,
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,

Line 2649: select /*+ no_merge ordered index_asc(addruse_int) index(addr_sg,HZ_IMP_ADDRESSES_SG_N2)

2645: and hz_ps_use.status = 'A'
2646: and rownum < 2), 0, 'Y')) primary_flag
2647: from hz_party_site_uses hz_psuse,
2648: (
2649: select /*+ no_merge ordered index_asc(addruse_int) index(addr_sg,HZ_IMP_ADDRESSES_SG_N2)
2650: use_nl(addr_sg,addr_mosr,party_mosr) use_hash(party_sg) */
2651: addruse_int.party_orig_system pos,
2652: addruse_int.party_orig_system_reference posr,
2653: nvl(addr_sg.party_site_id, addr_mosr.owner_table_id)

Line 2661: hz_imp_addresses_sg addr_sg,

2657: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2658: addruse_int.primary_flag
2659: from hz_imp_addressuses_int addruse_int,
2660: hz_imp_parties_sg party_sg,
2661: hz_imp_addresses_sg addr_sg,
2662: hz_orig_sys_references addr_mosr,
2663: hz_orig_sys_references party_mosr
2664: where addruse_int.batch_id = P_BATCH_ID
2665: and addruse_int.party_orig_system = P_OS

Line 2730: select /*+ no_merge ordered index_asc(addruse_int) index(addr_sg,HZ_IMP_ADDRESSES_SG_N2)

2726: and hz_ps_use.status = 'A'
2727: and rownum < 2), 0, 'Y')) primary_flag
2728: from hz_party_site_uses hz_psuse,
2729: (
2730: select /*+ no_merge ordered index_asc(addruse_int) index(addr_sg,HZ_IMP_ADDRESSES_SG_N2)
2731: use_nl(addr_sg,addr_mosr,party_mosr) use_hash(party_sg) */
2732: addruse_int.party_orig_system pos,
2733: addruse_int.party_orig_system_reference posr,
2734: nvl(addr_sg.party_site_id, addr_mosr.owner_table_id)

Line 2742: hz_imp_addresses_sg addr_sg,

2738: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2739: addruse_int.primary_flag
2740: from hz_imp_addressuses_int addruse_int,
2741: hz_imp_parties_sg party_sg,
2742: hz_imp_addresses_sg addr_sg,
2743: hz_orig_sys_references addr_mosr,
2744: hz_orig_sys_references party_mosr
2745: where addruse_int.batch_id = P_BATCH_ID
2746: and addruse_int.party_orig_system = P_OS