701: fv.flex_value_id, fv.flex_value
702: FROM fnd_flex_values fv,
703: fnd_flex_value_sets fvs,
704: ( SELECT DISTINCT user_dim1_id flex_value_id
705: FROM fii_gl_ccid_dimensions
706: MINUS
707: SELECT child_value_id flex_value_id
708: FROM fii_full_udd1_hiers
709: WHERE parent_value_id = child_value_id) udd1
715: fv.flex_value_id, fv.flex_value
716: FROM fnd_flex_values fv,
717: fnd_flex_value_sets fvs,
718: ( SELECT distinct user_dim2_id flex_value_id
719: From fii_gl_ccid_dimensions
720: MINUS
721: SELECT child_value_id flex_value_id
722: FROM fii_full_udd2_hiers
723: WHERE parent_value_id = child_value_id) udd2