R12 extending PoRequisitionLinesVO not working
Hi,
i am trying hard to substitute a View object PoRequisitionLinesVO and to add new columns to the new SQL query.
I just created a new VO : XXPoRequisitionLinesVO which extends PoRequisitionLinesVO.
I used the exact same sql query that in the PoRequisitionLinesVO. I just added one column.
I made the substitute in the JPX file.
Imported the JPX on unix using JPXImporter.
When i go on iprocurment resp and try to add an item to the basket, i keep getting the same error :
as you can see the main query alias name is QRSLT, and the problem is that in the where clause the reference to the column is made using POREQUISITIONLINEEO ALIAS which is wrong (WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id)
i am trying hard to substitute a View object PoRequisitionLinesVO and to add new columns to the new SQL query.
I just created a new VO : XXPoRequisitionLinesVO which extends PoRequisitionLinesVO.
I used the exact same sql query that in the PoRequisitionLinesVO. I just added one column.
I made the substitute in the JPX file.
Imported the JPX on unix using JPXImporter.
When i go on iprocurment resp and try to add an item to the basket, i keep getting the same error :
as you can see the main query alias name is QRSLT, and the problem is that in the where clause the reference to the column is made using POREQUISITIONLINEEO ALIAS which is wrong (WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id)
0