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
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
 
Reversal Entry Id
 
Ledger Id
 
Period Name
 
Conversion Type