select * from scheme.adoptionsm
where modname='pl' and wdname in('syspack','sysstock','sysmaize','sysmill','sysprop','syshof') and optname like 'pl_%'
and secgrpname='creditors_controller'


select * from scheme.optionsm
where module_option='pl_supplier_entry'

select a.name,a.privilidges, b.wdname,b.secgrpname,b.optname
from scheme.usermastm a inner join scheme.adoptionsm b on a.sec_group=b.secgrpname
where b.modname='pl'  and wdname in('sysmill')
and optname like 'pl_mast%'
and b.secgrpname not in('enquiry_user','buyer','finance_executive','management_accountant','creditors_clerk','accountant'
,'book_keeper','ss_cashbook_clerk','stats_clerk')
and b.modname='pl'