ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFA13869E053B46B63588994 SELECT geh.ENTRY_ID, geh.ENTRY_NAME, ght.HIERARCHY_NAME AS HIERARCHY, fet.ENTITY_NAME AS ENTITY, gct.category_name AS CATEGORY, gsob.name AS TARGET_LEDGER, gdct.user_conversion_type AS CONVERSION_TYPE, gwh.PERIOD_NAME AS TARGET_PERIOD, gwh.GL_CATEGORY, fla.DIM_ATTRIBUTE_VARCHAR_MEMBER AS CURRENCY_CODE, gwh.REQUEST_ID FROM gcs_entry_headers geh, gcs_hierarchies_tl ght, gcs_hierarchies_b ghb, fem_entities_tl fet, gcs_categories_b gcb, gcs_categories_tl gct, fem_entities_attr fea_secure, gl_sets_of_books gsob, gcs_writeback_headers gwh, fem_ledgers_attr fla, gl_daily_conversion_types gdct WHERE gwh.writeback_id = :pXmlFileId AND geh.entry_id = gwh.entry_id 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.entry_type_code = 'MANUAL' AND gct.category_code = gcb.category_code AND gcb.category_type_code = 'CONSOLIDATION_RULE' AND gcb.category_code <> 'ACQ_DISP' AND gct.language = USERENV('LANG') AND geh.category_code = gcb.category_code AND fea_secure.entity_id = fet.entity_id AND fea_secure.attribute_id = :pEntityEnabledFlagAttr AND fea_secure.version_id = :pEntityEnabledFlagVersion AND (fea_secure.dim_attribute_varchar_member = 'N' OR EXISTS (SELECT 'X' FROM wf_local_user_roles wlur, gcs_role_entity_relns grer WHERE grer.entity_id = fet.entity_id AND wlur.user_name = :pUserName AND wlur.role_name = grer.role_name AND wlur.role_orig_system = grer.orig_system AND wlur.role_orig_system_id = grer.orig_system_id AND wlur.partition_id = grer.partition_id ) ) AND ghb.hierarchy_id = ght.hierarchy_id AND (ghb.security_enabled_flag = 'N' OR EXISTS (SELECT 'X' FROM wf_local_user_roles wlur, gcs_role_hier_relns grhr WHERE wlur.user_name =:pUserName AND wlur.role_name = grhr.role_name AND wlur.role_orig_system = grhr.orig_system AND wlur.role_orig_system_id = grhr.orig_system_id AND wlur.partition_id = grhr.partition_id AND grhr.hierarchy_id=ghb.hierarchy_id ) ) AND gsob.set_of_books_id = gwh.ledger_id AND gwh.entry_id = geh.entry_id AND gwh.ledger_id = gsob.set_of_books_id AND fla.ledger_id = gwh.ledger_id AND fla.attribute_id = :pLedgerCurrAttr AND fla.version_id = :pLedgerCurrVersion AND gwh.CONVERSION_TYPE = gdct.CONVERSION_TYPE(+) Y GCS FCH_ENTRY_WRITEBACK US GCS Consolidation Entries Writeback Application: Financial Consolidation Hub (Obsolete) Source: FCH: Consolidation Entries Writeback Short Name: FCH_ENTRY_WRITEBACK DB package: GCS_XML_DT_UTILITY_PKG BI Publisher :pentityenabledflagattr :pentityenabledflagversion :pledgercurrattr :pledgercurrversion :pusername :pxmlfileid 1 10 :entry_id Char US Entry Id 2 20 :reversal_entry_id Char US Reversal Entry Id 3 30 :ledger_id Char US Ledger Id 4 40 :period_name Char US Period Name 5 50 :conversion_type Char US Conversion Type