ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFA63869E053B46B63588994Y 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 GCS GCS_DS_IMPACTED_BAL_SOURCE US GCS Data Submission Impacted Balances Data Source Application: Financial Consolidation Hub (Obsolete) Source: Short Name: GCS_DS_IMPACTED_BAL_SOURCE DB package: GCS_XML_DT_UTILITY_PKG BI Publisher &entityorgsliteral &filterparamsliteral :pcalperiodid :planguagecode