How to restrict the data at user level
Here is my problem:I have 2 key users for purchasing..
ABC is for my local purchases
XYZ is for my foreign purchases.
ABC & XYZ entered purchase orders..
while viewing the purchase order summary,
My Requirement is ABC can able to see his own purchase orders, but oracle giving all purchase orders entered by ABC and XYZ.
How can we query to get that particular user data only( Requisitions, invoice, Sales orders etc..)
is there any profile options suits for this..
Regards,
Sudhakar.
ABC is for my local purchases
XYZ is for my foreign purchases.
ABC & XYZ entered purchase orders..
while viewing the purchase order summary,
My Requirement is ABC can able to see his own purchase orders, but oracle giving all purchase orders entered by ABC and XYZ.
How can we query to get that particular user data only( Requisitions, invoice, Sales orders etc..)
is there any profile options suits for this..
Regards,
Sudhakar.
0