Apex - LOVs - With Clause Errors

On Apex 4.2.2 the Empno 1 LOV gives this type of error:

wwv_flow_plugin.ajax_callback: ORA-06550: Line 4, column 49: PL/SQL: ORA-00947: Not enough values. ORA-01007: Variable not in SELECT-list.. ORA-06550: Line 1, column 13: PL/SQL: SQL Statement ignored. ORA-01007: Variable not in SELECT-list.

Apex 5.1.1 (or maybe earlier versions than that) seems to have fixed this, but I thought I'd include this for posterity.

The Empno 2 LOV shows a rewrite of the query that works fine with Apex 4.2.2. Basically, avoid the combination of a With clause and a Pipelined table function.
Note that not all LOV types seem to be affected. When I tried this, Popup LOVs gave the error, while e.g. Select Lists worked fine.

Deptno

Page

Identification
	Page ID	1101
	Name	Apex - LOVs - With Clause Errors

Item

Identification
	Sequence	10
	Name	P1101_DEPTNO
	Display As	Select List
User Interface
User Interface	Region	Settings
List Of Values
	Display Extra Values	No
	Display Null Value	Yes
	List of values definition	select d.dname as d , d.deptno as r from dept d order by 1
Advanced
Advanced	Warn on Unsaved Changes	Page Default
Source
	Source Used	Only when current value in session state is null
	Source Type	Always Null

Item

Identification
	Sequence	20
	Name	P1101_EMPNO_1
	Display As	Popup LOV
User Interface
User Interface	Region	Settings
List Of Values
	Display Extra Values	No
	Display Null Value	Yes
	Cascading LOV Parent Item(s)	P1101_DEPTNO
	List of values definition	with d as ( select * from dept where deptno = :P1101_DEPTNO ) select e.column_value as d , e.column_value as r from d , table( ted_p1101.deptname_table(p_deptno => d.deptno) ) e order by 1
Advanced
Advanced	Warn on Unsaved Changes	Page Default
Source
	Source Used	Only when current value in session state is null
	Source Type	Always Null

Item

Identification
	Sequence	30
	Name	P1101_EMPNO_2
	Display As	Popup LOV
User Interface
User Interface	Region	Settings
List Of Values
	Display Extra Values	No
	Display Null Value	Yes
	Cascading LOV Parent Item(s)	P1101_DEPTNO
	List of values definition	select e.column_value as d , e.column_value as r from ( select * from dept where deptno = :P1101_DEPTNO ) d , table( ted_p1101.deptname_table(p_deptno => d.deptno) ) e order by 1
Advanced
Advanced	Warn on Unsaved Changes	Page Default
Source
	Source Used	Only when current value in session state is null
	Source Type	Always Null

Package

Package
	Name	TED_P1101
	Source	package ted_p1101 is type t_varchar_table is table of varchar2(4000) ; function deptname_table ( p_deptno in dept.deptno%type ) return t_varchar_table pipelined ; end ted_p1101;

Package Body

Package Body
	Name	TED_P1101
	Source	package body ted_p1101 is function deptname_table ( p_deptno in dept.deptno%type ) return t_varchar_table pipelined is cursor c1 is select e.ename from dept d , emp e where d.deptno = e.deptno and d.deptno = p_deptno ; begin for r1 in c1 loop pipe row(r1.ename); end loop; return; end deptname_table; end ted_p1101;

Info

Settings

Code

Page

Item

Item

Item

Package

Package Body