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 64: h_account FA_BALANCES_REPORT_GT.Category_Books_Account%TYPE; --bug 8432604

60: h_login_id number;
61: h_request_id number;
62:
63: h_ccid number;
64: h_account FA_BALANCES_REPORT_GT.Category_Books_Account%TYPE; --bug 8432604
65: h_ajccid number;
66: h_asset FA_ADDITIONS.Asset_Number%TYPE; --bug 8432604
67: h_tag_number FA_ADDITIONS.tag_number%TYPE; --bug 8432604
68: h_serial_number FA_ADDITIONS.serial_number%TYPE; --bug 8432604

Line 136: h_Cost_Account FA_BALANCES_REPORT_GT.Cost_Account%TYPE; --bug8432604 /* StatReq */

132: h_rate_source_rule FA_METHODS.rate_source_rule%TYPE; --bug8432604 /* StatReq */
133:
134: h_method_code FA_METHODS.method_code%TYPE; --bug8432604 /* StatReq */
135:
136: h_Cost_Account FA_BALANCES_REPORT_GT.Cost_Account%TYPE; --bug8432604 /* StatReq */
137: h_Cost_Begin_Balance NUMBER; /* StatReq */
138: h_location VARCHAR2(1500); /* StatReq */
139:
140: -- bug 5944006 (Increased length to 1500 from 500 for following variables)

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

164: h_sob_id NUMBER;
165: h_mrcsobtype VARCHAR2(1);
166: -- End MRC
167:
168: -- Used in finding account segments for FA_BALANCES_REPORT_GT
169:
170: CURSOR BAL_REPORT_AJCCID IS
171: SELECT DISTINCT ADJUSTMENT_CCID, CATEGORY_BOOKS_ACCOUNT, ROWID
172: FROM FA_BALANCES_REPORT_GT;

Line 172: FROM FA_BALANCES_REPORT_GT;

168: -- Used in finding account segments for FA_BALANCES_REPORT_GT
169:
170: CURSOR BAL_REPORT_AJCCID IS
171: SELECT DISTINCT ADJUSTMENT_CCID, CATEGORY_BOOKS_ACCOUNT, ROWID
172: FROM FA_BALANCES_REPORT_GT;
173:
174: -- Main selector from FA_BALANCES_REPORT_GT for asset cost
175: -- and CIP cost reports.
176:

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

170: CURSOR BAL_REPORT_AJCCID IS
171: SELECT DISTINCT ADJUSTMENT_CCID, CATEGORY_BOOKS_ACCOUNT, ROWID
172: FROM FA_BALANCES_REPORT_GT;
173:
174: -- Main selector from FA_BALANCES_REPORT_GT for asset cost
175: -- and CIP cost reports.
176:
177: CURSOR COST_REPORT (c_book VARCHAR2, c_to_date DATE, c_from_date DATE) IS /* StatReq */
178: SELECT DISTINCT

Line 222: FA_BALANCES_REPORT_GT BAL,

218: FA_ASSET_HISTORY AH, /* StatReq */
219: fa_category_books cb,
220: FA_METHODS M, /* StatReq */
221: FA_BOOKS B, /* StatReq */
222: FA_BALANCES_REPORT_GT BAL,
223: FA_ADDITIONS AD,
224: GL_CODE_COMBINATIONS DHCC,
225: GL_CODE_COMBINATIONS AJCC,
226: FA_ADDITIONS AD1,

Line 333: FA_BALANCES_REPORT_GT BAL,

329: FA_ASSET_HISTORY AH, /* StatReq */
330: fa_category_books cb,
331: FA_METHODS M, /* StatReq */
332: FA_MC_BOOKS B, /* StatReq */
333: FA_BALANCES_REPORT_GT BAL,
334: FA_ADDITIONS AD,
335: GL_CODE_COMBINATIONS DHCC,
336: GL_CODE_COMBINATIONS AJCC,
337: FA_ADDITIONS AD1,

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

395: m.stl_method_flag,
396: m.rate_source_rule;
397: -- End MRC
398:
399: -- Main selector from FA_BALANCES_REPORT_GT for accum deprn
400: -- and reval reserve reports.
401:
402:
403: CURSOR RESERVE_REPORT (c_book VARCHAR2, c_to_date DATE) IS /* StatReq */

Line 446: FA_BALANCES_REPORT_GT BAL,

442: FROM
443: FA_ASSET_HISTORY AH, /* StatReq */
444: FA_METHODS M, /* StatReq */
445: FA_BOOKS B, /* StatReq */
446: FA_BALANCES_REPORT_GT BAL,
447: FA_ADDITIONS AD,
448: GL_CODE_COMBINATIONS DHCC,
449: GL_CODE_COMBINATIONS AJCC,
450: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number

Line 532: FA_BALANCES_REPORT_GT BAL,

528: FROM
529: FA_ASSET_HISTORY AH, /* StatReq */
530: FA_METHODS M, /* StatReq */
531: FA_MC_BOOKS B, /* StatReq */
532: FA_BALANCES_REPORT_GT BAL,
533: FA_ADDITIONS AD,
534: GL_CODE_COMBINATIONS DHCC,
535: GL_CODE_COMBINATIONS AJCC,
536: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number

Line 597: FROM FA_BALANCES_REPORT_GT BAL

593:
594: -- Cursor for Drill Down Report
595: CURSOR GROUP_ASSETS IS
596: SELECT DISTINCT BAL.Group_Asset_ID Group_Asset_ID
597: FROM FA_BALANCES_REPORT_GT BAL
598: WHERE BAL.Asset_ID = BAL.Group_Asset_ID;
599:
600: CURSOR GROUP_RESERVE_AMOUNTS (p_group_asset_id number) is
601: SELECT

Line 604: FROM FA_BALANCES_REPORT_GT BAL

600: CURSOR GROUP_RESERVE_AMOUNTS (p_group_asset_id number) is
601: SELECT
602: NVL(SUM(DECODE(BAL.Source_Type_Code,
603: 'BEGIN', NVL(BAL.Cost_Begin_Balance, 0), NULL)), 0) /* StatReq */
604: FROM FA_BALANCES_REPORT_GT BAL
605: WHERE BAL.Group_Asset_id = p_group_asset_id
606: AND BAL.Group_Asset_id <> BAL.Asset_id;
607:
608: CURSOR GROUP_COST_AMOUNTS (p_group_asset_id number) is

Line 634: FROM FA_BALANCES_REPORT_GT BAL

630: SUM (DECODE (BAL.Source_Type_Code,
631: 'TRANSFER', NVL(BAL.Amount,0), NULL)),
632: NVL(SUM (DECODE (BAL.Source_Type_Code,
633: 'END', NVL(BAL.Amount,0), NULL)), 0)
634: FROM FA_BALANCES_REPORT_GT BAL
635: WHERE BAL.Group_Asset_id = p_group_asset_id
636: AND BAL.Group_Asset_id <> BAL.Asset_id;
637:
638: -- cursor non_qualified_segs is

Line 759: h_table_token := 'FA_BALANCES_REPORT_GT';

755: Balance_Type := 'DR';
756: end if;
757:
758: h_mesg_name := 'FA_SHARED_DELETE_FAILED';
759: h_table_token := 'FA_BALANCES_REPORT_GT';
760:
761: -- no longer needed with GT
762: -- DELETE FROM FA_BALANCES_REPORT_GT;
763:

Line 762: -- DELETE FROM FA_BALANCES_REPORT_GT;

758: h_mesg_name := 'FA_SHARED_DELETE_FAILED';
759: h_table_token := 'FA_BALANCES_REPORT_GT';
760:
761: -- no longer needed with GT
762: -- DELETE FROM FA_BALANCES_REPORT_GT;
763:
764: h_table_token := 'FA_LOOKUPS';
765:
766: /* StatReq - Added category flex structure to the following

Line 789: INSERT INTO FA_BALANCES_REPORT_GT

785:
786: h_mesg_name := 'FA_RX_BEGIN_BALANCES';
787:
788: if(h_mrcsobtype <> 'R') then -- MRC
789: INSERT INTO FA_BALANCES_REPORT_GT
790: (Asset_ID,
791: Group_Asset_ID, -- Added for Member Track
792: Distribution_CCID,
793: Adjustment_CCID,

Line 974: INSERT INTO FA_BALANCES_REPORT_GT

970: NVL(BK.Date_Ineffective, sysdate);
971:
972: -- MRC
973: else
974: INSERT INTO FA_BALANCES_REPORT_GT
975: (Asset_ID,
976: Group_Asset_ID, -- Added for Member Track
977: Distribution_CCID,
978: Adjustment_CCID,

Line 1169: INSERT INTO FA_BALANCES_REPORT_GT

1165: -- End MRC
1166:
1167: h_mesg_name := 'FA_RX_END_BALANCES';
1168: if(h_mrcsobtype <> 'R') then -- MRC
1169: INSERT INTO FA_BALANCES_REPORT_GT
1170: (Asset_ID,
1171: Group_Asset_ID, -- Added for Drill Down Report
1172: Distribution_CCID,
1173: Adjustment_CCID,

Line 1292: INSERT INTO FA_BALANCES_REPORT_GT

1288: 'REVAL RESERVE', DD.Reval_Reserve) ;
1289:
1290: -- MRC
1291: else
1292: INSERT INTO FA_BALANCES_REPORT_GT
1293: (Asset_ID,
1294: Group_Asset_ID, -- Added for Drill Down Report
1295: Distribution_CCID,
1296: Adjustment_CCID,

Line 1423: INSERT INTO FA_BALANCES_REPORT_GT

1419:
1420: h_mesg_name := 'FA_INS_ADJ_GET_VOST_ADJS';
1421:
1422: if(h_mrcsobtype <> 'R') then -- MRC
1423: INSERT INTO FA_BALANCES_REPORT_GT
1424: (Asset_ID,
1425: Group_Asset_ID, -- Added for Drill Down Report
1426: Distribution_CCID,
1427: Adjustment_CCID,

Line 1518: INSERT INTO FA_BALANCES_REPORT_GT

1514: AJ.Source_Type_Code;
1515:
1516: -- MRC
1517: else
1518: INSERT INTO FA_BALANCES_REPORT_GT
1519: (Asset_ID,
1520: Group_Asset_ID, -- Added for Drill Down Report
1521: Distribution_CCID,
1522: Adjustment_CCID,

Line 1622: INSERT INTO FA_BALANCES_REPORT_GT

1618: -- Report_Type);
1619:
1620: h_mesg_name := 'FA_INS_ADJ_GET_RSV_ADJ';
1621: if(h_mrcsobtype <> 'R') then -- MRC
1622: INSERT INTO FA_BALANCES_REPORT_GT
1623: (Asset_ID,
1624: Group_Asset_ID, -- Added for Drill Down Report
1625: Distribution_CCID,
1626: Adjustment_CCID,

Line 1694: INSERT INTO FA_BALANCES_REPORT_GT

1690: DD.Deprn_Source_Code;
1691:
1692: -- MRC
1693: else
1694: INSERT INTO FA_BALANCES_REPORT_GT
1695: (Asset_ID,
1696: Group_Asset_ID, -- Added for Drill Down Report
1697: Distribution_CCID,
1698: Adjustment_CCID,

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

1820: -- close non_qualified_segs;
1821: --
1822: -- mesg := 'Error looping through adjustment ccids';
1823:
1824: -- Each FA_BALANCES_REPORT_GT row corresponds to one of the following:
1825: -- (1) begin balance, (2) end balance, (3) an adjustment, (4)
1826: -- depreciation. Each corresponds to a given account. Sometimes,
1827: -- the account is the default from FA_CATEGORY_BOOKS; in this case
1828: -- the account segment itself is stored here and we can simply select

Line 1858: h_table_token := 'FA_BALANCES_REPORT_GT';

1854: segments => acct_all_segs,
1855: calling_fn => 'FA_BALANCES_REPORT');
1856:
1857: h_mesg_name := 'FA_POST_SQL_UPDATE_TABLE';
1858: h_table_token := 'FA_BALANCES_REPORT_GT';
1859:
1860: update fa_balances_report_gt
1861: set category_books_account = acct_all_segs(gl_account_seg)
1862: where rowid = h_br_rowid;

Line 1860: update fa_balances_report_gt

1856:
1857: h_mesg_name := 'FA_POST_SQL_UPDATE_TABLE';
1858: h_table_token := 'FA_BALANCES_REPORT_GT';
1859:
1860: update fa_balances_report_gt
1861: set category_books_account = acct_all_segs(gl_account_seg)
1862: where rowid = h_br_rowid;
1863:
1864: end if;

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

1865: end loop;
1866: CLOSE BAL_REPORT_AJCCID;
1867:
1868:
1869: -- Now report in data in FA_BALANCES_REPORT_GT (if an accum deprn
1870: -- or reval reserve report).
1871:
1872: if (report_type in ('RESERVE','REVAL RESERVE')) then
1873:

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

2149: /* commented for 10131111 */
2150: else
2151:
2152:
2153: -- Now report on data in FA_BALANCES_REPORT_GT (for asset cost and
2154: -- CIP cost reports).
2155:
2156: mesg := 'Error selecting cost balances';
2157: