how to access user-defined tables in BI SQL Query

Content

hi ,

      We have an element entry called fuel statement. It has an input value called discount. Now I am trying to access a user-defined table value called discount percentage in my query and trying to do a simple multiplication but it is not working. Any ideas how to make it work.

Element entry input value= discount

UDT value=  Discount_percentage=0.9 (90%)

DISCOUNT= DISCOUNT*Discount_percentage

 

SELECT
    (TO_NUMBER(VALUE) * (DISCOUNT)) AS FUEL_DISCOUNT
FROM
    FF_USER_TABLES_TL            TL,
    FF_USER_ROWS_F               RW,
    FF_USER_COLUMNS              CL,
    FF_USER_COLUMN_INSTANCES_F   INS
WHERE
    1 = 1
    AND USER_TABLE_NAME = 'HG_PR_Transaction_Fee_Control_Table'