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_ENC_CARRYFWD_T

Line 2670: ' FROM FII_GL_ENC_CARRYFWD_T stg '||

2666: ' stg.other_amount_B, stg.other_amount_B, '||
2667: ' stg.posted_date, stg.creation_date, stg.created_by, '||
2668: ' stg.last_update_date, stg.last_update_login, '||
2669: ' stg.last_updated_by '||
2670: ' FROM FII_GL_ENC_CARRYFWD_T stg '||
2671: ' WHERE stg.functional_currency = :global_prim_curr '||
2672: ' AND stg.year IS NOT NULL ';
2673:
2674: -- Print out the dynamic SQL statements if running in debug mode

Line 2747: ' FROM fii_gl_enc_carryfwd_t stg '||

2743: ' NVL(stg.day, NVL(stg.period, NVL(stg.quarter, stg.year))), '||
2744: ' company_id, cost_center_id, fin_category_id, '||
2745: ' prod_category_id, user_dim1_id, user_dim2_id, '||
2746: ' committed_amount_b, obligated_amount_b, other_amount_b '||
2747: ' FROM fii_gl_enc_carryfwd_t stg '||
2748: ' WHERE functional_currency = :global_primary) ';
2749:
2750: -- Print out the dynamic SQL statements if running in debug mode
2751: IF g_debug_flag = 'Y' THEN

Line 2775: -- Insert new data from fii_gl_enc_carryfwd_t into fii_gl_enc_carryfwd_f

2771: fii_util.print_timer('Duration');
2772: END IF;
2773:
2774: ---------------------------------------------------------------------------
2775: -- Insert new data from fii_gl_enc_carryfwd_t into fii_gl_enc_carryfwd_f
2776: ---------------------------------------------------------------------------
2777: IF g_debug_flag = 'Y' THEN
2778: fii_util.put_line(' ');
2779: fii_util.put_line('Insert new data into fii_gl_enc_carryfwd_f...');

Line 2813: ' FROM FII_GL_ENC_CARRYFWD_T '||

2809: ' obligated_amount_B, obligated_amount_B, '||
2810: ' other_amount_B, other_amount_B, posted_date, '||
2811: ' creation_date, created_by, last_update_date, '||
2812: ' last_update_login, last_updated_by '||
2813: ' FROM FII_GL_ENC_CARRYFWD_T '||
2814: ' WHERE functional_currency = :global_primary '||
2815: ' AND year IS NOT NULL '||
2816: ' AND (NVL(day, NVL(period, NVL(quarter, year))), '||
2817: ' company_id, cost_center_id, fin_category_id, '||

Line 2883: FROM fii_gl_enc_carryfwd_t t,

2879: -- Cursor for checking if we have encumrbance amounts not in
2880: -- global primary currency
2881: CURSOR fcurrCursor (global_prim_curr VARCHAR2) IS
2882: SELECT DISTINCT sob.name, t.functional_currency
2883: FROM fii_gl_enc_carryfwd_t t,
2884: gl_ledgers_public_v sob
2885: WHERE t.functional_currency NOT IN (global_prim_curr)
2886: AND t.ledger_id = sob.ledger_id;
2887:

Line 2895: fii_util.put_line('Truncate fii_gl_enc_carryfwd_t...');

2891: -- Truncate fii_gl_enc_carrfywd_t
2892: ---------------------------------------------------------------------------
2893: IF g_debug_flag = 'Y' THEN
2894: fii_util.put_line(' ');
2895: fii_util.put_line('Truncate fii_gl_enc_carryfwd_t...');
2896: END IF;
2897: TRUNCATE_TABLE('FII_GL_ENC_CARRYFWD_T');
2898:
2899: ---------------------------------------------------------------------------

Line 2897: TRUNCATE_TABLE('FII_GL_ENC_CARRYFWD_T');

2893: IF g_debug_flag = 'Y' THEN
2894: fii_util.put_line(' ');
2895: fii_util.put_line('Truncate fii_gl_enc_carryfwd_t...');
2896: END IF;
2897: TRUNCATE_TABLE('FII_GL_ENC_CARRYFWD_T');
2898:
2899: ---------------------------------------------------------------------------
2900: -- If initial load, truncate fii_gl_enc_carrfywd_f as well
2901: ---------------------------------------------------------------------------

Line 2913: g_phase := 'Inserting encumbrance carry forward into fii_gl_enc_carryfwd_t';

2909:
2910: ---------------------------------------------------------------------------
2911: -- Insert encumbrance carry forward amounts into staging table
2912: ---------------------------------------------------------------------------
2913: g_phase := 'Inserting encumbrance carry forward into fii_gl_enc_carryfwd_t';
2914: IF g_debug_flag = 'Y' THEN
2915: fii_util.put_line(' ');
2916: fii_util.put_line('Insert carryforward data into fii_gl_enc_carryfwd_t...');
2917: fii_util.start_timer;

Line 2916: fii_util.put_line('Insert carryforward data into fii_gl_enc_carryfwd_t...');

2912: ---------------------------------------------------------------------------
2913: g_phase := 'Inserting encumbrance carry forward into fii_gl_enc_carryfwd_t';
2914: IF g_debug_flag = 'Y' THEN
2915: fii_util.put_line(' ');
2916: fii_util.put_line('Insert carryforward data into fii_gl_enc_carryfwd_t...');
2917: fii_util.start_timer;
2918: fii_util.put_line('');
2919: END IF;
2920:

Line 2933: 'INSERT /+ append parallel(fii_gl_enc_carryfwd_t) / '||

2929: FROM gl_encumbrance_types
2930: WHERE encumbrance_type = 'Commitment';
2931:
2932: l_tmpstmt :=
2933: 'INSERT /*+ append parallel(fii_gl_enc_carryfwd_t) */ '||
2934: ' INTO fii_gl_enc_carryfwd_t '||
2935: ' (day, period, quarter, year, '||
2936: ' company_id, cost_center_id, fin_category_id, '||
2937: ' prod_category_id, user_dim1_id, user_dim2_id, '||

Line 2934: ' INTO fii_gl_enc_carryfwd_t '||

2930: WHERE encumbrance_type = 'Commitment';
2931:
2932: l_tmpstmt :=
2933: 'INSERT /*+ append parallel(fii_gl_enc_carryfwd_t) */ '||
2934: ' INTO fii_gl_enc_carryfwd_t '||
2935: ' (day, period, quarter, year, '||
2936: ' company_id, cost_center_id, fin_category_id, '||
2937: ' prod_category_id, user_dim1_id, user_dim2_id, '||
2938: ' je_source, je_category, '||

Line 3055: ' rows into FII_GL_ENC_CARRYFWD_T');

3051: END IF;
3052:
3053: IF g_debug_flag = 'Y' THEN
3054: fii_util.put_line('Inserted '||SQL%ROWCOUNT||
3055: ' rows into FII_GL_ENC_CARRYFWD_T');
3056: fii_util.stop_timer;
3057: fii_util.print_timer('Duration');
3058: END IF;
3059:

Line 3103: -- in fii_gl_enc_carryfwd_t

3099:
3100:
3101: ---------------------------------------------------------------------------
3102: -- Rollup daily slices into monthly/quarterly/yearly slices
3103: -- in fii_gl_enc_carryfwd_t
3104: --
3105: -- Since we will only include records where functional_currency =
3106: -- global primary for this release, we will only rollup data that satisfy
3107: -- this criteria.

Line 3121: ' INSERT /+ append parallel(fii_gl_enc_carryfwd_t) / '||

3117: fii_util.put_line('');
3118: END IF;
3119:
3120: l_sqlstmt :=
3121: ' INSERT /*+ append parallel(fii_gl_enc_carryfwd_t) */ '||
3122: ' INTO fii_gl_enc_carryfwd_t '||
3123: ' (period, quarter, year, '||
3124: ' company_id, cost_center_id, fin_category_id, '||
3125: ' prod_category_id, user_dim1_id, user_dim2_id, '||

Line 3122: ' INTO fii_gl_enc_carryfwd_t '||

3118: END IF;
3119:
3120: l_sqlstmt :=
3121: ' INSERT /*+ append parallel(fii_gl_enc_carryfwd_t) */ '||
3122: ' INTO fii_gl_enc_carryfwd_t '||
3123: ' (period, quarter, year, '||
3124: ' company_id, cost_center_id, fin_category_id, '||
3125: ' prod_category_id, user_dim1_id, user_dim2_id, '||
3126: ' je_source, je_category, '||

Line 3144: ' FROM fii_gl_enc_carryfwd_t t, '||

3140: ' SUM(t.other_amount_b) other_amount_b, '||
3141: ' t.posted_date, t.last_update_date, '||
3142: ' t.last_updated_by, t.creation_date, t.created_by, '||
3143: ' t.last_update_login '||
3144: ' FROM fii_gl_enc_carryfwd_t t, '||
3145: ' fii_time_day fday '||
3146: ' WHERE t.day = fday.report_date_julian '||
3147: ' AND t.functional_currency = :global_primary '||
3148: ' GROUP BY t.company_id, t.cost_center_id, t.fin_category_id, '||

Line 3178: ' rows into FII_GL_ENC_CARRYFWD_T');

3174: EXECUTE IMMEDIATE l_sqlstmt USING g_prim_currency;
3175:
3176: IF g_debug_flag = 'Y' THEN
3177: fii_util.put_line('Inserted '|| SQL%ROWCOUNT||
3178: ' rows into FII_GL_ENC_CARRYFWD_T');
3179: fii_util.stop_timer;
3180: fii_util.print_timer('Duration');
3181: END IF;
3182: