Search found 3 matches
- Wed Aug 12, 2009 10:10 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Unable to Query a view After Initialising Session
- Replies: 0
- Views: 611
Unable to Query a view After Initialising Session
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...
- Sun Aug 09, 2009 9:19 am
- Forum: Purchasing & Inventory
- Topic: INVENTORY CRISP HANDOUT
- Replies: 9
- Views: 8028
- Sun Aug 09, 2009 9:07 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: Report to run with null value or entered value
- Replies: 3
- Views: 3927
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...