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 1129: insert into fa_xla_ext_lines_b_gt (

1125: if (not fa_xla_extract_util_pkg.G_secondary_special) then
1126:
1127:
1128:
1129: insert into fa_xla_ext_lines_b_gt (
1130: EVENT_ID ,
1131: LINE_NUMBER ,
1132: DISTRIBUTION_ID ,
1133: DISTRIBUTION_TYPE_CODE ,

Line 1350: insert into fa_xla_ext_lines_b_gt (

1346: fa_xla_extract_util_pkg.G_secondary_special) then
1347:
1348:
1349:
1350: insert into fa_xla_ext_lines_b_gt (
1351: EVENT_ID ,
1352: LINE_NUMBER ,
1353: DISTRIBUTION_ID ,
1354: DISTRIBUTION_TYPE_CODE ,

Line 1624: insert into fa_xla_ext_lines_b_gt (

1620: if (not fa_xla_extract_util_pkg.G_secondary_special) then
1621:
1622:
1623:
1624: insert into fa_xla_ext_lines_b_gt (
1625: EVENT_ID ,
1626: LINE_NUMBER ,
1627: DISTRIBUTION_ID ,
1628: DISTRIBUTION_TYPE_CODE ,

Line 1809: insert into fa_xla_ext_lines_b_gt (

1805: fa_xla_extract_util_pkg.G_secondary_special) then
1806:
1807:
1808:
1809: insert into fa_xla_ext_lines_b_gt (
1810: EVENT_ID ,
1811: LINE_NUMBER ,
1812: DISTRIBUTION_ID ,
1813: DISTRIBUTION_TYPE_CODE ,

Line 2047: insert into fa_xla_ext_lines_b_gt (

2043: if (not fa_xla_extract_util_pkg.G_secondary_special) then
2044:
2045:
2046:
2047: insert into fa_xla_ext_lines_b_gt (
2048: EVENT_ID ,
2049: LINE_NUMBER ,
2050: DISTRIBUTION_ID ,
2051: DISTRIBUTION_TYPE_CODE ,

Line 2222: insert into fa_xla_ext_lines_b_gt (

2218: fa_xla_extract_util_pkg.G_secondary_special) then
2219:
2220:
2221:
2222: insert into fa_xla_ext_lines_b_gt (
2223: EVENT_ID ,
2224: LINE_NUMBER ,
2225: DISTRIBUTION_ID ,
2226: DISTRIBUTION_TYPE_CODE ,

Line 2449: insert into fa_xla_ext_lines_b_gt (

2445: if (not fa_xla_extract_util_pkg.G_secondary_special) then
2446:
2447:
2448:
2449: insert into fa_xla_ext_lines_b_gt (
2450: EVENT_ID ,
2451: LINE_NUMBER ,
2452: DISTRIBUTION_ID ,
2453: DISTRIBUTION_TYPE_CODE ,

Line 2602: insert into fa_xla_ext_lines_b_gt (

2598: fa_xla_extract_util_pkg.G_secondary_special) then
2599:
2600:
2601:
2602: insert into fa_xla_ext_lines_b_gt (
2603: EVENT_ID ,
2604: LINE_NUMBER ,
2605: DISTRIBUTION_ID ,
2606: DISTRIBUTION_TYPE_CODE ,

Line 2762: insert into fa_xla_ext_lines_b_gt (

2758: if (not fa_xla_extract_util_pkg.G_secondary_special) then
2759:
2760:
2761:
2762: insert into fa_xla_ext_lines_b_gt (
2763: EVENT_ID ,
2764: LINE_NUMBER ,
2765: DISTRIBUTION_ID ,
2766: DISTRIBUTION_TYPE_CODE ,

Line 2909: insert into fa_xla_ext_lines_b_gt (

2905: fa_xla_extract_util_pkg.G_secondary_special) then
2906:
2907:
2908:
2909: insert into fa_xla_ext_lines_b_gt (
2910: EVENT_ID ,
2911: LINE_NUMBER ,
2912: DISTRIBUTION_ID ,
2913: DISTRIBUTION_TYPE_CODE ,

Line 3108: insert into fa_xla_ext_lines_b_gt (

3104: if (not fa_xla_extract_util_pkg.G_secondary_special) then
3105:
3106:
3107:
3108: insert into fa_xla_ext_lines_b_gt (
3109: EVENT_ID ,
3110: LINE_NUMBER ,
3111: DISTRIBUTION_ID ,
3112: DISTRIBUTION_TYPE_CODE ,

Line 3267: insert into fa_xla_ext_lines_b_gt (

3263: fa_xla_extract_util_pkg.G_secondary_special) then
3264:
3265:
3266:
3267: insert into fa_xla_ext_lines_b_gt (
3268: EVENT_ID ,
3269: LINE_NUMBER ,
3270: DISTRIBUTION_ID ,
3271: DISTRIBUTION_TYPE_CODE ,

Line 3479: insert into fa_xla_ext_lines_b_gt (

3475: if (not fa_xla_extract_util_pkg.G_secondary_special) then
3476:
3477:
3478:
3479: insert into fa_xla_ext_lines_b_gt (
3480: EVENT_ID ,
3481: LINE_NUMBER ,
3482: DISTRIBUTION_ID ,
3483: DISTRIBUTION_TYPE_CODE ,

Line 3638: insert into fa_xla_ext_lines_b_gt (

3634: fa_xla_extract_util_pkg.G_secondary_special) then
3635:
3636:
3637:
3638: insert into fa_xla_ext_lines_b_gt (
3639: EVENT_ID ,
3640: LINE_NUMBER ,
3641: DISTRIBUTION_ID ,
3642: DISTRIBUTION_TYPE_CODE ,

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

3932:
3933: l_last_book varchar2(30) := ' ';
3934:
3935: cursor c_trx is
3936: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
3937: xl.rowid,
3938: xb.book_type_code,
3939: xl.distribution_id,
3940: xl.expense_account_ccid,

Line 4118: fa_xla_ext_lines_b_gt xl,

4114: 'BONUS EXPENSE', xl.DEPRN_RESERVE_ACCT,
4115: NULL)
4116: from xla_events_gt xg,
4117: fa_xla_ext_headers_b_gt xb,
4118: fa_xla_ext_lines_b_gt xl,
4119: fa_distribution_accounts da
4120: where xg.event_class_code not in ('DEPRECIATION', 'DEFERRED')
4121: and xb.event_id = xg.event_id
4122: and xl.event_id = xg.event_id

Line 4260: update fa_xla_ext_lines_b_gt

4256: l_ctr_generated_off_ccid(i) := l_adj_tbl(i).counter_generated_offset_ccid;
4257: end loop;
4258:
4259: forall i in 1..l_adj_tbl.count
4260: update fa_xla_ext_lines_b_gt
4261: set generated_ccid = l_generated_ccid(i),
4262: generated_offset_ccid = l_generated_offset_ccid(i),
4263: counter_generated_ccid = l_counter_generated_ccid(i), -- Bug 6962827
4264: counter_generated_offset_ccid = l_ctr_generated_off_ccid(i) -- Bug 6962827