ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFAD3869E053B46B63588994Y 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 GCS GCS_ENTRY_SOURCE US GCS Consolidation Entries Data Source Application: Financial Consolidation Hub (Obsolete) Source: Short Name: GCS_ENTRY_SOURCE DB package: GCS_XML_DT_UTILITY_PKG BI Publisher :psourceui :pxmlfileid