<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="gp" baseTable="GLD_PERIODS"> <bm:fields> <bm:field name="period_set_code" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="period_year" databaseType="NUMBER" datatype="java.lang.Long"/> <bm:field name="period_num" databaseType="NUMBER" datatype="java.lang.Long"/> <bm:field name="period_name" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="adjustment_flag" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="internal_period_num" databaseType="NUMBER" datatype="java.lang.Long"/> <bm:field name="start_date" databaseType="DATE" datatype="java.util.Date"/> <bm:field name="end_date" databaseType="DATE" datatype="java.util.Date"/> <bm:field name="quarter_num" databaseType="NUMBER" datatype="java.lang.Long"/> </bm:fields> <bm:primary-key> <bm:pk-field name="internal_period_num"/> <bm:pk-field name="period_set_code"/> </bm:primary-key> <bm:query-fields> <bm:query-field name="company_id" queryExpression="period_set_code=(select gd.period_set_code from gld_set_of_books gd,fnd_companies fc where gd.set_of_books_id=fc.set_of_books_id and fc.company_id=${/session/@company_id})"/> <bm:query-field name="date" queryExpression="start_date <= to_date(${@date},'yyyy-mm-dd') and end_date>= to_date(${@date},'yyyy-mm-dd')"/> </bm:query-fields> </bm:model>