ora-904 when using line view in cursor.
I am able to compile this pl/sql that uses the following cursor with an inline view. I am even able to create view of the select statement with the inline view. The inline view also calls funtions that each
returns a value to the inline view.
However when I actually run the code I get an ora-904 error. If it matters I actually am running this in EBS 12.1.3.
Here is the cursor:
Select
--h.gl_id,
a.doc_no,
--h.seq_no,
a.julian_period,
a.cal_year, a.cal_month, a.cal_day,
--h.doc_descr,
--l.gl_dtl_id,