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.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_XLA_EXT_LINES_B_GT

Line 641: insert into fa_xla_ext_lines_b_gt (

637: 'Beginning of procedure');
638: END IF;
639:
640:
641: insert into fa_xla_ext_lines_b_gt (
642: EVENT_ID ,
643: LINE_NUMBER ,
644: DISTRIBUTION_ID ,
645: DISTRIBUTION_TYPE_CODE ,

Line 805: insert into fa_xla_ext_lines_b_gt (

801: if (fa_xla_extract_util_pkg.G_alc_enabled) then
802:
803:
804:
805: insert into fa_xla_ext_lines_b_gt (
806: EVENT_ID ,
807: LINE_NUMBER ,
808: DISTRIBUTION_ID ,
809: DISTRIBUTION_TYPE_CODE ,

Line 1013: insert into fa_xla_ext_lines_b_gt (

1009: 'Beginning of procedure');
1010: END IF;
1011:
1012:
1013: insert into fa_xla_ext_lines_b_gt (
1014: EVENT_ID ,
1015: LINE_NUMBER ,
1016: DISTRIBUTION_ID ,
1017: DISTRIBUTION_TYPE_CODE ,

Line 1159: insert into fa_xla_ext_lines_b_gt (

1155: if (fa_xla_extract_util_pkg.G_alc_enabled) then
1156:
1157:
1158:
1159: insert into fa_xla_ext_lines_b_gt (
1160: EVENT_ID ,
1161: LINE_NUMBER ,
1162: DISTRIBUTION_ID ,
1163: DISTRIBUTION_TYPE_CODE ,

Line 1349: insert into fa_xla_ext_lines_b_gt (

1345: 'Beginning of procedure');
1346: END IF;
1347:
1348:
1349: insert into fa_xla_ext_lines_b_gt (
1350: EVENT_ID ,
1351: LINE_NUMBER ,
1352: DISTRIBUTION_ID ,
1353: DISTRIBUTION_TYPE_CODE ,

Line 1485: insert into fa_xla_ext_lines_b_gt (

1481: if (fa_xla_extract_util_pkg.G_alc_enabled) then
1482:
1483:
1484:
1485: insert into fa_xla_ext_lines_b_gt (
1486: EVENT_ID ,
1487: LINE_NUMBER ,
1488: DISTRIBUTION_ID ,
1489: DISTRIBUTION_TYPE_CODE ,

Line 1664: insert into fa_xla_ext_lines_b_gt (

1660: 'Beginning of procedure');
1661: END IF;
1662:
1663:
1664: insert into fa_xla_ext_lines_b_gt (
1665: EVENT_ID ,
1666: LINE_NUMBER ,
1667: DISTRIBUTION_ID ,
1668: DISTRIBUTION_TYPE_CODE ,

Line 1790: insert into fa_xla_ext_lines_b_gt (

1786: if (fa_xla_extract_util_pkg.G_alc_enabled) then
1787:
1788:
1789:
1790: insert into fa_xla_ext_lines_b_gt (
1791: EVENT_ID ,
1792: LINE_NUMBER ,
1793: DISTRIBUTION_ID ,
1794: DISTRIBUTION_TYPE_CODE ,

Line 1919: insert into fa_xla_ext_lines_b_gt (

1915: 'Rows inserted into lines: ' || to_char(SQL%ROWCOUNT));
1916: END IF;
1917:
1918:
1919: insert into fa_xla_ext_lines_b_gt (
1920: EVENT_ID ,
1921: LINE_NUMBER ,
1922: DISTRIBUTION_ID ,
1923: DISTRIBUTION_TYPE_CODE ,

Line 2039: insert into fa_xla_ext_lines_b_gt (

2035: if (fa_xla_extract_util_pkg.G_alc_enabled) then
2036:
2037:
2038:
2039: insert into fa_xla_ext_lines_b_gt (
2040: EVENT_ID ,
2041: LINE_NUMBER ,
2042: DISTRIBUTION_ID ,
2043: DISTRIBUTION_TYPE_CODE ,

Line 2202: insert into fa_xla_ext_lines_b_gt (

2198: 'Beginning of procedure');
2199: END IF;
2200:
2201:
2202: insert into fa_xla_ext_lines_b_gt (
2203: EVENT_ID ,
2204: LINE_NUMBER ,
2205: DISTRIBUTION_ID ,
2206: DISTRIBUTION_TYPE_CODE ,

Line 2334: insert into fa_xla_ext_lines_b_gt (

2330: if (fa_xla_extract_util_pkg.G_alc_enabled) then
2331:
2332:
2333:
2334: insert into fa_xla_ext_lines_b_gt (
2335: EVENT_ID ,
2336: LINE_NUMBER ,
2337: DISTRIBUTION_ID ,
2338: DISTRIBUTION_TYPE_CODE ,

Line 2509: insert into fa_xla_ext_lines_b_gt (

2505: 'Beginning of procedure');
2506: END IF;
2507:
2508:
2509: insert into fa_xla_ext_lines_b_gt (
2510: EVENT_ID ,
2511: LINE_NUMBER ,
2512: DISTRIBUTION_ID ,
2513: DISTRIBUTION_TYPE_CODE ,

Line 2641: insert into fa_xla_ext_lines_b_gt (

2637: if (fa_xla_extract_util_pkg.G_alc_enabled) then
2638:
2639:
2640:
2641: insert into fa_xla_ext_lines_b_gt (
2642: EVENT_ID ,
2643: LINE_NUMBER ,
2644: DISTRIBUTION_ID ,
2645: DISTRIBUTION_TYPE_CODE ,

Line 2902: select /+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) /

2898:
2899: l_last_book varchar2(15) := ' ';
2900:
2901: cursor c_trx is
2902: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
2903: xl.rowid,
2904: xb.book_type_code,
2905: xl.distribution_id,
2906: xl.expense_account_ccid,

Line 3021: fa_xla_ext_lines_b_gt xl,

3017: 'BONUS EXPENSE', xl.BONUS_RESERVE_ACCT,
3018: NULL)
3019: from xla_events_gt xg,
3020: fa_xla_ext_headers_b_gt xb,
3021: fa_xla_ext_lines_b_gt xl,
3022: fa_distribution_accounts da
3023: where xg.event_class_code not in ('DEPRECIATION', 'DEFERRED')
3024: and xb.event_id = xg.event_id
3025: and xl.event_id = xg.event_id

Line 3111: update fa_xla_ext_lines_b_gt

3107:
3108: end loop;
3109:
3110: forall i in 1..l_adj_tbl.count
3111: update fa_xla_ext_lines_b_gt
3112: set generated_ccid = l_generated_ccid(i),
3113: generated_offset_ccid = l_generated_offset_ccid(i)
3114: where rowid = l_rowid(i);
3115: