ERPstuff - Oracle EBS Community

Dear Experts i am initialising using this script begin fnd_global.apps_initialize (user_id => 1112 ,resp_id => 50707 ,resp_appl_id =>222 ); end; , but i am not able to query in view select * from ar_cash_receipts; please suggest if we need to do something more to initialise session. i checked MO:Ope...

Thanks Mr. Rangaraj

Really nice work, reallly damn crisp and to the point.


may almighty increase your tribe

Dear Naveed, This requirement of yours can be done in more than one ways. 1. select * from table where column_name = Nvl(:parameter, column_name) 2. select * from table where (:parameter is null ) <b>OR</b> (column_name = :parameter) Both of them works. if you have any more share it too. Best of luc...