SQL How to identify when a supplier in Oracle is changed from inactive to active ?

Summary:

SQL How to identify when a supplier in Oracle is changed from inactive to active ?

Content (required):

Procurement user needs a way to identify when a supplier in Oracle is changed from inactive to active. Need to identify the date supplier changed from inactive to active.

I have the following SQL but it does not have the information requiered

select AH .*

from

POZ_SUPP_REQUESTS SUP_REQ,

POZ_APPROVAL_HISTORY AH

where AH.FLOW_OBJECT_ID=SUP_REQ.SUPP_REQUEST_ID

and AH.APPROVAL_FLOW_CODE='SPCM'

and SUP_REQ.CHANGE_REQ_NUMBER='159002'

Version (include the version you are using, if applicable):