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_ASSET_HISTORY

Line 218: FA_ASSET_HISTORY AH, /* StatReq */

214: 'TRANSFER', NVL(BAL.Amount,0), NULL)),
215: NVL(SUM (DECODE (BAL.Source_Type_Code,
216: 'END', NVL(BAL.Amount,0), NULL)), 0) /*Bug# 9293000 */
217: FROM
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,

Line 241: from fa_asset_history ah1

237: AND AH.ASSET_ID = AD.ASSET_ID
238: /* Commented for bug #5015612. It was cousing No data found in Rxi: Asset Cost Balance Reprort.
239: -- Added for bug#4860955
240: and ah.transaction_header_id_in = ( select min(ah1.transaction_header_id_in)
241: from fa_asset_history ah1
242: where ah1.asset_id=ah.asset_id
243: and ah1.category_id=ah.category_id
244: and ah1.asset_type='CIP') */
245: and ah.category_id = cb.category_id

Line 254: from fa_asset_history ah1,

250: -- Added for bug #5015612
251: --bug 6668625
252: -- Bug#9384471 Modified for displaying correct category after reclass
253: and ah.transaction_header_id_in = ( select max(ah1.transaction_header_id_in)
254: from fa_asset_history ah1,
255: fa_category_books cb1
256: where ah1.asset_id=ah.asset_id
257: -- and ah1.category_id=ah.category_id Bug#9384471
258: and ah1.asset_type=decode(report_type,'CIP COST','CIP',

Line 329: FA_ASSET_HISTORY AH, /* StatReq */

325: 'TRANSFER', NVL(BAL.Amount,0), NULL)),
326: NVL(SUM (DECODE (BAL.Source_Type_Code,
327: 'END', NVL(BAL.Amount,0), NULL)), 0) /*Bug# 9293000 */
328: FROM
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,

Line 352: from fa_asset_history ah1

348: AND AH.ASSET_ID = AD.ASSET_ID
349: /* Commented for bug #5015612. It was cousing No data found in Rxi: Asset Cost Balance Reprort.
350: -- Added for bug#4860955
351: and ah.transaction_header_id_in = ( select min(ah1.transaction_header_id_in)
352: from fa_asset_history ah1
353: where ah1.asset_id=ah.asset_id
354: and ah1.category_id=ah.category_id
355: and ah1.asset_type='CIP') */
356: and ah.category_id = cb.category_id

Line 364: from fa_asset_history ah1,

360: and nvl(ah.date_effective,c_to_date) <= c_to_date
361: -- Added for bug #5015612
362: --bug 6668625
363: and ah.transaction_header_id_in = ( select max(ah1.transaction_header_id_in)
364: from fa_asset_history ah1,
365: fa_category_books cb1
366: where ah1.asset_id=ah.asset_id
367: -- and ah1.category_id=ah.category_id Bug#9384471
368: and ah1.asset_type=decode(report_type,'CIP COST','CIP',

Line 443: FA_ASSET_HISTORY AH, /* StatReq */

439: 'TRANSFER', NVL(BAL.Amount,0), NULL)),
440: SUM (DECODE (BAL.Source_Type_Code,
441: 'END', NVL(BAL.Amount,0), NULL)) /*Bug# 9293000 */
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,

Line 529: FA_ASSET_HISTORY AH, /* StatReq */

525: 'TRANSFER', NVL(BAL.Amount,0), NULL)),
526: SUM (DECODE (BAL.Source_Type_Code,
527: 'END', NVL(BAL.Amount,0), NULL))/*Bug# 9293000 */
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,

Line 828: FA_ASSET_HISTORY AH,

824: DD.COST
825: FROM
826: FA_CATEGORY_BOOKS CB,
827: FA_DISTRIBUTION_HISTORY DH,
828: FA_ASSET_HISTORY AH,
829: FA_DEPRN_DETAIL DD,
830: FA_BOOKS BK, -- Added for Member Track
831: FA_ADJUSTMENTS AJ
832: WHERE DH.Book_Type_Code = Distribution_Source_Book

Line 943: FA_ASSET_HISTORY AH,

939: DD.COST
940: FROM
941: FA_CATEGORY_BOOKS CB,
942: FA_DISTRIBUTION_HISTORY DH,
943: FA_ASSET_HISTORY AH,
944: FA_DEPRN_DETAIL DD,
945: FA_BOOKS BK,
946: FA_DEPRN_PERIODS DP_BROW
947: WHERE DH.Book_Type_Code = distribution_source_book

Line 1013: FA_ASSET_HISTORY AH,

1009: DD.COST
1010: FROM
1011: FA_CATEGORY_BOOKS CB,
1012: FA_DISTRIBUTION_HISTORY DH,
1013: FA_ASSET_HISTORY AH,
1014: FA_MC_DEPRN_DETAIL DD,
1015: FA_MC_BOOKS BK, -- Added for Member Track
1016: FA_MC_ADJUSTMENTS AJ
1017: WHERE DH.Book_Type_Code = Distribution_Source_Book

Line 1133: FA_ASSET_HISTORY AH,

1129: DD.COST
1130: FROM
1131: FA_CATEGORY_BOOKS CB,
1132: FA_DISTRIBUTION_HISTORY DH,
1133: FA_ASSET_HISTORY AH,
1134: FA_MC_DEPRN_DETAIL DD,
1135: FA_MC_BOOKS BK,
1136: FA_MC_DEPRN_PERIODS DP_BROW
1137: WHERE DH.Book_Type_Code = distribution_source_book

Line 1205: FA_ASSET_HISTORY AH,

1201: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1202: FROM
1203: FA_CATEGORY_BOOKS CB,
1204: FA_DISTRIBUTION_HISTORY DH,
1205: FA_ASSET_HISTORY AH,
1206: FA_DEPRN_DETAIL DD,
1207: FA_BOOKS BK,
1208: FA_ADJUSTMENTS AJ
1209: WHERE DH.Book_Type_Code = Distribution_Source_Book

Line 1328: FA_ASSET_HISTORY AH,

1324: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1325: FROM
1326: FA_CATEGORY_BOOKS CB,
1327: FA_DISTRIBUTION_HISTORY DH,
1328: FA_ASSET_HISTORY AH,
1329: FA_MC_DEPRN_DETAIL DD,
1330: FA_MC_BOOKS BK,
1331: FA_MC_ADJUSTMENTS AJ
1332: WHERE DH.Book_Type_Code = Distribution_Source_Book

Line 1448: FA_ASSET_HISTORY AH1,

1444: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1445: AJ.Adjustment_Amount)
1446: FROM
1447: FA_CATEGORY_BOOKS CB,
1448: FA_ASSET_HISTORY AH1,
1449: FA_DISTRIBUTION_HISTORY DH,
1450: FA_TRANSACTION_HEADERS TH,
1451: FA_ASSET_HISTORY AH,
1452: FA_ADJUSTMENTS AJ,

Line 1451: FA_ASSET_HISTORY AH,

1447: FA_CATEGORY_BOOKS CB,
1448: FA_ASSET_HISTORY AH1,
1449: FA_DISTRIBUTION_HISTORY DH,
1450: FA_TRANSACTION_HEADERS TH,
1451: FA_ASSET_HISTORY AH,
1452: FA_ADJUSTMENTS AJ,
1453: FA_BOOKS BK
1454: /* SLA changes */
1455: ,xla_ae_headers headers

Line 1543: FA_ASSET_HISTORY AH1,

1539: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1540: AJ.Adjustment_Amount)
1541: FROM
1542: FA_CATEGORY_BOOKS CB,
1543: FA_ASSET_HISTORY AH1,
1544: FA_DISTRIBUTION_HISTORY DH,
1545: FA_TRANSACTION_HEADERS TH,
1546: FA_ASSET_HISTORY AH,
1547: FA_MC_ADJUSTMENTS AJ,

Line 1546: FA_ASSET_HISTORY AH,

1542: FA_CATEGORY_BOOKS CB,
1543: FA_ASSET_HISTORY AH1,
1544: FA_DISTRIBUTION_HISTORY DH,
1545: FA_TRANSACTION_HEADERS TH,
1546: FA_ASSET_HISTORY AH,
1547: FA_MC_ADJUSTMENTS AJ,
1548: FA_MC_BOOKS BK
1549: /* SLA changes */
1550: ,xla_ae_headers headers

Line 1647: FA_ASSET_HISTORY AH,

1643: 'REVAL RESERVE', -DD.Reval_Amortization))
1644: FROM
1645: FA_CATEGORY_BOOKS CB,
1646: FA_DISTRIBUTION_HISTORY DH,
1647: FA_ASSET_HISTORY AH,
1648: FA_DEPRN_DETAIL DD,
1649: FA_DEPRN_PERIODS DP,
1650: FA_BOOKS BK -- Added for Drill Down Report
1651: WHERE DH.Book_Type_Code = Distribution_Source_Book

Line 1719: FA_ASSET_HISTORY AH,

1715: 'REVAL RESERVE', -DD.Reval_Amortization))
1716: FROM
1717: FA_CATEGORY_BOOKS CB,
1718: FA_DISTRIBUTION_HISTORY DH,
1719: FA_ASSET_HISTORY AH,
1720: FA_MC_DEPRN_DETAIL DD,
1721: FA_MC_DEPRN_PERIODS DP,
1722: FA_MC_BOOKS BK -- Added for Drill Down Report
1723: WHERE DH.Book_Type_Code = Distribution_Source_Book