Tuesday, 31 March 2020

How to get the list of contexts for each formula type?

The below query can be used to find out the different contexts that are available to be used within a fast formula. Change the formula type as required.

select t.base_formula_type_name
,      ttl.formula_type_name
,      ttl.description
,      c.base_context_name
from   ff_formula_types_b t
,      ff_formula_types_tl ttl
,      ff_ftype_context_usages u
,      ff_contexts_b c
where  t.formula_type_id = u.formula_type_id
and    ttl.formula_type_id = t.formula_type_id
and    ttl.language = userenv('LANG')
and    ttl.formula_type_name like 'Oracle%Payroll%'
and    c.context_id = u.context_id

No comments:

Post a Comment