Sql Query Results Incorrect
In the where clause of the sql:
AND trunc(nvl(pll.promised_date,pll.need_by_date)) < trunc(sysdate)
table being queried is po_line_locations_all pll
Data column shown is nvl(pll.promised_date,pll.need_by_date) due_date
Results of query vary depending on when the concurrent program is executed.
We have data where promised_date is null, and need_by_date is set to 09/21/11.
However, when the program executes, at times it returns a row in the Blanket PO, for an open release, indicating the due date needed is 10/24/11.
Two issues with this:
1. The date on the Blanket Release is 09/21/11
AND trunc(nvl(pll.promised_date,pll.need_by_date)) < trunc(sysdate)
table being queried is po_line_locations_all pll
Data column shown is nvl(pll.promised_date,pll.need_by_date) due_date
Results of query vary depending on when the concurrent program is executed.
We have data where promised_date is null, and need_by_date is set to 09/21/11.
However, when the program executes, at times it returns a row in the Blanket PO, for an open release, indicating the due date needed is 10/24/11.
Two issues with this:
1. The date on the Blanket Release is 09/21/11
0