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:
Source:
Short Name: GCS_VS_MAP_SOURCE
DB package:
Run
GCS Value Set Map Validation Data Source and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |