<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: zhangxing5129 $Date: 2013-12-5 下午02:54:05 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select vl.set_of_books_id, vl.company_id, vl.account_id, vl.account_set_id, vl.account_code, vl.description, vl.account_code ||'-'|| vl.description account_code_desc, h.parent_account_id, vl.summary_flag from gld_company_accounts_vl vl, gld_account_hierarchy_detail h where vl.account_set_id = h.account_set_id and vl.account_id = h.account_id(+) and vl.ENABLED_FLAG = 'Y' and vl.COMPANY_ID = ${/session/@top_biz_company_id} and vl.ACCOUNT_SET_ID=h.account_set_id and vl.SET_OF_BOOKS_ID = (select c.set_of_books_id from fnd_companies c where c.company_id = ${/session/@top_biz_company_id}) ]]></bm:query-sql> </bm:operation> </bm:operations> </bm:model>