APPS.FARX_BL dependencies on FA_MC_BOOKS

Line 332: FA_MC_BOOKS B, /* StatReq */

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,
334: FA_ADDITIONS AD,
335: GL_CODE_COMBINATIONS DHCC,
336: GL_CODE_COMBINATIONS AJCC,

Line 531: FA_MC_BOOKS B, /* StatReq */

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,
534: GL_CODE_COMBINATIONS DHCC,
535: GL_CODE_COMBINATIONS AJCC,

Line 538: FA_MC_BOOKS BKG

534: GL_CODE_COMBINATIONS DHCC,
535: GL_CODE_COMBINATIONS AJCC,
536: FA_ADDITIONS AD1, -- This is only used to get Group Asset Number
537: FA_LOOKUPS LU,
538: FA_MC_BOOKS BKG
539: WHERE AD.Asset_ID = BAL.Asset_ID
540: AND DHCC.Code_Combination_ID = BAL.Distribution_CCID
541: AND AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
542: AND B.Book_Type_Code = c_book /* StatReq */

Line 1015: FA_MC_BOOKS BK, -- Added for Member Track

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

Line 1135: FA_MC_BOOKS BK,

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

Line 1330: FA_MC_BOOKS BK,

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

Line 1548: FA_MC_BOOKS BK

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
1551: ,xla_ae_lines lines
1552: ,xla_distribution_links links

Line 1722: FA_MC_BOOKS BK -- Added for Drill Down Report

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