Freight terms are changed when ship to address is updated in Sales Order header
Hello,
We need Freight Terms to be defaulted as per Oracle seeded rule during order creation. But we need the freight terms not to be modified if user changes ship-to or bill-to addreses after order has been created (saved for first time). So we added in package OE_Dependencies_Extn (OEXEDEPB.pls) follow code:
oe_debug_pub.add('Enter OE_Dependencies_Extn.LOAD_ENTITY_ATTRIBUTES', 1);
l_index := 1;
IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
x_extn_dep_tbl(l_index).source_attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
x_extn_dep_tbl(l_index).dependent_attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;