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.GCS_XML_DT_UTILITY_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 66: FROM fem_global_vs_combo_defs gvcd,

62: SELECT gvcd.dimension_id,
63: gvcd.value_set_id
64: BULK COLLECT INTO
65: l_dimension_vs_id
66: FROM fem_global_vs_combo_defs gvcd,
67: fem_ledgers_attr fla,
68: gcs_entities_attr gea,
69: fem_tab_column_prop ftcp,
70: fem_tab_columns_b ftcb,

Line 434: FROM fem_global_vs_combo_defs gvcd,

430: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period
431:
432: SELECT decode(gvcd.value_set_id, fch_gvcd.value_set_id, 'MAPPED', 'UNMAPPED')
433: INTO l_map_flag
434: FROM fem_global_vs_combo_defs gvcd,
435: fem_ledgers_attr fla,
436: gcs_entities_attr gea,
437: fem_tab_column_prop ftcp,
438: fem_tab_columns_b ftcb,

Line 440: fem_global_vs_combo_defs fch_gvcd,

436: gcs_entities_attr gea,
437: fem_tab_column_prop ftcp,
438: fem_tab_columns_b ftcb,
439: gcs_system_options gso,
440: fem_global_vs_combo_defs fch_gvcd,
441: gcs_data_sub_dtls gdsd ,
442: fem_cal_periods_attr fcpa
443: WHERE gso.fch_global_vs_combo_id = fch_gvcd.global_vs_combo_id
444: AND gea.entity_id = gdsd.entity_id

Line 500: ' fem_global_vs_combo_defs fgvscd_master, '||

496: IF (l_map_flag = 'UNMAPPED') THEN
497:
498: entityOrgsLiteral := ' AND EXISTS (SELECT 1 '||
499: ' FROM fem_cctr_orgs_hier fcoh, '||
500: ' fem_global_vs_combo_defs fgvscd_master, '||
501: ' gcs_system_options gso, '||
502: ' fem_global_vs_combo_defs fgvscd_child, '||
503: ' fem_xdim_dimensions fxd, '||
504: ' fem_object_definition_b fodb, '||

Line 502: ' fem_global_vs_combo_defs fgvscd_child, '||

498: entityOrgsLiteral := ' AND EXISTS (SELECT 1 '||
499: ' FROM fem_cctr_orgs_hier fcoh, '||
500: ' fem_global_vs_combo_defs fgvscd_master, '||
501: ' gcs_system_options gso, '||
502: ' fem_global_vs_combo_defs fgvscd_child, '||
503: ' fem_xdim_dimensions fxd, '||
504: ' fem_object_definition_b fodb, '||
505: ' gcs_entity_cctr_orgs feco '||
506: ' WHERE fcoh.child_id = fb.company_cost_center_org_id '||

Line 772: FROM fem_global_vs_combo_defs gvcd,

768: decode(gvcd.global_vs_combo_id, fch_gvcd.global_vs_combo_id, 'MAPPED', 'UNMAPPED')
769: INTO l_global_vsid,
770: l_fch_vsid,
771: l_map_flag
772: FROM fem_global_vs_combo_defs gvcd,
773: fem_ledgers_attr fla,
774: gcs_entities_attr gea,
775: gcs_system_options gso,
776: fem_global_vs_combo_defs fch_gvcd,

Line 776: fem_global_vs_combo_defs fch_gvcd,

772: FROM fem_global_vs_combo_defs gvcd,
773: fem_ledgers_attr fla,
774: gcs_entities_attr gea,
775: gcs_system_options gso,
776: fem_global_vs_combo_defs fch_gvcd,
777: gcs_data_sub_dtls gdsd,
778: fem_cal_periods_attr fcpa
779: WHERE gso.fch_global_vs_combo_id = fch_gvcd.global_vs_combo_id
780: AND fla.ledger_id = gea.ledger_id