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_CATEGORY_BOOKS

Line 211: fa_category_books cb,

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,
215: FA_ADDITIONS AD,

Line 611: FA_CATEGORY_BOOKS CB,

607: 'RESERVE', DD.Deprn_Reserve,
608: 'REVAL RESERVE', DD.Reval_Reserve),
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

Line 688: FA_CATEGORY_BOOKS CB,

684: 'RESERVE', DD.Deprn_Reserve,
685: 'REVAL RESERVE', DD.Reval_Reserve),
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,

Line 758: FA_CATEGORY_BOOKS CB,

754: 'CIP COST', DD.Cost,
755: 'RESERVE', DD.Deprn_Reserve,
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

Line 836: FA_CATEGORY_BOOKS CB,

832: AJ.Source_Type_Code,
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,

Line 936: FA_CATEGORY_BOOKS CB,

932: SUM (DECODE (RT.Lookup_Code,
933: 'RESERVE', DD.Deprn_Amount,
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,

Line 1041: -- the account is the default from FA_CATEGORY_BOOKS; in this case

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
1043: -- it later. However, sometimes the "account" is stored as a ccid.
1044: -- In this case, we must find the accounting segment corresponding
1045: -- to that ccid, and store it now, so we can select it later.