APPS.FARX_BL dependencies on FA_BOOKS

Line 221: FA_BOOKS B, /* StatReq */

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,
223: FA_ADDITIONS AD,
224: GL_CODE_COMBINATIONS DHCC,
225: GL_CODE_COMBINATIONS AJCC,

Line 445: FA_BOOKS B, /* StatReq */

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,
448: GL_CODE_COMBINATIONS DHCC,
449: GL_CODE_COMBINATIONS AJCC,

Line 452: FA_BOOKS BKG

448: GL_CODE_COMBINATIONS DHCC,
449: GL_CODE_COMBINATIONS AJCC,
450: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
451: FA_LOOKUPS LU,
452: FA_BOOKS BKG
453: WHERE AD.Asset_ID = BAL.Asset_ID
454: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
455: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
456: AND B.Book_Type_Code = c_book /* StatReq */

Line 830: FA_BOOKS BK, -- Added for Member Track

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
833: AND DD.Asset_ID = AH.Asset_ID AND
834: DD.Book_Type_Code = Book AND

Line 945: FA_BOOKS BK,

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
948: AND DD.Asset_ID = AH.Asset_ID AND
949: DD.Book_Type_Code = book AND

Line 1207: FA_BOOKS BK,

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
1210: AND DD.Asset_ID = AH.Asset_ID AND
1211: DD.Book_Type_Code = Book AND

Line 1453: FA_BOOKS BK

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
1456: ,xla_ae_lines lines
1457: ,xla_distribution_links links

Line 1650: FA_BOOKS BK -- Added for Drill Down Report

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
1652: AND AH.Asset_ID = DH.Asset_ID
1653: AND ((AH.Asset_Type in ('CAPITALIZED', 'GROUP')) OR
1654: AH.Asset_Type <> 'EXPENSED' AND nvl(Report_Style,'S') = 'D') -- Added for Drill Down Report