GCS Consolidation Entries Writeback
Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source: FCH: Consolidation Entries Writeback
Short Name: FCH_ENTRY_WRITEBACK
DB package: GCS_XML_DT_UTILITY_PKG
Source: FCH: Consolidation Entries Writeback
Short Name: FCH_ENTRY_WRITEBACK
DB package: GCS_XML_DT_UTILITY_PKG
Run
GCS Consolidation Entries Writeback and other Oracle EBS reports with Blitz Report™ on our demo environment
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(+) |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Entry Id |
|
Char | |
Reversal Entry Id |
|
Char | |
Ledger Id |
|
Char | |
Period Name |
|
Char | |
Conversion Type |
|
Char |