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.FARX_BL dependencies on FA_BALANCES_REPORT_GT

Line 11: -- 1. Insert info into temporary table FA_BALANCES_REPORT_GT:

7: -- Performs all report activities, given book, period range,
8: -- and report type as parameters. Adj_Mode is currently not used.
9:
10: -- General Overview: Consists of two main steps:
11: -- 1. Insert info into temporary table FA_BALANCES_REPORT_GT:
12: -- A. Beginning balances for all accounts (subdivided by assets)
13: -- B. Ending balances
14: -- C. Effects of depreciation/amortization
15: -- D. Effects of transactional adjustments

Line 159: -- Used in finding account segments for FA_BALANCES_REPORT_GT

155:
156: -- Additional variables for Drill Down Report
157: h_group_asset VARCHAR2(15); -- Group Asset_number
158:
159: -- Used in finding account segments for FA_BALANCES_REPORT_GT
160:
161: CURSOR BAL_REPORT_AJCCID IS
162: SELECT DISTINCT ADJUSTMENT_CCID, CATEGORY_BOOKS_ACCOUNT, ROWID
163: FROM FA_BALANCES_REPORT_GT;

Line 163: FROM FA_BALANCES_REPORT_GT;

159: -- Used in finding account segments for FA_BALANCES_REPORT_GT
160:
161: CURSOR BAL_REPORT_AJCCID IS
162: SELECT DISTINCT ADJUSTMENT_CCID, CATEGORY_BOOKS_ACCOUNT, ROWID
163: FROM FA_BALANCES_REPORT_GT;
164:
165: -- Main selector from FA_BALANCES_REPORT_GT for asset cost
166: -- and CIP cost reports.
167:

Line 165: -- Main selector from FA_BALANCES_REPORT_GT for asset cost

161: CURSOR BAL_REPORT_AJCCID IS
162: SELECT DISTINCT ADJUSTMENT_CCID, CATEGORY_BOOKS_ACCOUNT, ROWID
163: FROM FA_BALANCES_REPORT_GT;
164:
165: -- Main selector from FA_BALANCES_REPORT_GT for asset cost
166: -- and CIP cost reports.
167:
168: CURSOR COST_REPORT (c_book VARCHAR2, c_to_date DATE, c_from_date DATE) IS /* StatReq */
169: SELECT DISTINCT

Line 214: FA_BALANCES_REPORT_GT BAL,

210: FA_ASSET_HISTORY AH, /* StatReq */
211: fa_category_books cb,
212: FA_METHODS M, /* StatReq */
213: FA_BOOKS B, /* StatReq */
214: FA_BALANCES_REPORT_GT BAL,
215: FA_ADDITIONS AD,
216: GL_CODE_COMBINATIONS DHCC,
217: GL_CODE_COMBINATIONS AJCC,
218: FA_ADDITIONS AD1,

Line 254: -- Main selector from FA_BALANCES_REPORT_GT for accum deprn

250: m.stl_method_flag,
251: m.rate_source_rule,
252: nvl(AD1.ASSET_NUMBER,LU.Meaning); -- Added for Drill Down Report
253:
254: -- Main selector from FA_BALANCES_REPORT_GT for accum deprn
255: -- and reval reserve reports.
256:
257:
258: CURSOR RESERVE_REPORT (c_book VARCHAR2, c_to_date DATE) IS /* StatReq */

Line 299: FA_BALANCES_REPORT_GT BAL,

295: FROM
296: FA_ASSET_HISTORY AH, /* StatReq */
297: FA_METHODS M, /* StatReq */
298: FA_BOOKS B, /* StatReq */
299: FA_BALANCES_REPORT_GT BAL,
300: FA_ADDITIONS AD,
301: GL_CODE_COMBINATIONS DHCC,
302: GL_CODE_COMBINATIONS AJCC,
303: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number

Line 358: FROM FA_BALANCES_REPORT_GT BAL

354:
355: -- Cursor for Drill Down Report
356: CURSOR GROUP_ASSETS IS
357: SELECT DISTINCT BAL.Group_Asset_ID Group_Asset_ID
358: FROM FA_BALANCES_REPORT_GT BAL
359: WHERE BAL.Asset_ID = BAL.Group_Asset_ID;
360:
361: CURSOR GROUP_RESERVE_AMOUNTS (p_group_asset_id number) is
362: SELECT

Line 365: FROM FA_BALANCES_REPORT_GT BAL

361: CURSOR GROUP_RESERVE_AMOUNTS (p_group_asset_id number) is
362: SELECT
363: NVL(SUM(DECODE(BAL.Source_Type_Code,
364: 'BEGIN', NVL(BAL.Cost_Begin_Balance, 0), NULL)), 0) /* StatReq */
365: FROM FA_BALANCES_REPORT_GT BAL
366: WHERE BAL.Group_Asset_id = p_group_asset_id
367: AND BAL.Group_Asset_id <> BAL.Asset_id;
368:
369: CURSOR GROUP_COST_AMOUNTS (p_group_asset_id number) is

Line 395: FROM FA_BALANCES_REPORT_GT BAL

391: SUM (DECODE (BAL.Source_Type_Code,
392: 'TRANSFER', NVL(BAL.Amount,0), NULL)),
393: NVL(SUM (DECODE (BAL.Source_Type_Code,
394: 'END', NVL(BAL.Amount,0), NULL)), 0)
395: FROM FA_BALANCES_REPORT_GT BAL
396: WHERE BAL.Group_Asset_id = p_group_asset_id
397: AND BAL.Group_Asset_id <> BAL.Asset_id;
398:
399: -- cursor non_qualified_segs is

Line 496: h_table_token := 'FA_BALANCES_REPORT_GT';

492: Balance_Type := 'DR';
493: end if;
494:
495: h_mesg_name := 'FA_SHARED_DELETE_FAILED';
496: h_table_token := 'FA_BALANCES_REPORT_GT';
497:
498: -- no longer needed with GT
499: -- DELETE FROM FA_BALANCES_REPORT_GT;
500:

Line 499: -- DELETE FROM FA_BALANCES_REPORT_GT;

495: h_mesg_name := 'FA_SHARED_DELETE_FAILED';
496: h_table_token := 'FA_BALANCES_REPORT_GT';
497:
498: -- no longer needed with GT
499: -- DELETE FROM FA_BALANCES_REPORT_GT;
500:
501: h_table_token := 'FA_LOOKUPS';
502:
503: -- bug 1068054

Line 577: INSERT INTO FA_BALANCES_REPORT_GT

573: -- 'BEGIN');
574:
575: h_mesg_name := 'FA_RX_BEGIN_BALANCES';
576:
577: INSERT INTO FA_BALANCES_REPORT_GT
578: (Asset_ID,
579: Group_Asset_ID, -- Added for Member Track
580: Distribution_CCID,
581: Adjustment_CCID,

Line 726: INSERT INTO FA_BALANCES_REPORT_GT

722:
723:
724: h_mesg_name := 'FA_RX_END_BALANCES';
725:
726: INSERT INTO FA_BALANCES_REPORT_GT
727: (Asset_ID,
728: Group_Asset_ID, -- Added for Drill Down Report
729: Distribution_CCID,
730: Adjustment_CCID,

Line 816: INSERT INTO FA_BALANCES_REPORT_GT

812:
813:
814: h_mesg_name := 'FA_INS_ADJ_GET_VOST_ADJS';
815:
816: INSERT INTO FA_BALANCES_REPORT_GT
817: (Asset_ID,
818: Group_Asset_ID, -- Added for Drill Down Report
819: Distribution_CCID,
820: Adjustment_CCID,

Line 913: INSERT INTO FA_BALANCES_REPORT_GT

909: -- Report_Type);
910:
911: h_mesg_name := 'FA_INS_ADJ_GET_RSV_ADJ';
912:
913: INSERT INTO FA_BALANCES_REPORT_GT
914: (Asset_ID,
915: Group_Asset_ID, -- Added for Drill Down Report
916: Distribution_CCID,
917: Adjustment_CCID,

Line 1038: -- Each FA_BALANCES_REPORT_GT row corresponds to one of the following:

1034: -- close non_qualified_segs;
1035: --
1036: -- mesg := 'Error looping through adjustment ccids';
1037:
1038: -- Each FA_BALANCES_REPORT_GT row corresponds to one of the following:
1039: -- (1) begin balance, (2) end balance, (3) an adjustment, (4)
1040: -- depreciation. Each corresponds to a given account. Sometimes,
1041: -- the account is the default from FA_CATEGORY_BOOKS; in this case
1042: -- the account segment itself is stored here and we can simply select

Line 1072: h_table_token := 'FA_BALANCES_REPORT_GT';

1068: segments => acct_all_segs,
1069: calling_fn => 'FA_BALANCES_REPORT');
1070:
1071: h_mesg_name := 'FA_POST_SQL_UPDATE_TABLE';
1072: h_table_token := 'FA_BALANCES_REPORT_GT';
1073:
1074: update fa_balances_report_gt
1075: set category_books_account = acct_all_segs(gl_account_seg)
1076: where rowid = h_br_rowid;

Line 1074: update fa_balances_report_gt

1070:
1071: h_mesg_name := 'FA_POST_SQL_UPDATE_TABLE';
1072: h_table_token := 'FA_BALANCES_REPORT_GT';
1073:
1074: update fa_balances_report_gt
1075: set category_books_account = acct_all_segs(gl_account_seg)
1076: where rowid = h_br_rowid;
1077:
1078: end if;

Line 1083: -- Now report in data in FA_BALANCES_REPORT_GT (if an accum deprn

1079: end loop;
1080: CLOSE BAL_REPORT_AJCCID;
1081:
1082:
1083: -- Now report in data in FA_BALANCES_REPORT_GT (if an accum deprn
1084: -- or reval reserve report).
1085:
1086: if (report_type in ('RESERVE','REVAL RESERVE')) then
1087:

Line 1293: -- Now report on data in FA_BALANCES_REPORT_GT (for asset cost and

1289:
1290: else
1291:
1292:
1293: -- Now report on data in FA_BALANCES_REPORT_GT (for asset cost and
1294: -- CIP cost reports).
1295:
1296: mesg := 'Error selecting cost balances';
1297: