Data is updated in the oracle base table and the older data version is not maintained.

Summary:

To retrieve the Order header Freight terms code, we are utilizing the msc_xref_mapping table.
Please refer to the query below:

SELECT flvv.meaning freight_terms,dha.order_number
FROM fnd_lookup_values flvv,
msc_xref_mapping mxm,
doo_headers_all dha
WHERE flvv.lookup_type = 'WSH_FREIGHT_CHARGE_TERMS'
AND flvv.language = 'US'
AND mxm.source_value = flvv.lookup_code
AND mxm.target_value = dha.freight_terms_code
AND mxm.entity_name = 'WSH_FREIGHT_CHARGE_TERMS'
AND mxm.attribute_name = 'LOOKUP_CODE'
and dha.status_code not in ('DOO_DRAFT','DOO_REFERENCE')

To update the data, follow these steps: