[Home] [Help]
115: sob.name,
116: budv.budget_name;
117: */
118: /*
119: --- Warn user of accounts not in fii_gl_ccid_dimensions (dimensions not mapped correctly)
120: --------------------------------------------------------------------------------------------
121: CURSOR miss_ccid_cur IS
122: SELECT glv.concatenated_segments,
123: sob.name ledger_name,
125: FROM fii_gl_budget_extract_t t,
126: gl_budget_versions budv,
127: gl_sets_of_books sob,
128: gl_code_combinations_kfv glv,
129: fii_gl_ccid_dimensions ccid
130: WHERE t.budget_version_id = budv.budget_version_id
131: AND t.ledger_id = sob.set_of_books_id
132: AND t.code_combination_id = glv.code_combination_id
133: AND ccid.code_combination_id (+) = t.code_combination_id
212: gl_code_combinations_kfv glv,
213: (select /*+ use_hash(fin,t,ccid) parallel(t) parallel(ccid) parallel(fin) pq_distribute(fin hash,hash) pq_distribute(ccid hash,hash)*/
214: t.code_combination_id, period_name
215: from FII_GL_BUDGET_EXTRACT_T t,
216: fii_gl_ccid_dimensions ccid,
217: fii_fin_cat_type_assgns fin
218: where ccid.code_combination_id = t.code_combination_id
219: and fin.fin_category_id = t.fin_category_id
220: and fin.fin_cat_type_code IN ('EXP','R')
376: sysdate,
377: g_fii_user_id,
378: g_fii_user_id
379: FROM GL_BALANCES bal,
380: FII_GL_CCID_DIMENSIONS ccid,
381: FII_CCC_MGR_GT cccorg,
382: FII_SLG_BUDGET_ASGNS slga,
383: GL_PERIODS glper,
384: GL_LEDGERS_PUBLIC_V sob,