Not able to query PA_EXPEND_ITEMS_ADJUST2_V
Hi All,
We are trying to run a query for the view PA_EXPEND_ITEMS_ADJUST2_V but it is returning no data (only the column names are coming). The query we have used is as below.
SELECT * FROM apps.PA_EXPEND_ITEMS_ADJUST2_V
We have even tried running the below query with the ORG_ID prior to running the above query but still it is not returning any data.
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('NNNN');
END;
Any help in this regrad will be much appreciated.