APPS.FII_GL_BUDGET_EXTRACTION dependencies on GL_LEDGERS_PUBLIC_V

Line 150: gl_ledgers_public_v sob,

146: SELECT /*+ use_nl (setup) use_nl(sob) use_nl(per) use_nl(bud) */
147: sob.name ledger_name, bud.budget_name, per.period_name
148: from fii_slg_budget_asgns setup,
149: gl_periods per,
150: gl_ledgers_public_v sob,
151: gl_budgets_v bud
152: where setup.budget_version_id = bud.budget_version_id
153: and sob.ledger_id = setup.ledger_id
154: and sob.period_set_name = per.period_set_name

Line 164: gl_ledgers_public_v sob

160: MINUS
161: SELECT /*+ use_hash(budv, t) parallel(t) */
162: sob.name ledger_name, budv.budget_name, t.period_name
163: from fii_gl_budget_extract_t t, gl_budget_versions budv,
164: gl_ledgers_public_v sob
165: where t.budget_version_id = budv.budget_version_id
166: and t.ledger_id = sob.ledger_id
167: and t.currency_code = g_prim_curr;
168:

Line 181: gl_ledgers_public_v sob,

177: SELECT /*+ use_nl (setup) use_nl(sob) use_nl(per) use_nl(bud) */
178: sob.name ledger_name, bud.budget_name, per.period_name
179: from fii_slg_budget_asgns setup,
180: gl_periods per,
181: gl_ledgers_public_v sob,
182: gl_budgets_v bud
183: where setup.budget_version_id = bud.budget_version_id
184: and sob.ledger_id = setup.ledger_id
185: and sob.period_set_name = per.period_set_name

Line 195: gl_ledgers_public_v sob

191: MINUS
192: SELECT /*+ use_hash(budv, t) parallel(t) */
193: sob.name ledger_name, budv.budget_name, t.period_name
194: from fii_gl_budget_extract_t t, gl_budget_versions budv,
195: gl_ledgers_public_v sob
196: where t.budget_version_id = budv.budget_version_id
197: and t.ledger_id = sob.ledger_id
198: and t.currency_code = g_sec_curr;
199:

Line 210: GL_LEDGERS_PUBLIC_V sob,

206: glv.concatenated_segments,
207: sob.name ledger_name,
208: budv.budget_name
209: FROM FII_GL_BUDGET_EXTRACT_T t,
210: GL_LEDGERS_PUBLIC_V sob,
211: GL_BUDGET_VERSIONS budv,
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

Line 384: GL_LEDGERS_PUBLIC_V sob,

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,
385: FII_FIN_CAT_TYPE_ASSGNS fincat
386: WHERE fincat.fin_category_id (+) = ccid.natural_account_id
387: AND (fincat.fin_cat_type_code IN ('EXP','R') OR fincat.fin_cat_type_code IS NULL) -- if NULL then amounts will be both 0
388: AND bal.code_combination_id = ccid.code_combination_id (+)

Line 634: GL_LEDGERS_PUBLIC_V sob,

630: g_fii_login_id
631: FROM FII_GL_BUDGET_EXTRACT_T t,
632: FII_TIME_ENT_PERIOD period,
633: GL_PERIODS glper,
634: GL_LEDGERS_PUBLIC_V sob,
635: fii_slg_budget_asgns setup
636: WHERE t.period_name = glper.period_name
637: ANd sob.ledger_id = t.ledger_id
638: AND sob.period_set_name = glper.period_set_name