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 430: into hz_imp_addresses_sg

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

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

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

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

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

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

2675: and hz_ps_use.status = 'A'
2676: and rownum < 2), 0, 'Y')) primary_flag
2677: from hz_party_site_uses hz_psuse,
2678: (
2679: select /*+ no_merge ordered index_asc(addruse_int) index(addr_sg,HZ_IMP_ADDRESSES_SG_N2)
2680: use_nl(addr_sg,addr_mosr,party_mosr) use_hash(party_sg) */
2681: addruse_int.party_orig_system pos,
2682: addruse_int.party_orig_system_reference posr,
2683: nvl(addr_sg.party_site_id, addr_mosr.owner_table_id)

Line 2691: hz_imp_addresses_sg addr_sg,

2687: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2688: addruse_int.primary_flag
2689: from hz_imp_addressuses_int addruse_int,
2690: hz_imp_parties_sg party_sg,
2691: hz_imp_addresses_sg addr_sg,
2692: hz_orig_sys_references addr_mosr,
2693: hz_orig_sys_references party_mosr
2694: where addruse_int.batch_id = P_BATCH_ID
2695: and addruse_int.party_orig_system = P_OS

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

2756: and hz_ps_use.status = 'A'
2757: and rownum < 2), 0, 'Y')) primary_flag
2758: from hz_party_site_uses hz_psuse,
2759: (
2760: select /*+ no_merge ordered index_asc(addruse_int) index(addr_sg,HZ_IMP_ADDRESSES_SG_N2)
2761: use_nl(addr_sg,addr_mosr,party_mosr) use_hash(party_sg) */
2762: addruse_int.party_orig_system pos,
2763: addruse_int.party_orig_system_reference posr,
2764: nvl(addr_sg.party_site_id, addr_mosr.owner_table_id)

Line 2772: hz_imp_addresses_sg addr_sg,

2768: nvl(addr_sg.action_flag, 'U') addr_action_flag,
2769: addruse_int.primary_flag
2770: from hz_imp_addressuses_int addruse_int,
2771: hz_imp_parties_sg party_sg,
2772: hz_imp_addresses_sg addr_sg,
2773: hz_orig_sys_references addr_mosr,
2774: hz_orig_sys_references party_mosr
2775: where addruse_int.batch_id = P_BATCH_ID
2776: and addruse_int.party_orig_system = P_OS