eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_GL_JE_B_C dependencies on FII_GL_JE_SUMMARY_B

Line 452: FROM fii_gl_je_summary_b

448:
449: begin
450: SELECT 1
451: INTO l_count1
452: FROM fii_gl_je_summary_b
453: WHERE ROWNUM = 1;
454: exception
455: when NO_DATA_FOUND then
456: l_count1 := 0;

Line 527: FROM fii_gl_je_summary_b

523:
524: begin
525: SELECT 1
526: INTO l_count1
527: FROM fii_gl_je_summary_b
528: WHERE ROWNUM = 1;
529: exception
530: when NO_DATA_FOUND then
531: l_count1 := 0;

Line 1143: -- FII_GL_JE_SUMMARY_STG into GL base summary table FII_GL_JE_SUMMARY_B.

1139: BEGIN
1140:
1141: ----------------------------------------------------------------------
1142: -- Merges newly collected/summarized records from temporary table
1143: -- FII_GL_JE_SUMMARY_STG into GL base summary table FII_GL_JE_SUMMARY_B.
1144: -- FII_GL_JE_SUMMARY_B uses the nested summary table structure.
1145:
1146: -- If the merging record is new in FII_GL_JE_SUMMARY_STG then the record
1147: -- will be inserted into FII_GL_JE_SUMMARY_B table. A merging reord is

Line 1144: -- FII_GL_JE_SUMMARY_B uses the nested summary table structure.

1140:
1141: ----------------------------------------------------------------------
1142: -- Merges newly collected/summarized records from temporary table
1143: -- FII_GL_JE_SUMMARY_STG into GL base summary table FII_GL_JE_SUMMARY_B.
1144: -- FII_GL_JE_SUMMARY_B uses the nested summary table structure.
1145:
1146: -- If the merging record is new in FII_GL_JE_SUMMARY_STG then the record
1147: -- will be inserted into FII_GL_JE_SUMMARY_B table. A merging reord is
1148: -- consoidered if the combination of period, Period_type,

Line 1147: -- will be inserted into FII_GL_JE_SUMMARY_B table. A merging reord is

1143: -- FII_GL_JE_SUMMARY_STG into GL base summary table FII_GL_JE_SUMMARY_B.
1144: -- FII_GL_JE_SUMMARY_B uses the nested summary table structure.
1145:
1146: -- If the merging record is new in FII_GL_JE_SUMMARY_STG then the record
1147: -- will be inserted into FII_GL_JE_SUMMARY_B table. A merging reord is
1148: -- consoidered if the combination of period, Period_type,
1149: -- Cost center Organization id, natural Account, Journal Entry source,
1150: -- Journal Entry category, Set Of Books Id, Functional Currency Code,
1151: -- Company and Product code feilds is not present in the

Line 1152: -- FII_GL_JE_SUMMARY_B table.

1148: -- consoidered if the combination of period, Period_type,
1149: -- Cost center Organization id, natural Account, Journal Entry source,
1150: -- Journal Entry category, Set Of Books Id, Functional Currency Code,
1151: -- Company and Product code feilds is not present in the
1152: -- FII_GL_JE_SUMMARY_B table.
1153: -----------------------------------------------------------------------
1154:
1155: g_phase := 'Merging records into FII_GL_JE_SUMMARY_B';
1156:

Line 1155: g_phase := 'Merging records into FII_GL_JE_SUMMARY_B';

1151: -- Company and Product code feilds is not present in the
1152: -- FII_GL_JE_SUMMARY_B table.
1153: -----------------------------------------------------------------------
1154:
1155: g_phase := 'Merging records into FII_GL_JE_SUMMARY_B';
1156:
1157: if g_debug_flag = 'Y' then
1158: FII_UTIL.put_line('Merging records into FII_GL_JE_SUMMARY_B');
1159: FII_UTIL.start_timer;

Line 1158: FII_UTIL.put_line('Merging records into FII_GL_JE_SUMMARY_B');

1154:
1155: g_phase := 'Merging records into FII_GL_JE_SUMMARY_B';
1156:
1157: if g_debug_flag = 'Y' then
1158: FII_UTIL.put_line('Merging records into FII_GL_JE_SUMMARY_B');
1159: FII_UTIL.start_timer;
1160: end if;
1161:
1162: MERGE INTO fii_gl_je_summary_b bsum

Line 1162: MERGE INTO fii_gl_je_summary_b bsum

1158: FII_UTIL.put_line('Merging records into FII_GL_JE_SUMMARY_B');
1159: FII_UTIL.start_timer;
1160: end if;
1161:
1162: MERGE INTO fii_gl_je_summary_b bsum
1163: USING
1164: (SELECT NVL(day, NVL(week, NVL(period, NVL(quarter, year)))) TIME_ID,
1165: DECODE(day, null,
1166: DECODE(week, null,

Line 1294: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' rows of records into FII_GL_JE_SUMMARY_B');

1290: g_fii_user_id);
1291:
1292:
1293: if g_debug_flag = 'Y' then
1294: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' rows of records into FII_GL_JE_SUMMARY_B');
1295: FII_UTIL.stop_timer;
1296: FII_UTIL.print_timer('Duration');
1297: end if;
1298:

Line 2175: g_phase := 'Inserting into fii_gl_je_summary_b';

2171: fii_util.start_timer;
2172: fii_util.put_line('');
2173: end if;
2174:
2175: g_phase := 'Inserting into fii_gl_je_summary_b';
2176: INSERT /*+ append parallel(fii_gl_je_summary_b) */ INTO fii_gl_je_summary_b
2177: (time_id,
2178: period_type_id,
2179: cost_center_id,

Line 2176: INSERT /+ append parallel(fii_gl_je_summary_b) / INTO fii_gl_je_summary_b

2172: fii_util.put_line('');
2173: end if;
2174:
2175: g_phase := 'Inserting into fii_gl_je_summary_b';
2176: INSERT /*+ append parallel(fii_gl_je_summary_b) */ INTO fii_gl_je_summary_b
2177: (time_id,
2178: period_type_id,
2179: cost_center_id,
2180: fin_category_id,

Line 2236: FROM fii_gl_je_summary_b bsum,

2232: bsum.last_updated_by,
2233: bsum.creation_date,
2234: bsum.created_by,
2235: bsum.last_update_login
2236: FROM fii_gl_je_summary_b bsum,
2237: fii_time_day fday
2238: WHERE bsum.time_id = fday.report_date_julian
2239: GROUP BY
2240: bsum.cost_center_id,

Line 2261: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into FII_GL_JE_SUMMARY_B');

2257: fday.week_id,
2258: bsum.posted_date ;
2259:
2260: if g_debug_flag = 'Y' then
2261: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into FII_GL_JE_SUMMARY_B');
2262: fii_util.stop_timer;
2263: fii_util.print_timer('Duration');
2264: end if;
2265:

Line 2309: g_phase := 'Inserting into fii_gl_je_summary_b';

2305: end if;
2306:
2307: --Bug 3121847: removed delete in ROLL_UP2 by filtering it out during insert
2308:
2309: g_phase := 'Inserting into fii_gl_je_summary_b';
2310: INSERT /*+ append parallel(fii_gl_je_summary_b) */ INTO fii_gl_je_summary_b
2311: (time_id,
2312: period_type_id,
2313: cost_center_id,

Line 2310: INSERT /+ append parallel(fii_gl_je_summary_b) / INTO fii_gl_je_summary_b

2306:
2307: --Bug 3121847: removed delete in ROLL_UP2 by filtering it out during insert
2308:
2309: g_phase := 'Inserting into fii_gl_je_summary_b';
2310: INSERT /*+ append parallel(fii_gl_je_summary_b) */ INTO fii_gl_je_summary_b
2311: (time_id,
2312: period_type_id,
2313: cost_center_id,
2314: fin_category_id,

Line 2370: FROM fii_gl_je_summary_b bsum,

2366: bsum.last_updated_by,
2367: bsum.creation_date,
2368: bsum.created_by,
2369: bsum.last_update_login
2370: FROM fii_gl_je_summary_b bsum,
2371: fii_time_day fday
2372: WHERE bsum.time_id = fday.report_date_julian
2373: GROUP BY
2374: bsum.cost_center_id,

Line 2397: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into FII_GL_JE_SUMMARY_B');

2393: fday.ent_period_id))
2394: where time_id is not null;
2395:
2396: if g_debug_flag = 'Y' then
2397: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into FII_GL_JE_SUMMARY_B');
2398: fii_util.stop_timer;
2399: fii_util.print_timer('Duration');
2400: end if;
2401:

Line 2405: --Removed delete: DELETE FROM FII_GL_JE_SUMMARY_B WHERE time_id IS NULL;

2401:
2402: commit;
2403:
2404: -------
2405: --Removed delete: DELETE FROM FII_GL_JE_SUMMARY_B WHERE time_id IS NULL;
2406: -------
2407:
2408: EXCEPTION
2409: WHEN OTHERS Then

Line 2507: insert /+ append parallel(bsum) / INTO fii_gl_je_summary_b bsum

2503: end if;
2504:
2505: --Bug 3121847: changed the second hint per performance team suggestion
2506:
2507: insert /*+ append parallel(bsum) */ INTO fii_gl_je_summary_b bsum
2508: (bsum.time_id,
2509: bsum.period_type_id,
2510: bsum.company_id,
2511: bsum.cost_center_id,

Line 2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';

2592: --Fix bug 3561245
2593: commit;
2594:
2595: --Call FND_STATS to collect statistics after populating the table
2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';
2597: FND_STATS.gather_table_stats
2598: (ownname => g_fii_schema,
2599: tabname => 'FII_GL_JE_SUMMARY_B');
2600:

Line 2599: tabname => 'FII_GL_JE_SUMMARY_B');

2595: --Call FND_STATS to collect statistics after populating the table
2596: g_phase := 'Calling FND_STATS to collect statistics for FII_GL_JE_SUMMARY_B';
2597: FND_STATS.gather_table_stats
2598: (ownname => g_fii_schema,
2599: tabname => 'FII_GL_JE_SUMMARY_B');
2600:
2601: g_phase := 'Enabling parallel dml';
2602: execute immediate 'alter session enable parallel dml';
2603:

Line 2605: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into FII_GL_JE_SUMMARY_B');

2601: g_phase := 'Enabling parallel dml';
2602: execute immediate 'alter session enable parallel dml';
2603:
2604: if g_debug_flag = 'Y' then
2605: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into FII_GL_JE_SUMMARY_B');
2606: fii_util.stop_timer;
2607: fii_util.print_timer('Duration');
2608: end if;
2609:

Line 3336: TRUNCATE_TABLE('FII_GL_JE_SUMMARY_B');

3332: IF g_debug_flag = 'Y' then
3333: FII_UTIL.put_line('Running in Initial Load mode, truncate STG, summary and other processing tables.');
3334: END IF;
3335: TRUNCATE_TABLE('FII_GL_JE_SUMMARY_STG');
3336: TRUNCATE_TABLE('FII_GL_JE_SUMMARY_B');
3337: TRUNCATE_TABLE('FII_GL_PROCESSED_HEADER_IDS');
3338:
3339: COMMIT;
3340: END IF;

Line 3851: -- FII_GL_JE_SUMMARY_B table.

3847: END IF;
3848:
3849: --------------------------------------------------------
3850: -- Call Merge routine to insert summarized data into
3851: -- FII_GL_JE_SUMMARY_B table.
3852: --------------------------------------------------------
3853: g_phase := 'Merging records into base summary table';
3854: if g_debug_flag = 'Y' then
3855: FII_UTIL.put_line('');