DBA Data[Home] [Help]

APPS.FII_SETUP_VAL_C dependencies on FII_GL_JE_SUMMARY_B

Line 507: from fii_gl_je_summary_b) b,

503: fv_co.flex_value_id com_id,
504: fv_cc.flex_value cost_center,
505: fv_cc.flex_value_id cc_id
506: from (select distinct company_id, cost_center_id
507: from fii_gl_je_summary_b) b,
508: fnd_flex_values fv_co,
509: fnd_flex_values fv_cc
510: where fv_co.flex_value_id = b.company_id
511: and fv_cc.flex_value_id = b.cost_center_id

Line 525: from fii_gl_je_summary_b) b,

521: fv_co.flex_value co,
522: org.organization_id,
523: org2.name
524: from (select distinct company_id
525: from fii_gl_je_summary_b) b,
526: fnd_flex_values fv_co,
527: hr_organization_information org,
528: hr_all_organization_units org2
529: where fv_co.flex_value_id = b.company_id

Line 543: from fii_gl_je_summary_b) b,

539: fv_cc.flex_value cc,
540: org.organization_id,
541: org2.name organization
542: from (select distinct company_id, cost_center_id
543: from fii_gl_je_summary_b) b,
544: fnd_flex_values fv_co,
545: fnd_flex_values fv_cc,
546: hr_organization_information org,
547: hr_all_organization_units org2

Line 628: from fii_gl_je_summary_b) fgj

624: hr_all_organization_units hou,
625: fnd_flex_values fv1,
626: fnd_flex_values fv2,
627: (select distinct company_id, cost_center_id
628: from fii_gl_je_summary_b) fgj
629: WHERE ccc_tbl.org_information_context = 'CLASS'
630: AND ccc_tbl.org_information1 = 'CC'
631: AND ccc_tbl.org_information2 = 'Y'
632: AND ccc_tbl.organization_id = mgr_tbl.organization_id (+)

Line 668: from fii_gl_je_summary_b) fgj

664: fnd_flex_values fv1,
665: fnd_flex_values fv2,
666: (select distinct company_id, cost_center_id, fin_category_id,
667: chart_of_accounts_id
668: from fii_gl_je_summary_b) fgj
669: where ccc_tbl.org_information_context = 'CLASS'
670: and ccc_tbl.org_information1 = 'CC'
671: and ccc_tbl.org_information2 = 'Y'
672: and ccc_tbl.organization_id = mgr_tbl.organization_id (+)

Line 750: from fii_gl_je_summary_b) fgj,

746: fnd_flex_values fv1,
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'