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.FA_QUERY_BALANCES_PKG dependencies on FA_BOOKS

Line 74: from fa_books

70: H_SUCCESS BOOLEAN;
71:
72: cursor c_get_group_info is
73: select group_asset_id, member_rollup_flag
74: from fa_books
75: where asset_id = X_ASSET_ID
76: and book_type_code = X_BOOK
77: and transaction_header_id_out is null;
78:

Line 940: from fa_books bk

936: sum(NVL(CAPITAL_ADJUSTMENT,0)), --Bug 6666666
937: sum(NVL(GENERAL_FUND,0)) --Bug 6666666
938: FROM FA_MC_DEPRN_SUMMARY DS
939: WHERE DS.ASSET_ID in (select bk.asset_id
940: from fa_books bk
941: where bk.book_type_code = x_dpr_row.book
942: and bk.transaction_header_id_out is null
943: and bk.group_asset_id = x_dpr_row.asset_id)
944: AND DS.BOOK_TYPE_CODE = X_dpr_row.book

Line 1013: from fa_books bk

1009: sum(NVL(CAPITAL_ADJUSTMENT,0)), --Bug 6666666
1010: sum(NVL(GENERAL_FUND,0)) --Bug 6666666
1011: FROM FA_DEPRN_SUMMARY DS
1012: WHERE DS.ASSET_ID in (select bk.asset_id
1013: from fa_books bk
1014: where bk.book_type_code = x_dpr_row.book
1015: and bk.transaction_header_id_out is null
1016: and bk.group_asset_id = x_dpr_row.asset_id)
1017: AND DS.BOOK_TYPE_CODE = X_dpr_row.book

Line 2110: from fa_books bk

2106: X_ADJ_ROW.general_fund, --Bug 6666666
2107: h_num_adjs
2108: FROM FA_ADJUSTMENTS ADJ
2109: WHERE ADJ.ASSET_ID in (select bk.asset_id
2110: from fa_books bk
2111: where bk.book_type_code = x_adj_row.book
2112: and bk.transaction_header_id_out is null
2113: and bk.group_asset_id = x_adj_row.asset_id) AND
2114: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND