DBA Data[Home] [Help]

APPS.FII_SETUP_VAL_C dependencies on FII_FIN_CAT_MAPPINGS

Line 682: from fii_fin_cat_mappings fcm

678: and fv2.flex_value = org.org_information5
679: and fv1.flex_value_id = fgj.company_id
680: and fv2.flex_value_id = fgj.cost_center_id) v
681: where not exists (select fcm.child_fin_cat_id
682: from fii_fin_cat_mappings fcm
683: where fcm.child_fin_cat_id = v.fin_category_id )) c,
684: fnd_flex_values d,
685: fnd_flex_value_sets e
686: WHERE a.application_id = 101

Line 751: fii_fin_cat_mappings fcm

747: fnd_flex_values fv2,
748: (select distinct company_id, cost_center_id, fin_category_id,
749: chart_of_accounts_id
750: from fii_gl_je_summary_b) fgj,
751: fii_fin_cat_mappings fcm
752: where ccc_tbl.org_information_context = 'CLASS'
753: and ccc_tbl.org_information1 = 'CC'
754: and ccc_tbl.org_information2 = 'Y'
755: and ccc_tbl.organization_id = mgr_tbl.organization_id (+)