Value set using distinct for several columns and tables

Hi there!

In 11i I'm using the next configuration for a value set:

Table Application: General Ledger

Table Name: Apps.Gl_code_combinations Glcc, Apps.Ra_cust_trx_line_gl_dist_all Ragl, Apps.Hr_all_organization_units Hror

Allow parent values: unchecked

Value: Glcc.Segment1

Meaning: Hror.Name

ID: Distinct Glcc.Segment1

Where/Order By:

Where  Ragl.Code_combination_id     =	Glcc.Code_combination_id
And	Hror.Organization_id		=	Ragl.Org_id

Order by Glcc.Segment1

This configuration used to work in 11i, but when I try to use it in R12 I get the next error:

ORA-00936: missing expression