Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
SQL How to identify when a supplier in Oracle is changed from inactive to active ? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
37
Views
3
Comments
edited Jan 28, 2023 12:12AM in Supplier Management 3 comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!