APPS.FARX_BL dependencies on FA_BOOKS

Line 213: FA_BOOKS B, /* StatReq */

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,
216: GL_CODE_COMBINATIONS DHCC,
217: GL_CODE_COMBINATIONS AJCC,

Line 298: FA_BOOKS B, /* StatReq */

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,
301: GL_CODE_COMBINATIONS DHCC,
302: GL_CODE_COMBINATIONS AJCC,

Line 615: FA_BOOKS BK -- Added for Member Track

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
618: DD.Book_Type_Code = Book AND
619: DD.Distribution_ID = DH.Distribution_ID AND

Line 692: FA_BOOKS BK,

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

Line 762: FA_BOOKS BK

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
765: DD.Book_Type_Code = Book AND
766: DD.Distribution_ID = DH.Distribution_ID AND

Line 842: FA_BOOKS BK

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 */
845: ,xla_ae_headers headers
846: ,xla_ae_lines lines

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

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