APPS.AMS_PHONE_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

  select phone_number
  from hz_contact_points
  where owner_table_id = c_party_id
    and owner_table_name = 'HZ_PARTIES'
  order by creation_date;

Line: 121

  select raw_phone_number
  from hz_contact_points
  where owner_table_id = c_party_id
    and owner_table_name = 'HZ_PARTIES'
  order by creation_date;

Line: 177

  select creation_date
  from hz_contact_points
  where owner_table_id = c_party_id
    and owner_table_name = 'HZ_PARTIES'
  order by creation_date;