[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT loc.ROWID row_id,
loc.location_id,
loc.active_start_date,
loc.last_update_date,
loc.last_updated_by,
loc.creation_date,
loc.created_by,
loc.last_update_login,
loc.location_park_id,
loc.location_type_lookup_code,
loc.location_code,
loc.location_alias,
loc.building,
loc.lease_or_owned,
loc.floor,
loc.office,
loc.address_id,
loc.max_capacity,
loc.optimum_capacity,
loc.rentable_area,
loc.usable_area,
loc.allocate_cost_center_code,
loc.uom_code,
loc.description,
loc.parent_location_id,
loc.interface_flag,
loc.request_id,
loc.program_application_id,
loc.program_id,
loc.program_update_date,
loc.status,
loc.space_type_lookup_code,
loc.attribute_category,
loc.attribute1,
loc.attribute2,
loc.attribute3,
loc.attribute4,
loc.attribute5,
loc.attribute6,
loc.attribute7,
loc.attribute8,
loc.attribute9,
loc.attribute10,
loc.attribute11,
loc.attribute12,
loc.attribute13,
loc.attribute14,
loc.attribute15,
loc.source,
loc.property_id,
loc.class,
loc.status_type,
loc.suite,
loc.gross_area,
loc.assignable_area,
loc.common_area,
loc.common_area_flag,
loc.function_type_lookup_code,
loc.standard_type_lookup_code
FROM pn_locations loc /*sdm?? Location Code lies in a range*/
WHERE loc.location_type_lookup_code = p_loc_type
AND loc.location_code BETWEEN p_loc_code_low and p_loc_code_high;
SELECT cld.ROWID row_id,
cld.location_id,
cld.last_update_date,
cld.last_updated_by,
cld.creation_date,
cld.created_by,
cld.last_update_login,
cld.location_park_id,
cld.location_type_lookup_code,
cld.location_code,
cld.location_alias,
cld.building,
cld.lease_or_owned,
cld.floor,
cld.office,
cld.address_id,
cld.max_capacity,
cld.optimum_capacity,
cld.rentable_area,
cld.usable_area,
cld.allocate_cost_center_code,
cld.uom_code,
cld.description,
cld.parent_location_id,
cld.interface_flag,
cld.request_id,
cld.program_application_id,
cld.program_id,
cld.program_update_date,
cld.status,
cld.space_type_lookup_code,
cld.attribute_category,
cld.attribute1,
cld.attribute2,
cld.attribute3,
cld.attribute4,
cld.attribute5,
cld.attribute6,
cld.attribute7,
cld.attribute8,
cld.attribute9,
cld.attribute10,
cld.attribute11,
cld.attribute12,
cld.attribute13,
cld.attribute14,
cld.attribute15,
cld.source,
cld.property_id,
cld.class,
cld.status_type,
cld.suite,
cld.gross_area,
cld.assignable_area,
cld.common_area,
cld.common_area_flag,
cld.function_type_lookup_code,
cld.standard_type_lookup_code
FROM pn_locations_all cld /*sdm14jul*/
WHERE cld.location_id <> p_location_id
AND cld.location_id IN (SELECT location_id
FROM pn_locations_all /*sdm14jul*/
START WITH location_id = p_location_id
CONNECT BY PRIOR location_id = parent_location_id
);
UPDATE pn_locations_all
SET status = l_loc_status
WHERE ROWID = child_loc.row_id; /*sdm14jul*/
UPDATE pn_locations_all /*sdm14jul*/
SET status = l_loc_status
WHERE ROWID = actdeact_main.row_id;