TICKET_ISSUES

Columns

Query:

select
   ti.*,         -- FIX THIS IN PROD no select star
   to_char(ti.last_modified, 'mm/dd/yy') as modification_mdy,
   to_char(ti.posting_time, 'mm/dd/yy') as creation_mdy,
   to_char(ti.closed_date, 'mm/dd/yy') as close_mdy,
   to_char(ti.deadline, 'mm/dd/yy') as deadline_mdy,
   to_char(trunc(sysdate - deadline)) as pastdue_days,
    sev.code as severity, sev.code_seq as severity_seq, sev.code_long as severity_long,
    pri.code as priority, pri.code_seq as priority_seq, pri.code_long as priority_long,
    stat.code as status, stat.code_seq as status_seq, stat.code_long as status_long,
    src.code as source, src.code_seq as source_seq, src.code_long as source_long,
    def.code as cause, def.code_seq as cause_seq, def.code_long as cause_long,
    type.code as ticket_type, type.code_seq as ticket_type_seq, type.code_long as ticket_type_long,
    tsi.status_class, tsi.status_subclass, tsi.responsibility
  from
    ticket_issues_i ti,
    ticket_codes_i sev,
    ticket_codes_i pri,
    ticket_codes_i stat,
    ticket_codes_i src,
    ticket_codes_i def,
    ticket_codes_i type,
    ticket_status_info tsi
  where
        sev.code_id(+) = ti.severity_id
    and pri.code_id(+) = ti.priority_id
    and stat.code_id(+) = ti.status_id
    and src.code_id(+) = ti.source_id
    and def.code_id(+) = ti.cause_id
    and type.code_id(+) = ti.ticket_type_id
    and tsi.code_id(+) = ti.status_id