PA AutoAccounting Lookup Sets

Description

Categories
BI Publisher
Application
Projects
Source
IMP: AutoAccounting Lookup Sets (XML)
Short Name
PAXAASVL_XML
DB package
PA_PAXAASVL_XMLP_PKG

SQL 8 lines

select segment_value_lookup_set_name
,      description
,      segment_value_lookup_set_id segment_value_lookup_set_id1
from   pa_segment_value_lookup_sets
 where nvl(:segment_lookup_set_id,segment_value_lookup_set_id)
       = segment_value_lookup_set_id
order by segment_value_lookup_set_name

Parameters 1

ParameterTypeList of values SQL
Lookup SetLOV Oracle