APPS.MRP_CL_FUNCTION dependencies on HZ_PARTY_SITES

Line 2164: HZ_PARTY_SITES l

2160: from
2161: wsh_region_locations wrl,
2162: wsh_zone_regions z,
2163: wsh_regions_v a ,
2164: HZ_PARTY_SITES l
2165: where wrl.region_id = z.region_id
2166: and z.parent_region_id = a.region_id
2167: and a.region_type = 10
2168: and wrl.location_id = l.location_id

Line 2212: and nvl(mib.install_location_type_code,mib.location_type_code) = 'HZ_PARTY_SITES';

2208: and mib.instance_usage_code = 'OUT_OF_ENTERPRISE'
2209: and mib.install_date is not null
2210: and( mib.active_end_date is null or mib.active_end_date >=orig_st_date)
2211: and mib.owner_party_source_table = 'HZ_PARTIES'
2212: and nvl(mib.install_location_type_code,mib.location_type_code) = 'HZ_PARTY_SITES';
2213:
2214:
2215: lv_purge_flag VARCHAR2(1);
2216: x_return_status VARCHAR2(10);