select distinct cate.base_category_name as balance_category,
bal.base_balance_name as balance_name,bal.BALANCE_TYPE_ID,bal.BALANCE_UOM,
cls.BASE_CLASSIFICATION_NAME, pet.base_element_name as feed_element_name, pet.element_type_id,
piv.base_name as feed_input_value_name, piv.INPUT_VALUE_ID,
case feed.scale when 1 then 'add' else 'subtract' end as scale,
feed.effective_start_date,feed.effective_end_date,
bal.CREATION_DATE, bal.CREATED_BY
from
fusion.PAY_element_types_vl pet,
fusion.PAY_ELE_CLASSIFICATIONS_VL cls,
fusion.PAY_input_values_vl piv,
fusion.PAY_balance_types_vl bal,
fusion.PAY_balance_feeds_f feed,
fusion.PAY_balance_categories_f cate
where pet.classification_id = cls.CLASSIFICATION_ID
and pet.element_type_id=piv.element_type_id
and bal.balance_type_id=feed.balance_type_id
and feed.input_value_id=piv.input_value_id
and bal.balance_category_id=cate.balance_category_id
