select a.lookup_type Lookup_type_name,a.meaning Lookup_type_meaning,flv.lookup_code lookup_code_name,flv.meaning lookup_code_meaning,
flv.description,flv.enabled_flag,flv.start_date_active,flv.end_date_active,
decode(flv.created_by,’SEED_DATA_FROM_APPLICATION’,’Standard’,’Custom’),b.module_name
from fnd_lookup_types_vl a, FND_APPL_TAXONOMY b, fnd_lookup_values_vl flv
where 1=1
–and a.lookup_type=’BARGAINING_UNIT_CODE’
and a.module_id=b.module_id
and upper(b.module_name) like ‘HCM%’
and a.lookup_type=flv.lookup_type
–and flv.created_by=’SEED_DATA_FROM_APPLICATION’
Recent Posts