Fixes issue 20689: No items to show in Pick/Edit lines.
In Oracle COALESCE is replaced by NVL. NVL it is trying to do a type conversion
and the select is not returning any record (adding a to_char it works).
The order or comparation has been changed to prevent type comparation problems

Fixes issue 20690: int-dbconsistency fails int-dbcons-pgsql/3150

correct message from issue 20663 and changeset cd4d7012f8c8 in pi

Related to issue 20635: a wrong property was being checked.

In the isDate method of QueryListDataSource, the field name was being used to check if a parameter was contained in the parameter list. This was wrong, the dbColumnName field is the one to be checked.

Fixes issue 20617: Wrong behaviour of "Purchase orders to be received" alert

Fixes issue 20688: Newly added junit test fails and blocks all ci integration: int-full-pgsql/3619/
Fixes issue, refresh moved within if statement

Fixes issue 20682, Fixes issue 20674: Insert Orphan Line.

Related to issue 20551. Performance on Match Statement window

Fixed issue 20681: Added 'Image' field to 'AD_User'

Fixes issue 20635: date parameter works in Query/List widget

If a parameter is a Date, it is converted from its original class (String) to Date before setting the query parameter.

Related to issue 20635: Date is parsed correctly

The date was not being parsed correctly because ParameterUtils was only supporting the yyyy-MM-dd'T'HH:mm:ss pattern, and the value was formatted with the yyy-MM-dd pattern.

Now, the method createFromString() of the DateDomainType is being used to parse the date. This method supports both patterns.

Fixes issue 20680: RFC/RTV (pick&edit): error when returning a line

Fixes issue 20673: RFC/RTV (pick&edit): error product without attribute set instance

Related to issue 20515: Slow OBCriteria
Some additional test queries and printing of results

Related to issue 20515: Slow OBCriteria
Enhanced obcriteria testcase

Fixes issue 20611: OBCriteria doesn't support ScrollabeResults
Use the entity name instead of the classname to initialize the hibernate criteria

Related to issue 20515: Slow OBCriteria
Change the way order by is done to follow the standard approach of hibernate Criteria, resulting in a better joining of the order by table/property

Fixes issue 20666: Allow creation of proxy when setting property in business object

Fixes issue 20659: An empty set is returned when an invalid orgid is provided

The method getChildOrg of OrganizationStructureProvider now returns and empty set instead of null if an invalid orgid is provided.

A test has been added to test this behaviour.: Enter commit message. Lines beginning with 'HG:' are removed.

Related to issue 20551. Performance on Match Statement window

Fixes issue 20436: Purchasing tab process does not take into account discontinued configuration.

Fixes issue 20657: voided invoices process does not copy alternate taxable amount lines

Fixes issue 20640: Quick lunch short for specific names of some menu

Fixes issue 20663: In java SRMOPickEditLines.java can fail when is getting the tax

Fixes issue 20440: Error without information in the P&E of Return To Vendor

Fixes issue 20434: Process failed during execution when post a Matched Invoice

Fixed issue 20631: Product name does not appear in Dimensional Reports

Fixed Isue 20621: The application should warning about the consequence of closing a period permanently

Hides reverse payment functionality by hiding buttons in payment window

Fixes issue 20619: Reverse Payment