GCS A&D Trial Balance Base Data Source

Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_AD_TB_SOURCE_BASE
DB package:
  SELECT 
         flv.meaning category_name,
         to_char(treatments.transaction_date,'DD-MON-YYYY') transaction_date,
         ght.hierarchy_name hierarchy_name,
         fet1.entity_name consolidation_entity_name,
         fet2.entity_name child_entity_name,
         treatments.total_consideration,
         treatments.entry_name,
         treatments.description,
		 fct.NAME currency_name,
		 fnd_currency.safe_get_format_mask(fcb.currency_code,50) format_mask
   FROM 
         fnd_lookup_values flv,
         fem_entities_tl fet1,
         fem_entities_tl fet2,
         gcs_entity_cons_attrs geca,
         gcs_hierarchies_tl ght,
         fnd_currencies_tl fct,
         fnd_currencies fcb,
         (select gtt_to.treatment_id to_treatment_id,
                 gtt_from.treatment_id from_treatment_id,
                 gtt_to.treatment_name to_treatment,
                 gtt_from