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 210: FA_ASSET_HISTORY AH, /* StatReq */

206: NVL(SUM (DECODE (BAL.Source_Type_Code,
207: 'END', NVL(BAL.Amount,0), NULL)), 0),
208: nvl(AD1.Asset_Number,LU.Meaning) -- Added for Drill Down Report
209: FROM
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,

Line 296: FA_ASSET_HISTORY AH, /* StatReq */

292: SUM (DECODE (BAL.Source_Type_Code,
293: 'END', NVL(BAL.Amount,0), NULL)),
294: nvl(AD1.Asset_Number,LU.Meaning) -- This is for Group Asset ID
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,

Line 613: FA_ASSET_HISTORY AH,

609: DD.COST
610: FROM
611: FA_CATEGORY_BOOKS CB,
612: FA_DISTRIBUTION_HISTORY DH,
613: FA_ASSET_HISTORY AH,
614: FA_DEPRN_DETAIL DD,
615: FA_BOOKS BK -- Added for Member Track
616: WHERE DH.Book_Type_Code = Distribution_Source_Book
617: AND DD.Asset_ID = AH.Asset_ID AND

Line 690: FA_ASSET_HISTORY AH,

686: DD.COST
687: FROM
688: FA_CATEGORY_BOOKS CB,
689: FA_DISTRIBUTION_HISTORY DH,
690: FA_ASSET_HISTORY AH,
691: FA_DEPRN_DETAIL DD,
692: FA_BOOKS BK,
693: FA_DEPRN_PERIODS DP_BROW
694: WHERE DH.Book_Type_Code = distribution_source_book

Line 760: FA_ASSET_HISTORY AH,

756: 'REVAL RESERVE', DD.Reval_Reserve)
757: FROM
758: FA_CATEGORY_BOOKS CB,
759: FA_DISTRIBUTION_HISTORY DH,
760: FA_ASSET_HISTORY AH,
761: FA_DEPRN_DETAIL DD,
762: FA_BOOKS BK
763: WHERE DH.Book_Type_Code = Distribution_Source_Book
764: AND DD.Asset_ID = AH.Asset_ID AND

Line 837: FA_ASSET_HISTORY AH1,

833: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
834: AJ.Adjustment_Amount)
835: FROM FA_LOOKUPS RT,
836: FA_CATEGORY_BOOKS CB,
837: FA_ASSET_HISTORY AH1,
838: FA_DISTRIBUTION_HISTORY DH,
839: FA_TRANSACTION_HEADERS TH,
840: FA_ASSET_HISTORY AH,
841: FA_ADJUSTMENTS AJ,

Line 840: FA_ASSET_HISTORY AH,

836: FA_CATEGORY_BOOKS CB,
837: FA_ASSET_HISTORY AH1,
838: FA_DISTRIBUTION_HISTORY DH,
839: FA_TRANSACTION_HEADERS TH,
840: FA_ASSET_HISTORY AH,
841: FA_ADJUSTMENTS AJ,
842: FA_BOOKS BK
843:
844: /* SLA changes */

Line 938: FA_ASSET_HISTORY AH,

934: 'REVAL RESERVE', -DD.Reval_Amortization))
935: FROM FA_LOOKUPS RT,
936: FA_CATEGORY_BOOKS CB,
937: FA_DISTRIBUTION_HISTORY DH,
938: FA_ASSET_HISTORY AH,
939: FA_DEPRN_DETAIL DD,
940: FA_DEPRN_PERIODS DP,
941: FA_BOOKS BK -- Added for Drill Down Report
942: WHERE DH.Book_Type_Code = Distribution_Source_Book