CI: merge back from main

CI: update AD_MODULE to version 29675

Added C_INVOICETAX_CASHVAT.FIN_PAYMENT_DETAIL_ID index,
which improves several processes, like the fix cash vat info module script

CI: merge back from main

CI: update AD_MODULE to version 29668

fixes issue 33321: Implement isSameTab for Process Definition based windows

Process definition based windows can be opened in more than one tab at the same time. This allows, for example, to see the parameters used to run the process in case the process window is reopened after the execution.

This is the current behavior of such windows. We are just implementing the isSameTab method to remark this behavior.

Related to issue 33302: Code review improvements

- Add new usePriceIncludeTax parameter to getProductPrice method documentation.
- Check usePriceIncludeTax flag only once in getProductPrice query.
- Send usePriceIncludeTax parameter correctly in CostingAlgorithm.getPriceListCost method.
- Send usePriceIncludeTax parameter in CostingAlgorithm.getReceiptDefaultCost method.

Fixes issue 33302: Related to costing of purchase price lists including taxes

Fix to the issue Costing engine is not taken into account that purchase price list can be setup to include taxes, while cost should not include taxes.

Fixes issue 33288: Linked items corrected in Payment Plan when unpaid invoice

Defined SQL Where Clause for Lines tab in Payment In and Payment Out window due that that HQL Where clause defined for Lines tab in Payment window is not executed from Linked Items correctly.

Related to issue 33261: Random failure in testCostingMC444

Create purchase and sales product prices only in case purchase price is different than sales price, otherwise, create only purchase product price.

CI: merge back from main

CI: update AD_MODULE to version 29661

Fixed issue 32939: Impossible to add payment to order with negative outstanding

Related to issue 33197: Code review improvements

Take receipt line amount and receipt amount as absolute values to calculate correct landed cost receipt amount in case we have one receipt with two lines with the same amount but one positive and the other negative.

Fixes issue 33197: Avoided / by zero error when processing a landed cost

Avoided / by zero error when processing a landed cost

Fixes issue 33193: Failed to run Balance Sheet defined for Generic organization

Changes been done for Balance sheet report. i.e
a) If the balanced='true' then get Business units or Legal Entity in Org combo
b) If the balanced='false' then get all organizations in Org combo.

fixes issue 33297: Workspace is opened twice after refreshing two times
After a refresh, having a tab opened, the bookmark parameters of the Workspace were lost if the tab was selected when the Workspace was not completely loaded.
We now identify this scenario, and in that case, we recover the Workspace parameters using the OB.MyOB object.

Fixes issue 33169: Fix Backdated Transaction when movementdate has hours

Was truncated the movementdate column of M_TRANSACTION, allowing to the CostAdjustmentUtils class calculates correctly if the given Material Transaction is a backdated transaction or not.

fixes issue 33097: Process Definitions tab title appear as UUIDs after refresh
Implemented the getBookMarkParams method for parameter window view.

Fixed issue 33052: can't add prod characteristics to Return P&E

Two problems have been solved:
* By default, datasources based on HQL Query Tables do not accept property
fields. This needs to be implemented case by case. Now Return to Customer
and Return to Vendor P&E support it as far as the path to that property is
composed by not nullable properties.
* Product Characteristics filter assumed the alias for the main table in the
datasource it was working on was always "e". This is might not be true for
datasources based on HQL Query Tables.

issue 33292: test can be disabled with post.publication JVM prop set to true

Issue 33292. Temporarily disable testModulesValidation

Related to issue 33165: Code review improvements

Fixes issue 33165: Improve attribute error message when processing a shipment

Give related order and order line information when throwing productWithoutAttributeSet error message to be able to know which order line is wrong when generating a shipment from Create Shipments From Orders window.

Related to issue 30455: Code review improvements

Added also support for multiple criteria filtering in getWarehouseFilterData, getStorageFilterData, getAttributeSetValueFilterData and getOrderLineSetValueFilterData methods.
Add criteria.has("fieldName") check to avoid NPE.

Fixes issue 30455: Add support for multiple filtering in Stock Reservation P&E

Added support for multiple criteria filtering in getGridData method

fixed issue 22559: SqlC does execute all queries at compile time

SqlC does execute all select queries at compile time when it is processing
xsql files.

Technically that is needed to get the number, names & data-types of the columns
in the result as that info is used to generate the fields and data-reading code
in the to be generated java file.

However the jdbc spec does have a optional method to get that same information
for a query without executing it.

As this method is supported in current jdbc drivers for both Oracle and PostgreSQL,
now it is used instead of executing the whole queries.

fixed bug 33167: unneded flush in KernelApplicationInitializer.getDatabaseDateTime

Merge back from main

Merge temporary head for 3.0PR16Q2