Hi Friends,
I am trying to put a VPD for restricting Order Releases. I am restricting it based on a refnum value on the order release.
As the refnum is present in the order_release_refnum table, I have created a join in the predicate with the order release table. The VPD is working fine.
Right now the amount of data is very less but is going to increase once it is put into production.
I wanted to know how the performance will be impacted due this VPD where I am not taking the values directly from the ORDER_RELEASE table.
Any inputs would be appreciated. Thanks.
Regards,
Anirban Roy
I am trying to put a VPD for restricting Order Releases. I am restricting it based on a refnum value on the order release.
As the refnum is present in the order_release_refnum table, I have created a join in the predicate with the order release table. The VPD is working fine.
Right now the amount of data is very less but is going to increase once it is put into production.
I wanted to know how the performance will be impacted due this VPD where I am not taking the values directly from the ORDER_RELEASE table.
Any inputs would be appreciated. Thanks.
Regards,
Anirban Roy
Comment