GCS Data Submission Impacted Balances Data Source

Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_DS_IMPACTED_BAL_SOURCE
DB package: GCS_XML_DT_UTILITY_PKG
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
Ask a question