APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_PARTY_SITES

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

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

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

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

Line 151: From hz_party_sites hps1,

147:
148: cursor c_bill_ship_sites(p_party_id number) is
149: select hps1.party_site_id billto_site_id,
150: hps2.party_site_id shipto_site_id
151: From hz_party_sites hps1,
152: hz_party_sites hps2,
153: hz_party_site_uses hpsu1,
154: hz_party_site_uses hpsu2
155: Where hps1.party_id = p_party_id

Line 152: hz_party_sites hps2,

148: cursor c_bill_ship_sites(p_party_id number) is
149: select hps1.party_site_id billto_site_id,
150: hps2.party_site_id shipto_site_id
151: From hz_party_sites hps1,
152: hz_party_sites hps2,
153: hz_party_site_uses hpsu1,
154: hz_party_site_uses hpsu2
155: Where hps1.party_id = p_party_id
156: and hpsu1.party_site_id = hps1.party_site_id

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

223:
224: This resolves bug 4012520
225: */
226: CURSOR c_get_hz_location_csr IS
227: SELECT location_id from HZ_PARTY_SITES WHERE party_site_id = l_ump_rec.location_id;
228:
229: l_hz_location_id NUMBER;
230:
231:

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

343:
344: This resolves bug 4012520
345: */
346: IF (l_ump_rec.location_type_code is not null and
347: l_ump_rec.location_type_code = 'HZ_PARTY_SITES') THEN
348:
349: l_service_request_rec.incident_location_id :=l_ump_rec.location_id;
350: l_service_request_rec.incident_location_type :='HZ_PARTY_SITE';
351:

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

602: Then
603:
604: --decide if we pass p_address_id or p_location_id
605: IF (l_ump_rec.location_type_code is not null and
606: l_ump_rec.location_type_code = 'HZ_PARTY_SITES') Then
607:
608: l_address_id_to_pass := l_ump_rec.location_id;
609: l_location_id_to_pass := null;
610: END IF;

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

761: l_acchrs_found := true;
762: END IF;
763: close c_acchrs_location_csr;
764:
765: ELSIF(l_ump_rec.location_type_code = 'HZ_PARTY_SITES') THEN
766: l_acchr_ct_site_id := l_ump_rec.location_id;
767:
768: OPEN c_acchrs_ctsite_csr;
769: FETCH c_acchrs_ctsite_csr INTO l_acchrs_setups_rec;