GCS Value Set Map Validation Data Source

Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_VS_MAP_SOURCE
DB package:
SELECT flit.company_cost_center_org_name dim_member_name,
       flit.description,
       fvst.value_set_name,
       fdt.dimension_name
  FROM fem_cctr_orgs_tl          flit,
       fem_value_sets_b         fvsb,
       fem_value_sets_tl        fvst,
       fem_dimensions_tl        fdt,
       fem_global_vs_combo_defs fgvcd,
       gcs_system_options       gso,
       fem_xdim_dimensions      fxd,
       fem_object_definition_b  fodb
 WHERE fgvcd.global_vs_combo_id = gso.fch_global_vs_combo_id
   AND fgvcd.value_set_id <> :pOrgsValueSetId
   AND flit.value_set_id = :pOrgsValueSetId
   AND flit.value_set_id = fvst.value_set_id
   AND fgvcd.dimension_id = 8
   AND fvsb.dimension_id = fdt.dimension_id
   AND fvsb.value_set_id = fvst.value_set_id
   AND fxd.default_mvs_hierarchy_obj_id = fodb.object_id
   AND fxd.dimension_id = fgvcd.dimension_id
   AND flit.language = USERENV('LANG')
   AND fvst.language = USERENV('LANG')
   AND fdt.language = USERENV('LANG')
   AND :pEffectiveDate BETWEEN fodb.effective_start_date AND
       fodb.effective_end_date
   AND NOT EXISTS
       (SELECT 'X'
          FROM fem_cctr_orgs_hier
         WHERE child_value_set_id <> parent_value_set_id
           AND hierarchy_obj_def_id = fodb.object_definition_id
           AND parent_value_set_id = fgvcd.value_set_id
           AND child_id = flit.company_cost_center_org_id
           AND child_value_set_id = :pOrgsValueSetId)
 ORDER BY dim_member_name
Ask a question