AnsweredAssumed Answered

Method to update the lookup for Stage

Question asked by donkoller1319120 on Jun 28, 2012
Latest reply on Jun 28, 2012 by donkoller1319120
Hi,

I was approached by our Project Manager how to update the lookup values that display on the main project screen in Clarity, there is a section called Details. In that section on the right hand side is a field titled “Stage”.
The information resides in the table called CMN_LOOKUP with a lookup type of INV_STAGE_TYPE and a parent lookup code of PROJPHASE.
This is the query I used:
select * from CLARITY.CMN_LOOKUPS
where lookup_type like 'INV_STAGE_TYPE'
and Parent_lookup_code = 'PROJPHASE'

What is the process to update the lookup values within the Clarity application?

I would appreciate your help this question.

Thanks for your help in advance.

Don Koller

Outcomes