SQL statement below PL / SQL:
SELECT ---- According to the issuance of fine items, each 4 items; Trunc ((D.Item_id-1) / 1) 1, - Invoice number, date a.incie_no invoice_no, a.incie_date invoice_date, - - currency, exchange rate a.currency currency, a.curr_rate curr_rate,. . . . . . . . . . . . . . . It is no problem to run.
If you separate this SQL statement, you can right click on the IFS Admin-> Installation-> SQL File Executor to select the * .sql file, will report the error;
The solution is to put the in SQL statement --- according to the issuance of the issuance of fine items, each 4 materials; the last semicolon delete
SELECT ---- According to the issuance of fine items, each 4 data set in Trunc ((D.Item_id-1) / 1) 1, - Invoice number, date a.incie_no invoice_no, a.invoice_date infoice_date, Coin, exchange rate a.currency currency, a.curr_rate curr_rate,. . . . . . . . . . . . . . . This can be imported into the IFS system so that
