getting error APP-FND-00798: Invalid reference while compilingvalue set

Hello,

While compliling value set to get order type at invoice line level dff we are getting error:

APP-FND-00798: Invalid reference HEADER_ID in value set attached to segment Order Type

 

Please check the WHERE clauses of your table validated value sets.

Query is as follows:

select * from OE_TRANSACTION_TYPES_TL A, OE_ORDER_HEADERS_ALL B where B.ORDER_TYPE_ID=A.TRANSACTION_TYPE_ID
AND A.LANGUAGE='US'
AND B.HEADER_ID = :$FLEX$.HEADER_ID

Kindly help us understand what is the issue