[Home] [Help]
1017:
1018: FROM fii_gl_snap_f b,
1019: fii_fin_item_leaf_hiers fin,
1020: fii_company_hierarchies com,
1021: fii_cost_ctr_hierarchies cc,
1022: fii_udd1_hierarchies ud1
1023: WHERE b.fin_category_id = fin.child_fin_cat_id
1024: AND fin.is_leaf_flag = 'N'
1025: AND fin.aggregate_next_level_flag = 'Y'