APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_PARTY_SITES

Line 63: -- get install location only if type code is hz_party_sites or hz_locations

59: csi.instance_number,
60: csi.inventory_item_id,
61: csi.last_vld_organization_id,
62: csi.serial_number,
63: -- get install location only if type code is hz_party_sites or hz_locations
64: -- for SR validation
65: decode(csi.location_type_code,'HZ_PARTY_SITES',
66: csi.location_id,'HZ_LOCATIONS',
67: csi.location_id,null) location_id,

Line 65: decode(csi.location_type_code,'HZ_PARTY_SITES',

61: csi.last_vld_organization_id,
62: csi.serial_number,
63: -- get install location only if type code is hz_party_sites or hz_locations
64: -- for SR validation
65: decode(csi.location_type_code,'HZ_PARTY_SITES',
66: csi.location_id,'HZ_LOCATIONS',
67: csi.location_id,null) location_id,
68: csi.location_type_code,
69: csi.owner_party_account_id,

Line 161: From hz_party_sites hps1,

157:
158: cursor c_bill_ship_sites(p_party_id number) is
159: select hps1.party_site_id billto_site_id,
160: hps2.party_site_id shipto_site_id
161: From hz_party_sites hps1,
162: hz_party_sites hps2,
163: hz_party_site_uses hpsu1,
164: hz_party_site_uses hpsu2
165: Where hps1.party_id = p_party_id

Line 162: hz_party_sites hps2,

158: cursor c_bill_ship_sites(p_party_id number) is
159: select hps1.party_site_id billto_site_id,
160: hps2.party_site_id shipto_site_id
161: From hz_party_sites hps1,
162: hz_party_sites hps2,
163: hz_party_site_uses hpsu1,
164: hz_party_site_uses hpsu2
165: Where hps1.party_id = p_party_id
166: and hpsu1.party_site_id = hps1.party_site_id

Line 250: SELECT location_id from HZ_PARTY_SITES WHERE party_site_id = l_ump_rec.location_id;

246:
247: This resolves bug 4012520
248: */
249: CURSOR c_get_hz_location_csr IS
250: SELECT location_id from HZ_PARTY_SITES WHERE party_site_id = l_ump_rec.location_id;
251:
252: l_hz_location_id NUMBER;
253:
254:

Line 382: l_ump_rec.location_type_code = 'HZ_PARTY_SITES') THEN

378:
379: This resolves bug 4012520
380: */
381: IF (l_ump_rec.location_type_code is not null and
382: l_ump_rec.location_type_code = 'HZ_PARTY_SITES') THEN
383:
384: l_service_request_rec.incident_location_id :=l_ump_rec.location_id;
385: l_service_request_rec.incident_location_type :='HZ_PARTY_SITE';
386:

Line 643: l_ump_rec.location_type_code = 'HZ_PARTY_SITES') Then

639: Then
640:
641: --decide if we pass p_address_id or p_location_id
642: IF (l_ump_rec.location_type_code is not null and
643: l_ump_rec.location_type_code = 'HZ_PARTY_SITES') Then
644:
645: l_address_id_to_pass := l_ump_rec.location_id;
646: l_location_id_to_pass := null;
647: END IF;

Line 805: ELSIF(l_ump_rec.location_type_code = 'HZ_PARTY_SITES') THEN

801: l_acchrs_found := true;
802: END IF;
803: close c_acchrs_location_csr;
804:
805: ELSIF(l_ump_rec.location_type_code = 'HZ_PARTY_SITES') THEN
806: l_acchr_ct_site_id := l_ump_rec.location_id;
807:
808: OPEN c_acchrs_ctsite_csr;
809: FETCH c_acchrs_ctsite_csr INTO l_acchrs_setups_rec;