How to populate Order Line EFF against Invoice Line DFF

Summary:

hi, We are trying to auto populate/default the invoice line DFF filed from Order line EFF field using sql script. The defaulting should happen after the invoice is created using AutoInvoice import program. The DFF field is added under the same context where rest of the Order details are mapped. These fields fall under same Distributed Order Orchestration context. The value of DFF is not getting populated based on below query.

Line Transactions(Flexfield Code - RA_INTERFACE_LINES), context code Distributed Order Orchestration(DOO). 

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):