eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_SETUP_VAL_C dependencies on FND_FLEX_VALUES

Line 111: fnd_flex_values com,

107: per.full_name manager,
108: fnd_date.canonical_to_date(hoi.org_information3) eff_date
109: from fii_ccc_mgr_gt gt,
110: hr_all_organization_units org,
111: fnd_flex_values com,
112: fnd_flex_values cc,
113: per_all_people_f per,
114: hr_organization_information hoi
115: where gt.company_id = p_com_id

Line 112: fnd_flex_values cc,

108: fnd_date.canonical_to_date(hoi.org_information3) eff_date
109: from fii_ccc_mgr_gt gt,
110: hr_all_organization_units org,
111: fnd_flex_values com,
112: fnd_flex_values cc,
113: per_all_people_f per,
114: hr_organization_information hoi
115: where gt.company_id = p_com_id
116: and gt.cost_center_id = p_cc_id

Line 201: fnd_flex_values fv1,

197: AND nvl( fnd_date.canonical_to_date( org_information4 ),
198: sysdate + 1 ) >= sysdate
199: ) mgr_tbl,
200: hr_organization_information org,
201: fnd_flex_values fv1,
202: fnd_flex_values fv2
203: WHERE ccc_tbl.org_information_context = 'CLASS'
204: AND ccc_tbl.org_information1 = 'CC'
205: AND ccc_tbl.org_information2 = 'Y'

Line 202: fnd_flex_values fv2

198: sysdate + 1 ) >= sysdate
199: ) mgr_tbl,
200: hr_organization_information org,
201: fnd_flex_values fv1,
202: fnd_flex_values fv2
203: WHERE ccc_tbl.org_information_context = 'CLASS'
204: AND ccc_tbl.org_information1 = 'CC'
205: AND ccc_tbl.org_information2 = 'Y'
206: AND ccc_tbl.organization_id = mgr_tbl.organization_id (+)

Line 508: fnd_flex_values fv_co,

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
512: and not exists (select 1 from hr_organization_information

Line 509: fnd_flex_values fv_cc

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
512: and not exists (select 1 from hr_organization_information
513: where org_information_context = 'Company Cost Center'

Line 526: fnd_flex_values fv_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
530: and org_information_context = 'Company Cost Center'

Line 544: fnd_flex_values fv_co,

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
548: where fv_co.flex_value_id = b.company_id

Line 545: fnd_flex_values fv_cc,

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
548: where fv_co.flex_value_id = b.company_id
549: and fv_cc.flex_value_id = b.cost_center_id

Line 625: fnd_flex_values fv1,

621: sysdate + 1 ) >= sysdate
622: ) mgr_tbl,
623: hr_organization_information org,
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'

Line 626: fnd_flex_values fv2,

622: ) mgr_tbl,
623: hr_organization_information org,
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'

Line 664: fnd_flex_values fv1,

660: and nvl( fnd_date.canonical_to_date( org_information4 ),
661: sysdate + 1 ) >= sysdate
662: ) mgr_tbl,
663: hr_organization_information org,
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

Line 665: fnd_flex_values fv2,

661: sysdate + 1 ) >= sysdate
662: ) mgr_tbl,
663: hr_organization_information org,
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'

Line 684: fnd_flex_values d,

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
687: AND a.id_flex_code = 'GL#'
688: AND a.id_flex_num = c.chart_of_accounts_id

Line 702: FROM fnd_flex_values fv,

698:
699: CURSOR unmapped_udd1_cur IS
700: SELECT fvs.flex_value_set_id, fvs.flex_value_set_name,
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

Line 716: FROM fnd_flex_values fv,

712:
713: CURSOR unmapped_udd2_cur IS
714: SELECT fvs.flex_value_set_id, fvs.flex_value_set_name,
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

Line 746: fnd_flex_values fv1,

742: and nvl( fnd_date.canonical_to_date( org_information4 ),
743: sysdate + 1 ) >= sysdate
744: ) mgr_tbl,
745: hr_organization_information org,
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,

Line 747: fnd_flex_values fv2,

743: sysdate + 1 ) >= sysdate
744: ) mgr_tbl,
745: hr_organization_information org,
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

Line 768: fnd_flex_values d,

764: and fcm.child_fin_cat_id = fgj.fin_category_id ) v
765: WHERE NOT EXISTS (select fct.fin_category_id
766: from fii_fin_cat_type_assgns fct
767: where fct.fin_category_id = v.fin_category_id))c,
768: fnd_flex_values d,
769: fnd_flex_value_sets e
770: WHERE a.application_id = 101
771: AND a.id_flex_code = 'GL#'
772: AND a.id_flex_num = c.chart_of_accounts_id