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