Query : AP Holds

select
HOLD_LOOKUP_CODE,
HOLD_TYPE,
INACTIVE_DATE,
INITIATE_WORKFLOW_FLAG

from ap_hold_codes



select aha.hold_lookup_code, aha.count, flvv.lookup_type
from
(
select distinct hold_lookup_code, count(hold_lookup_code) "COUNT"
from ap_holds_all
group by hold_lookup_code
order by
count(hold_lookup_code
) )aha, fnd_lookup_values_vl flvv
where lookup_type = 'HOLD CODE'
and aha.hold_lookup_code = flvv.lookup_code