GCS Consolidation Entries Data Source

Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_ENTRY_SOURCE
DB package: GCS_XML_DT_UTILITY_PKG
SELECT 
					geh.ENTRY_NAME ,
					ght.HIERARCHY_NAME,
					fet.ENTITY_NAME,
					fcpt_start.CAL_PERIOD_NAME start_cal_period_name,
					fcpt_end.CAL_PERIOD_NAME end_cal_period_name,
					geh.SUSPENSE_EXCEEDED_FLAG,
					fct.NAME,
					geh.DESCRIPTION,
					geh.entry_id,
					geh.hierarchy_id,
					geh.START_CAL_PERIOD_ID cal_period_id,
					geh.entity_id,
					decode(geh.category_code,'DATAPREPARATION','Y', 'INTRACOMPANY','Y', 'TRANSLATION','Y', 'INTERCOMPANY','Y','N') is_drillable,
					fnd_currency.safe_get_format_mask(geh.currency_code,50) format_mask,
                    gct.category_name,
					GCS_DRILLDOWN_UTIL_PKG.url_encode('+') plus,
					GCS_DRILLDOWN_UTIL_PKG.url_encode('/') slash,
					fu_created.USER_NAME AS CREATED_BY,
					geh.CREATION_DATE,
					fu_updated.USER_NAME AS LAST_UPDATED_BY,
					geh.LAST_UPDATE_DATE,
					geh.ENTRY_TYPE_CODE,
					decode(:pSourceUI, 'CONS_MONITOR', 'CM', 'NotCM') source_ui,
					geh.YEAR_TO_APPLY_RE,
                    nvl(fcpt_disable.cal_period_name, 'null') DISABLED_PERIOD,
					geh.balance_type_code data_type_code
				FROM 
					gcs_entry_headers geh,
					gcs_hierarchies_tl ght,
					fem_entities_tl fet,
					fem_cal_periods_tl fcpt_start,
                    fem_cal_periods_tl fcpt_end,
					fem_cal_periods_tl fcpt_disable,
					fnd_currencies_tl fct,
					gcs_categories_tl gct,
					fnd_user fu_created,
					fnd_user fu_updated
				WHERE 
					geh.entry_id                         =  :pXmlFileId
					AND geh.hierarchy_id                 =  ght.hierarchy_id
					AND ght.language                     =  userenv('lang')
					AND geh.entity_id                    =  fet.entity_id
					AND fet.language                     = userenv('lang')
					AND geh.start_cal_period_id          =  fcpt_start.cal_period_id
					AND fcpt_start.language              =  userenv('lang') 
					AND geh.end_cal_period_id            =  fcpt_end.cal_period_id (+)
					AND fcpt_disable.cal_period_id (+)   =  geh.disabled_cal_period_id
                 	AND fcpt_disable.language (+)        =  userenv('lang') 
                 	AND fcpt_end.language (+)            =  userenv('lang') 
					AND fct.language                     =  userenv('lang')
					AND geh.currency_code                =  fct.currency_code
					AND geh.category_code                =  gct.category_code
					AND gct.language                     =  userenv('lang')
					AND geh.created_by			         =  fu_created.user_id
					AND geh.last_updated_by		         =	fu_updated.user_id
Ask a question