Background:
Following script gives the list of cancelled AP Invoices in the data range.
Enter From_Date, To_Date in DD-MON-YYYY format.
Following script gives the list of cancelled AP Invoices in the data range.
Enter From_Date, To_Date in DD-MON-YYYY format.
SELECT *
FROM ap_invoices_all
WHERE cancelled_date IS NOT NULL
AND invoice_date BETWEEN TO_DATE ('&From_Date', 'DD-MON-YYYY')
AND TO_DATE ('&TO_DATE', 'DD-MON-YYYY');
FROM ap_invoices_all
WHERE cancelled_date IS NOT NULL
AND invoice_date BETWEEN TO_DATE ('&From_Date', 'DD-MON-YYYY')
AND TO_DATE ('&TO_DATE', 'DD-MON-YYYY');
Every blog and each and every site related to Oracle apps I can see this same spam message. But I haven't seen anywhere this lady has suggested a solution for any sort of basic Oracle apps question.
ReplyDelete