APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_PARTY_SITE_USES

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

2624: )
2625: (
2626: select /*+ leading(addruse_w_id) use_nl(hz_psuse) */
2627: addruse_w_id.site_use_type, pos, posr,
2628: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)
2629: siteusr_id, addruse_w_id.site_id, addruse_w_id.int_row_id,
2630: nvl2(hz_psuse.party_site_use_id, 'U', 'I') action_flag,
2631: decode(addruse_w_id.addr_action_flag, 'I', decode(
2632: addruse_w_id.party_id, addruse_w_id.addr_party_id, null, 2), null)

Line 2640: hz_party_site_uses hz_ps_use

2636: addruse_w_id.primary_flag) desc nulls last,
2637: hz_psuse.party_site_use_id nulls last), 1, decode((
2638: select count(*)
2639: from hz_party_sites hz_ps,
2640: hz_party_site_uses hz_ps_use
2641: where hz_ps.party_id = addruse_w_id.party_id
2642: and hz_ps.party_site_id = hz_ps_use.party_site_id
2643: and hz_ps_use.site_use_type = addruse_w_id.site_use_type
2644: and hz_ps_use.primary_per_type = 'Y'

Line 2647: from hz_party_site_uses hz_psuse,

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

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

2705: )
2706: (
2707: select /*+ leading(addruse_w_id) use_nl(hz_psuse) */
2708: addruse_w_id.site_use_type, pos, posr,
2709: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)
2710: siteusr_id, addruse_w_id.site_id, addruse_w_id.int_row_id,
2711: nvl2(hz_psuse.party_site_use_id, 'U', 'I') action_flag,
2712: decode(addruse_w_id.addr_action_flag, 'I', decode(
2713: addruse_w_id.party_id, addruse_w_id.addr_party_id, null, 2), null)

Line 2721: hz_party_site_uses hz_ps_use

2717: addruse_w_id.primary_flag) desc nulls last,
2718: hz_psuse.party_site_use_id nulls last), 1, decode((
2719: select count(*)
2720: from hz_party_sites hz_ps,
2721: hz_party_site_uses hz_ps_use
2722: where hz_ps.party_id = addruse_w_id.party_id
2723: and hz_ps.party_site_id = hz_ps_use.party_site_id
2724: and hz_ps_use.site_use_type = addruse_w_id.site_use_type
2725: and hz_ps_use.primary_per_type = 'Y'

Line 2728: from hz_party_site_uses hz_psuse,

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