Having copied the PurchaseOrderPrint.report and .PurchaseOrderPrint.rdf to my custom area.
Opened in IFS Developer Studio.
Added an entity to the PurchaseOrderPrint.report and updating the .rdf as required.
After saving the changes then clicked Generate Code.
On checking the generated .rdf file the SELECT statements appear to have changed.
CURSOR get_pur_part_manufacturer IS
SELECT
NULL NULL
FROM dual;
However, in the original PurchaseOrderPrint.rdf from CORE there is a CURSOR get_pur_part_manufacturers:
CURSOR get_pur_part_manufacturers(contract_ VARCHAR2, part_no_ VARCHAR2, vendor_no_ VARCHAR2) IS
SELECT *
FROM purchase_part_suppl_manuf
WHERE contract = contract_
AND part_no = part_no_
AND vendor_no = vendor_no_;
There are quite a few other CURSOR statements that are very similar.
