Hi There,

Environment - Oracle 9i, Solaris

Here is the sql that works in CNV but not in TST.

SELECT /*+ FIRST_ROWS */ BUSINESS_UNIT_PO, PO_ID, TO_CHAR(PO_DT,'YYYY-MM-DD'), VENDOR_ID, NAME1 FROM PS_VCHR_PO_VW A WHERE BUSINESS_UNIT_PO=:1 ORDER BY BUSINESS_UNIT_PO, PO_ID

0 row in TST

If I replace the hit with ALL_ROWS, I get 772 rows.

Please advise.