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 |
