My one table fm_matl_dtl has data and it returns null rows, However when I try to access it from sqlplus it returns rows.
I tried through toad with both user gmd/apps but now rows however when i check the table grant option it has given privliges to apps already.
sys_context is also not working.
This happens due to formula level security being set.
Try setting the context of Applications User, responsibility and org (using fnd_global.apps_initialize(p_user_id, p_resp_id, p_resp_appl_id) and mo_global.init('GMD'); mo_global.set_policy_context(...) ), you will be able to retrieve rows as dictated by the security rule.