GCS Data Submission Impacted Balances Data Source

➜ Back to Library
Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_DS_IMPACTED_BAL_SOURCE
DB package: GCS_XML_DT_UTILITY_PKG
Run GCS Data Submission Impacted Balances Data Source and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT fcov.company_cost_center_org_name ORGANIZATION,
                      fliv.line_item_name LINEITEM,
                      fciv.company_cost_center_org_name INTERCOMPANY,
                      /*startSelectList*/		ffeb.financial_elem_name , 
		fnab.natural_account_name , 
		fpb.product_name , 
		fpjb.project_name , 
		ftb.task_name , 
		fud1.user_dim1_name , 
  /*endSelectList*/
                      fb.debit DEBIT,
                      fb.credit	CREDIT
               FROM
                    ( SELECT fiocm.company_cost_center_org_id,
                             fiocm.line_item_id ,
                             /*startSelectIdList*/		decode (EXTENDED_ACCOUNT_TYPE,'REVENUE',455,'EXPENSE',457,100) financial_elem_id, 
		fiocm.natural_account_id , 
		fiocm.product_id , 
		fiocm.project_id , 
		fiocm.task_id , 
		fiocm.user_dim1_id , 
  /*endSelectIdList*/
                             fiocm.intercompany_id, 
                             SUM(nvl(gbd.period_net_dr,0)) debit,
                             SUM(nvl(gbd.period_net_cr,0)) credit
                       FROM  gl_balances_delta gbd,
                             fem_intg_ogl_ccid_map fiocm,
                             gl_code_combinations gcc,
                             fem_intg_delta_loads fidl
                       WHERE fiocm.code_combination_id = gbd.code_combination_id 
                       AND   gbd.delta_run_id          > fidl.delta_run_id      
                       AND   gcc.code_combination_id   = gbd.code_combination_id
                       AND   fidl.loaded_flag          = 'Y'
                       AND   fidl.cal_period_id        = :pCalPeriodId
                       AND   (gbd.period_net_dr <>0 OR gbd.period_net_cr <> 0)
                       &FilterParamsLiteral
                      GROUP BY fiocm.company_cost_center_org_id,
                               fiocm.line_item_id,
                               /*startDSTBGroupbyName*/		decode (EXTENDED_ACCOUNT_TYPE,'REVENUE',455,'EXPENSE',457,100) , 
		fiocm.natural_account_id , 
		fiocm.product_id , 
		fiocm.project_id , 
		fiocm.task_id , 
		fiocm.user_dim1_id , 
  /*endDSTBGroupbyName*/
                               fiocm.intercompany_id ) fb,
                     fem_cctr_orgs_tl fcov,
                     fem_ln_items_tl fliv,
                     /*startFromList*/                  fem_fin_elems_tl ffeb,			
                  fem_nat_accts_tl fnab,			
                  fem_products_tl fpb,			
                  fem_projects_tl fpjb,			
                  fem_tasks_tl ftb,			
                  FEM_USER_DIM1_TL fud1,			
  /*endFromList*/
                     fem_cctr_orgs_tl fciv                 
               WHERE fb.company_cost_center_org_id = fcov.company_cost_center_org_id	
               AND   fcov.language                 = :pLanguageCode	
               AND   fb.line_item_id               = fliv.line_item_id
               AND   fliv.language                 = :pLanguageCode
               AND   fb.intercompany_id            = fciv.company_cost_center_org_id
               AND   fciv.language                 = :pLanguageCode
               /*startWhereClause*/	AND	ffeb.financial_elem_id = fb.financial_elem_id		
	AND	ffeb.language  = :pLanguageCode
	AND	fnab.natural_account_id = fb.natural_account_id		
	AND	fnab.language  = :pLanguageCode
	AND	fpb.product_id = fb.product_id		
	AND	fpb.language  = :pLanguageCode
	AND	fpjb.project_id = fb.project_id		
	AND	fpjb.language  = :pLanguageCode
	AND	ftb.task_id = fb.task_id		
	AND	ftb.language  = :pLanguageCode
	AND	fud1.user_dim1_id = fb.user_dim1_id		
	AND	fud1.language  = :pLanguageCode
  /*endWhereClause*/
               &entityOrgsLiteral
Download
Related Blitz Reports
GCS Data Submission Impacted Balances Base Data Source GCS Unmapped Data Submission Trial Balance Data Source GCS Intercompany Matching Data Source for Consolidation Entities GCS Intercompany Matching Data Source FEM Writeback Balances to General Gedger Error Base Data Source GCS Intercompany Matching Base Data Source for Consolidation Entities GCS Intercompany Matching Base Data Source GCS Value Set Map Validation Data Source GCS Value Set Map Validation Base Data Source
Blitz Report™

Blitz Report™ provides multiple benefits: