Hi Trilok,
Below is the query fetching up all loan accounts details with their customer names. The field ACCOUNT_STATE with value as APPLICATION APPROVED is the one whose loan needs to be disbursed.(already approved but pending for disbursal) select office.display_name as BRANCH, center.display_name CENTER, grp.display_name GROUP_NAME, client.display_name ClIENT_NAME, account.global_account_num ACCOUNT_NUM, account_state.status_description as ACCOUNT_STATE from office inner join customer client on client.branch_id=office.office_id inner join customer grp on grp.customer_id=client.parent_customer_id inner join customer center on center.customer_id=grp.parent_customer_id inner join account on account.customer_id=client.customer_id inner join loan_account on loan_account.account_id=account.account_id inner join account_state on account_state.account_state_id=account.account_state_id order by office.display_name,center.display_name,grp.display_name,client.display_ name,account_state.status_description Thanks & Regards, Ramya Toshniwal * SunGard Technology Services * Embassy Icon,Infantry Road, Bangalore,India Tel +91-80-2222-0501 Extn - 3240 www.sungard.com <http://www.sungard.com/> From: Trilok J. Pandya [mailto:[email protected]] Sent: Saturday, December 18, 2010 3:35 PM To: Mifos Developer Discussions; [email protected] Subject: [Mifos-developer] Want A List Of All Loans Which is not Disbursed dear friend i want a list of all loans which is still not disbursed with its customer details and loan details. and one more thing that i have to find the status of loan in this i want by which field we can find that this loan is disbursed or not . --
<<image001.jpg>>
------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
