SQL to fetch Amount Type in Review Budgetary Control Balances

Hi All,

We would need guidance in identifying the table where the amount type is stored, we could find the amount type in table 'FND_LOOKUP_VALUES_VL' for the lookup type 'XCC_BALANCES_AMOUNT_TYPES', but unable to find the right value to join between the control budget tables.

SELECT * FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE LIKE 'XCC_BALANCES_AMOUNT_TYPES'
ORDER BY 1

Could someone please help identify the right approach to fetch the amount type? Please let us know if you have any insights or solutions.

Regards,

Swathi.