How to use Flexfield in XML/BI Publisher reports

There are four types of key flexfield-related lexicals as follows:

oracle.apps.fnd.flex.kff.segments_metadata
oracle.apps.fnd.flex.kff.select
oracle.apps.fnd.flex.kff.where
oracle.apps.fnd.flex.kff.order_by
The attributes for this lexical are listed in the following table:


SELECT <some columns>
 FROM gl_code_combinations gcc,
 some_other_gl_table sogt
 WHERE gcc.chart_of_accounts_id = :p_id_flex_num
 and sogt.code_combination_id = gcc.code_combination_
id
 and &FLEX_WHERE_GL_BALANCING
 and <more conditions on sogt>
<lexicals>

 <lexical>
 type="oracle.apps.fnd.flex.kff.where"
 name="FLEX_WHERE_GL_BALANCING"

comment="Comment"

 application_short_name="SQLGL"

 id_flex_code="GL#"

 id_flex_num=":P_ID_FLEX_NUM"

 code_combination_table_alias="gcc"

 segments="GL_BALANCING"

 operator="BETWEEN"

 operand1=":P_GL_BALANCING_LOW"

 operand2=":P_GL_BALANCING_HIGH"/>

</lexicals>