GCS Consolidation Trial Balance Data Source

➜ Back to Library
Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_TB_SOURCE
DB package: GCS_XML_DT_UTILITY_PKG
Run GCS Consolidation Trial Balance Data Source and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT gcer.run_name RUN_NAME,
					   ght.hierarchy_name HIERARCHY_NAME,
					   fcpt.cal_period_name CAL_PERIOD_NAME,
					   gdtct.data_type_name BALANCE_TYPE,
					   to_char(gcer.start_time, 'DD-MON-YYYY HH24.MI.SS AM') START_TIME,
					   to_char(gcer.end_time, 'DD-MON-YYYY HH24.MI.SS AM') END_TIME,
					   fct.name CURRENCY_NAME,
					   to_char(CalPdEndDt.date_assign_value, 'DD-MON-YYYY') DATE_ASSIGN_VALUE,
					   gcer.hierarchy_id,
					   gdc.dataset_code DATASET_CODE,
					   ghb.fem_ledger_id LEDGER_ID,
					   gcer.CAL_PERIOD_ID,
					   fct.currency_code CURRENCY_CODE,
					   fnd_currency.safe_get_format_mask(fct.currency_code, 50) format_mask,
                       gcer.BALANCE_TYPE_CODE BALANCE_TYPE_CODE,
					   gdtcb.data_type_code
				  FROM gcs_cons_eng_runs gcer,
					   gcs_hierarchies_b ghb,
					   gcs_hierarchies_tl ght,
					   fem_cal_periods_tl fcpt,
					   fnd_currencies_tl fct,
					   gcs_data_type_codes_b gdtcb,
					   gcs_data_type_codes_tl gdtct,       
					   (SELECT date_assign_value, cal_period_id
						  FROM fem_cal_periods_attr
						 WHERE attribute_id = :pCalPeriodEndDateAttr
						   AND version_id = :pCalPeriodEndDateVersion) CalPdEndDt,
					   gcs_dataset_codes gdc,
					   gcs_entry_headers geh
				 WHERE gcer.run_name = :pRunName
				   AND gcer.run_entity_id = :pEntityId
				   AND geh.entry_id = :pXmlFileId
				   AND gcer.cal_period_id = fcpt.cal_period_id
				   AND CalPdEndDt.cal_period_id = gcer.CAL_PERIOD_ID
				   AND fct.currency_code = geh.currency_code
				   AND fct.language = :pLanguageCode
				   AND gdc.hierarchy_id = gcer.hierarchy_id
				   AND gdc.balance_type_code = gcer.BALANCE_TYPE_CODE
				   AND gcer.balance_type_code = gdtcb.data_type_code
				   AND gdtcb.data_type_id = gdtct.data_type_id
				   AND gdtct.language = :pLanguageCode
				   AND fcpt.language = :pLanguageCode
				   AND gcer.hierarchy_id = ghb.hierarchy_id
				   AND ghb.hierarchy_id = ght.hierarchy_id
				   AND ght.language = :pLanguageCode
				   AND gcer.MOST_RECENT_FLAG = 'Y'
Download
Related Blitz Reports
GCS Intercompany Matching Data Source for Consolidation Entities GCS Intercompany Matching Base Data Source for Consolidation Entities GCS Intercompany Matching Data Source GCS Intercompany Matching Base Data Source GCS Data Submission Data Load Base Data Source GCS Consolidation Entries Base Data Source GCS Consolidation Entries Data Source GCS Data Submission Trial Balance Base Data Source GCS Data Submission Trial Balance Data Source
Blitz Report™

Blitz Report™ provides multiple benefits: