Synonym of a table gives no data
BmFeb 26 2013 — edited Mar 26 2013Hi,
I am working on a table PO.PO_REQUISITION_LINES_ALL which contains enough data.
I have 2 synonyms "*PO_REQUISITION_LINES*" and "*PO_REQUISITION_LINES_ALL*" for PO.PO_REQUISITION_LINES_ALL table.
When run query "*select* * *from PO_REQUISITION_LINES_ALL*" it gives me data.
But when I run "*select* * *from PO_REQUISITION_LINES*" it gives no data.
I am not able to understand if both synonyms are created on the same table then why I dont get the same result.
Please help.
Bm