oracle8.1.6
select bt_patches.patch_id,
bt_patches.patch_number,
bt_patches.project_id,
bt_patches.component_id,
bt_patches.summary,
bt_patches.content,
bt_patches.generated_from_version,
bt_patches.apply_to_version,
bt_patches.applied_to_version,
bt_patches.status,
bt_components.component_name,
acs_objects.creation_user as submitter_user_id,
submitter.first_names as submitter_first_names,
submitter.last_name as submitter_last_name,
submitter.email as submitter_email,
acs_objects.creation_date,
to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
to_char(sysdate, 'fmMM/DDfm/YYYY') as now_pretty
from bt_patches,
acs_objects,
cc_users submitter,
bt_components
where bt_patches.patch_number = :patch_number
and bt_patches.project_id = :package_id
and bt_patches.patch_id = acs_objects.object_id
and bt_patches.component_id = bt_components.component_id
and submitter.user_id = acs_objects.creation_user