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

OKC_K_HEADERS_ALL_B version_type C and A

in Enterprise Contracts

Summary:

For a contract e.g. cont1234, I see there are 2 entries. One has status as Active and other has status as Under Amendment.

But if I check in this table OKC_K_HEADERS_ALL_B, for version_type = 'C', this seems like the Under Amendment one.

Not sure if the condition that I have taken in my query is correct or not? Please help. (to get values of contract I have used condition version_type = 'C' while joining with other tables like projects etc)

For the record, which shows Active in UI - These are the column values from database: STS_code = Active, Version_type = A, State_transition_flow_state = 'Active' and also has a date in date_approved column

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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