APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_PARTY_SITE_USES

Line 2658: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)

2654: )
2655: (
2656: select /*+ leading(addruse_w_id) use_nl(hz_psuse) */
2657: addruse_w_id.site_use_type, pos, posr,
2658: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)
2659: siteusr_id, addruse_w_id.site_id, addruse_w_id.int_row_id,
2660: nvl2(hz_psuse.party_site_use_id, 'U', 'I') action_flag,
2661: decode(addruse_w_id.addr_action_flag, 'I', decode(
2662: addruse_w_id.party_id, addruse_w_id.addr_party_id, null, 2), null)

Line 2670: hz_party_site_uses hz_ps_use

2666: addruse_w_id.primary_flag) desc nulls last,
2667: hz_psuse.party_site_use_id nulls last), 1, decode((
2668: select count(*)
2669: from hz_party_sites hz_ps,
2670: hz_party_site_uses hz_ps_use
2671: where hz_ps.party_id = addruse_w_id.party_id
2672: and hz_ps.party_site_id = hz_ps_use.party_site_id
2673: and hz_ps_use.site_use_type = addruse_w_id.site_use_type
2674: and hz_ps_use.primary_per_type = 'Y'

Line 2677: from hz_party_site_uses hz_psuse,

2673: and hz_ps_use.site_use_type = addruse_w_id.site_use_type
2674: and hz_ps_use.primary_per_type = 'Y'
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,

Line 2739: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)

2735: )
2736: (
2737: select /*+ leading(addruse_w_id) use_nl(hz_psuse) */
2738: addruse_w_id.site_use_type, pos, posr,
2739: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)
2740: siteusr_id, addruse_w_id.site_id, addruse_w_id.int_row_id,
2741: nvl2(hz_psuse.party_site_use_id, 'U', 'I') action_flag,
2742: decode(addruse_w_id.addr_action_flag, 'I', decode(
2743: addruse_w_id.party_id, addruse_w_id.addr_party_id, null, 2), null)

Line 2751: hz_party_site_uses hz_ps_use

2747: addruse_w_id.primary_flag) desc nulls last,
2748: hz_psuse.party_site_use_id nulls last), 1, decode((
2749: select count(*)
2750: from hz_party_sites hz_ps,
2751: hz_party_site_uses hz_ps_use
2752: where hz_ps.party_id = addruse_w_id.party_id
2753: and hz_ps.party_site_id = hz_ps_use.party_site_id
2754: and hz_ps_use.site_use_type = addruse_w_id.site_use_type
2755: and hz_ps_use.primary_per_type = 'Y'

Line 2758: from hz_party_site_uses hz_psuse,

2754: and hz_ps_use.site_use_type = addruse_w_id.site_use_type
2755: and hz_ps_use.primary_per_type = 'Y'
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,