Default DFF line segment depending order header value
How can I create a SQL for Default order line DFF segment depending on order header value?
I use the SQL below but got error message
select xx.sales_department
from oe_order_headers_all oh,
oe_order_lines_all ol,
xx_so_departments sd
where sd.header_id = oh.header_id and
ol.header_id = oh.header_id and
ol.line_id = :$FLEX$.line_id
Error message:
APP-FND-00784: Invalid reference line_id in default value defined for segment sales_department